Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
The SQLServer:Batch Resp Statistics performance object provides counters to track SQL Server batch response times.
This following table describes the SQL Server Batch Resp Statistics performance objects.
| SQL Server Batch Resp Statistics counter | Description |
|---|---|
| Batches >=000000ms & <000001ms | Number of SQL Batches having response time greater than or equal to 0 ms but less than 1 ms |
| Batches >=000001ms & <000002ms | Number of SQL Batches having response time greater than or equal to 1 ms but less than 2 ms |
| Batches >=000002ms & <000005ms | Number of SQL Batches having response time greater than or equal to 2 ms but less than 5 ms |
| Batches >=000005ms & <000010ms | Number of SQL Batches having response time greater than or equal to 5 ms but less than 10 ms |
| Batches >=000010ms & <000020ms | Number of SQL Batches having response time greater than or equal to 10 ms but less than 20 ms |
| Batches >=000020ms & <000050ms | Number of SQL Batches having response time greater than or equal to 20 ms but less than 50 ms |
| Batches >=000050ms & <000100ms | Number of SQL Batches having response time greater than or equal to 50 ms but less than 100 ms |
| Batches >=000100ms & <000200ms | Number of SQL Batches having response time greater than or equal to 100 ms but less than 200 ms |
| Batches >=000200ms & <000500ms | Number of SQL Batches having response time greater than or equal to 200 ms but less than 500 ms |
| Batches >=000500ms & <001000ms | Number of SQL Batches having response time greater than or equal to 500 ms but less than 1,000 ms |
| Batches >=001000ms & <002000ms | Number of SQL Batches having response time greater than or equal to 1,000 ms but less than 2,000 ms |
| Batches >=002000ms & <005000ms | Number of SQL Batches having response time greater than or equal to 2,000 ms but less than 5,000 ms |
| Batches >=005000ms & <010000ms | Number of SQL Batches having response time greater than or equal to 5,000 ms but less than 10,000 ms |
| Batches >=010000ms & <020000ms | Number of SQL Batches having response time greater than or equal to 10,000 ms but less than 20,000 ms |
| Batches >=020000ms & <050000ms | Number of SQL Batches having response time greater than or equal to 20,000 ms but less than 50,000 ms |
| Batches >=050000ms & <100000ms | Number of SQL Batches having response time greater than or equal to 50,000 ms but less than 100,000 ms |
| Batches >=100000ms | Number of SQL Batches having response time greater than or equal to 100,000 ms |
Each counter in the object contains the following instances:
| Item | Description |
|---|---|
| CPU Time:Requests | The number of requests based on CPU time. |
| CPU Time:Total(ms) | The total time the CPU spent on the batch. |
| Elapsed Time:Requests | The number of requests based on elapsed time. |
| Elapsed Time:Total(ms) | The elapsed time of the batch. |
Example
You begin to explore the query performance counters in this object using this T-SQL query on the sys.dm_os_performance_counters dynamic management view:
SELECT * FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%Batch Resp Statistics%';