The Procedure Cache view allows you to view each item cached, the size, and the SQL text associated. Graphs below the cache listing provide you with a breakdown of the key Procedure Cache statistics that can help you analyze performance bottlenecks on your SQL Server instance.
The Usage column displays the number of times the associated cache object is used since inception. The References column displays the number of other cache objects referencing the associated cache object, with "1" as the base.
You can open the Procedure Cache view of the SQL Diagnostic Manager Resources tab by selecting the appropriate SQL Server instance, and then clicking Resources > Procedure Cache.
The following charts are available on the Procedure Cache tab:
Displays the amount of the procedure cache used by various objects including:
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
|