How to check the concurrent request to SQL server

• Lanny Irwan

  Ten Centuries

  Points: 1020

  More actions

  April 10, 2008 at 2:27 am

  #71544

  Dear All,

  I would need your input on how to check the no of concurrent request on our SQL server.

  Cheers,

• SQLZ

  SSChampion

  Points: 12872

  More actions

  April 10, 2008 at 2:46 am

  #800816

  Lanny Irwan (4/10/2008)

  ---

  Dear All,

  I would need your input on how to check the no of concurrent request on our SQL server.

  Cheers,

  What do you mean by "request"?

  You can use performance monitor to measure various counters - Transactions per second, batch requests per second, active transactions.

  Karl
  source control for SQL Server

• Lanny Irwan

  Ten Centuries

  Points: 1020

  More actions

  April 10, 2008 at 4:09 am

  #800857

  Hi,

  This statement is extracted from the following url:

  http://technet.microsoft.com/en-us/library/cc298578.aspx

  The above url is a guideline on choosing the hardware for SQL server 2005.

  Here are the complete statement:

  "Number of concurrent requests to SQL server 2005"

  I would like to know how to get this information.

  Cheers,