SQL Server, 일괄 처리 응답 통계 개체SQL Server, Batch Resp Statistics Object

SQLServer:Batch Resp Statistics 성능 개체는 SQL Server 일괄 처리 응답 시간을 추적하는 카운터를 제공합니다.The SQLServer:Batch Resp Statistics performance object provides counters to track SQL Server batch response times.

다음 표에서는 SQL Server에 Batch Resp Statistics 성능 개체에 대해 설명합니다.This following table describes the SQL Server Batch Resp Statistics performance objects.

SQL Server Batch Resp Statistics 카운터SQL Server Batch Resp Statistics counters DescriptionDescription
Batches >=000000ms & <000001msBatches >=000000ms & <000001ms 응답 시간이 0ms보다 크거나 같고 1ms보다 작은 SQL 일괄 처리 수Number of SQL Batches having response time greater than or equal to 0ms but less than 1ms
Batches >=000001ms & <000002msBatches >=000001ms & <000002ms 응답 시간이 1ms보다 크거나 같고 2ms보다 작은 SQL 일괄 처리 수Number of SQL Batches having response time greater than or equal to 1ms but less than 2ms
Batches >=000002ms & <000005msBatches >=000002ms & <000005ms 응답 시간이 2ms보다 크거나 같고 5ms보다 작은 SQL 일괄 처리 수Number of SQL Batches having response time greater than or equal to 2ms but less than 5ms
Batches >=000005ms & <000010msBatches >=000005ms & <000010ms 응답 시간이 5ms보다 크거나 같고 10ms보다 작은 SQL 일괄 처리 수Number of SQL Batches having response time greater than or equal to 5ms but less than 10ms
Batches >=000010ms & <000020msBatches >=000010ms & <000020ms 응답 시간이 10ms보다 크거나 같고 20ms보다 작은 SQL 일괄 처리 수Number of SQL Batches having response time greater than or equal to 10ms but less than 20ms
Batches >=000020ms & <000050msBatches >=000020ms & <000050ms 응답 시간이 20ms보다 크거나 같고 50ms보다 작은 SQL 일괄 처리 수Number of SQL Batches having response time greater than or equal to 20ms but less than 50ms
Batches >=000050ms & <000100msBatches >=000050ms & <000100ms 응답 시간이 50ms보다 크거나 같고 100ms보다 작은 SQL 일괄 처리 수Number of SQL Batches having response time greater than or equal to 50ms but less than 100ms
Batches >=000100ms & <000200msBatches >=000100ms & <000200ms 응답 시간이 100ms보다 크거나 같고 200ms보다 작은 SQL 일괄 처리 수Number of SQL Batches having response time greater than or equal to 100ms but less than 200ms
Batches >=000200ms & <000500msBatches >=000200ms & <000500ms 응답 시간이 200ms보다 크거나 같고 500ms보다 작은 SQL 일괄 처리 수Number of SQL Batches having response time greater than or equal to 200ms but less than 500ms
Batches >=000500ms & <001000msBatches >=000500ms & <001000ms 응답 시간이 500ms보다 크거나 같고 1,000ms보다 작은 SQL 일괄 처리 수Number of SQL Batches having response time greater than or equal to 500ms but less than 1,000ms
Batches >=001000ms & <002000msBatches >=001000ms & <002000ms 응답 시간이 1,000ms보다 크거나 같고 2,000ms보다 작은 SQL 일괄 처리 수Number of SQL Batches having response time greater than or equal to 1,000ms but less than 2,000ms
Batches >=002000ms & <005000msBatches >=002000ms & <005000ms 응답 시간이 2,000ms보다 크거나 같고 5,000ms보다 작은 SQL 일괄 처리 수Number of SQL Batches having response time greater than or equal to 2,000ms but less than 5,000ms
Batches >=005000ms & <010000msBatches >=005000ms & <010000ms 응답 시간이 5,000ms보다 크거나 같고 10,000ms보다 작은 SQL 일괄 처리 수Number of SQL Batches having response time greater than or equal to 5,000ms but less than 10,000ms
Batches >=010000ms & <020000msBatches >=010000ms & <020000ms 응답 시간이 10,000ms보다 크거나 같고 20,000ms보다 작은 SQL 일괄 처리 수Number of SQL Batches having response time greater than or equal to 10,000ms but less than 20,000ms
Batches >=020000ms & <050000msBatches >=020000ms & <050000ms 응답 시간이 20,000ms보다 크거나 같고 50,000ms보다 작은 SQL 일괄 처리 수Number of SQL Batches having response time greater than or equal to 20,000ms but less than 50,000ms
Batches >=050000ms & <100000msBatches >=050000ms & <100000ms 응답 시간이 50,000ms보다 크거나 같고 100,000ms보다 작은 SQL 일괄 처리 수Number of SQL Batches having response time greater than or equal to 50,000ms but less than 100,000ms
Batches >=100000msBatches >=100000ms 응답 시간이 100,000ms보다 크거나 같은 SQL 일괄 처리 수Number of SQL Batches having response time greater than or equal to 100,000ms

개체의 각 카운터는 다음 인스턴스를 포함합니다.Each counter in the object contains the following instances:

항목Item DescriptionDescription
CPU Time:RequestsCPU Time:Requests 요청에 소요되는 CPU 시간입니다.The time the CPU spent on the request.
CPU Time:Total(ms)CPU Time:Total(ms) 일괄 처리에 소요되는 CPU 총 시간입니다.The total time the CPU spent on the batch.
Elapsed Time:RequestsElapsed Time:Requests 요청의 경과 시간입니다.The elapsed time of the request.
Elapsed Time:Total(ms)Elapsed Time:Total(ms) 일괄 처리의 경과 시간입니다.The elapsed time of the batch.

관련 항목:See Also

SQL Server, Plan Cache 개체SQL Server, Plan Cache Object
리소스 사용 모니터링(시스템 모니터)Monitor Resource Usage (System Monitor)