Each SQL statement captured from the QP Metrics has the following performance statistics:
Statistics | Description |
Execution time |
How long it takes to execute the SQL statement on the CPU displayed in milliseconds. |
Elapsed time |
This is a total of the Execution time and the time it takes to parse, compile, and optimize the SQL statement displayed in milliseconds. |
Logical IO |
Total logical IO reads during the execution of the SQL statement. |
Physical IO |
Total physical IO reads during the execution of the SQL statement. |
Execution count |
Number of times the SQL statement has been executed. |
Abort count |
Number of times the resource governor terminated the SQL statement because a resource limit was surpassed. |
The execution time, elapsed time, logical IO, and physical IO statistics each of have three values taken from the number of times the SQL statements was executed: the minimum, the maximum, and the average.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center