Page History
The Procedure Cache Hit Ratio (Percent) alert provides the ratio of procedure cache hits to procedure cache lookups.This value indicates the reuse of an execution plan from memory as opposed to a compilation from disk.
Manage your Procedure Cache Hit Ratio
If you regularly encounter values below 80% once SQL Server is actively running for at least 30 minutes, then consider one of the following remedies:
...
| Tip |
|---|
To enable alerting when this metric is outside its established baseline, click the Baseline Thresholds Enabled (as percentage of baseline) check box in the Alert Configuration window. |
| Scroll pdf ignore | ||||||
|---|---|---|---|---|---|---|
Newtabfooter |
|
...
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...
...