Viewing Server Performance with PerfMon and the PAL Tool - SQL Server 2012 Internals and Troubleshooting - page 264

TABLE 10-1 (continued)

COUNTER DESCRIPTION

Batch Resp
Statistics

Batches >=000000ms & <000001ms Number of SQL Batches with a response time

greater than or equal to 0ms but less than 1ms

Batches >=000001ms & <000002ms Number of SQL Batches with a response time

greater than or equal to 1ms but less than 2ms

Batches >=000002ms & <000005ms Number of SQL Batches with a response time

greater than or equal to 2ms but less than 5ms

Batches >=000005ms & <000010ms Number of SQL Batches with a response time

greater than or equal to 5ms but less than 10ms

Batches >=000010ms & <000020ms Number of SQL Batches with a response time

greater than or equal to 10ms but less than
20ms

Batches >=000020ms & <000050ms Number of SQL Batches with a response time

greater than or equal to 20ms but less than
50ms

Batches >=000050ms & <000100ms Number of SQL Batches with a response time

greater than or equal to 50ms but less than
100ms

Batches >=000100ms & <000200ms Number of SQL Batches with a response time

greater than or equal to 100ms but less than
200ms

Batches >=000200ms & <000500ms Number of SQL Batches with a response time

greater than or equal to 200ms but less than
500ms

Batches >=000500ms & <001000ms Number of SQL Batches with a response time

greater than or equal to 500ms but less than
1,000ms

Batches >=001000ms & <002000ms Number of SQL Batches with a response time

greater than or equal to 1,000ms but less than
2,000ms

Batches >=002000ms & <005000ms Number of SQL Batches with a response time

greater than or equal to 2,000ms but less than
5,000ms

Batches >=005000ms & <010000ms Number of SQL Batches with a response time

greater than or equal to 5,000ms but less than
10,000ms