SQL Plan Cache column descriptions
Displays the columns that are used in the SQL Plan Cache Statements window.
| Column name | Description |
|---|---|
| Last Time Run | Displays the last time that this statement was run. |
| Most Expensive Time (sec) | The time taken for the longest run of this statement. |
| Total Processing Time (sec) | The sum total time that all runs of this statement took to process in seconds. |
| Total Times Run | The total number of times that this statement ran. |
| Average Processing Time (sec) | The average time per run that this statement took to process in seconds. |
| Statement | The statement text. |
| Plan Creation User Name | The name of the user id that created the plan. |
| Job Name | The name of the job that created the plan. |
| Job User | The name of the user id that owned the job that created the plan. |
| Job Number | The job number of the job that created the plan. |
| Adjusted Average Processing Time (sec) | The average time per run that this statement took to process in seconds where anomalous runs are removed from the average calculation. This time provides a realistic average for a statement by ignoring a single (or few) run that was atypical to the normal condition of the statement. |
| Average Result Set Rows | The average number of result set rows that are returned when this statement is run. |
| Average Temp Storage Used (MB) | The average amount of temporary storage used when this statement is run. |
| Plan Score | The rating of this plan relative to other plans in the cache. A plan with a higher rating relative to other plans remains in the cache for a longer time. A plan with a lower rating relative to other plans is removed from the cache sooner than the other plans. |
| Plan Identifier | A unique numeric identifier of the plan. |
| Total Cached Results Used | The number of times a result set from a prior run of the statement was reused on a subsequent run of the statement. |
| Optimization Time (sec) | The amount of time that it took to optimize this statement. |
| System Name | The system name. |
| Relational Database name | Relational database name |