Performance Statistics - Monitoring Tables
Performance Statistics - Monitor Tables
Each SQL statement captured from the monitoring tables has the following performance statistics:
|
Statistics |
Description |
|
CPU Time |
Number of milliseconds of CPU used by the statement. |
|
CPU Time Per Execution |
Ratio between the number of milliseconds of CPU used by the statement and the number of executions. |
|
Executions |
Number of times the statement was executed during the monitoring period. |
|
Logical Reads |
Number of buffers read from cache. |
|
Logical Reads Per Execution |
Ratio between the number of buffers read from cache and the number of executions. |
|
Mem Usage (KB) |
Number of kilobytes of memory used for the execution of the statement. |
|
Mem Usage (KB) Per Execution |
Ratio between the number of kilobytes of memory used for the execution of the statement and the number of executions |
|
Packets Received |
Number of network packets received by Adaptive Server. |
|
Packets Received Per Execution |
Ratio between the number of network packets received by Adaptive Server and the number of executions. |
|
Packets Sent |
Number of network packets sent by Adaptive Server. |
|
Packets Sent Per Execution |
Ratio between the number of network packets sent by Adaptive Server and the number of executions. |
|
Pages Modified |
Number of pages modified by the statement. |
|
Pages Modified Per Execution |
Ratio between the number of pages modified by the statement and the number of executions. |
|
Physical Reads |
Number of buffers read from disk. |
|
Physical Reads Per Execution |
Ratio between the number of buffers read from disk and the number of executions. |
|
Wait Time |
Number of milliseconds the task has waited during execution of the statement. |
|
Wait Time Per Execution |
Ratio between the number of milliseconds the task has waited during execution of the statement and the number of executions. |
Related Topics
SQL Inspector Overview
SQL Inspector Window
Performance Statistics - QP Metrics
Add/Modify Inspector
