Page History
...
- Upgrade to faster CPU(s).
- Reduce the number of SQL re-compilations as they are CPU intensive. There are many reasons that an object such as a stored procedure is recompiled, and you can remove most of these reasons by careful coding. See the SQL re-compilations counter for ways to dramatically reduce recompiles.
- Stop unnecessary programs from running (such as the Print Spooler or activities such as the database server acting as either a BDC or PDC).
| 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. |
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...