Each executing SQL statement has the following performance statistics:
Statistics | Description |
Executions | Number of times the statement has been executed. |
Logical Reads | Number of data pages read from the buffer pool (logical). |
Physical Reads | Number of data pages read from the buffer pool (physical). |
CPU Time | CPU time used by the statement. |
Compilations | Number of different compilations for a specific statement. |
Worst Preparation Time | The longest number of milliseconds required to prepare a specific statement. |
Best Preparation Time | The shortest number of milliseconds required to prepare a specific statement. |
Rows Deleted | Number of attempted row deletions. |
Rows Inserted | Number of attempted row insertions. |
Rows Updated | Number of attempted row updates. |
Rows Read | Number of rows read to return result set. |
Rows Written | Number of rows in the table changed (inserted, deleted or updated). |
Stmt Sorts | Number of times a set of data was sorted. |
Sort Overflows | Number of sorts that may have required temporary disk space for storage after running out of sort heap. |
Sort Time | Total number of milliseconds spend performing sorts when executing a section. |
Total Execute Time | Total time spent to execute a particular statement in the SQL cache. |
Stmt Text | Text of the statement |
Partition | Database partition from which data was retrieved for the row. |
Snapshot Time | Date and time of the snaphot. |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center