Page History
...
The following charts are available on the Procedure Cache tab:
Cache Size by Object Type
Displays the amount of the procedure cache used by various objects including:
- Adhoc Query
- Check Constraint
- Default Constraint
- Extended Procedure
- Prepared Statement
- View
- Stored Procedure
Object Types
- Use the drop-down button to select either Hit Ratio, Object Count, or Use Rate.
- Hit Ratio offers a chart of the cache hit ratios of the individual object types in memory through the last 25 refreshes. For example, you can view the hit ratio of the extended procedure object.
- Object Count displays the number of objects using the procedure cache. Use Rate displays the rate at which each of the object types is used in the procedure cache.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >