Each executed 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 for all executed sorts. |
| 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. Feedback Terms of Use Privacy Cookie Preference Center
