Script Center Home > Scripts > SQL Server > SQL Server 2005

CPU and Optimization

Sample scripts for calculating and optimizing CPU time when using SQL Server 2005.

•Determine CPU Resources Required for Optimization
•Retrieve Parallel Statements With the Highest Worker Time
•Retrieve Statements with the Highest Plan Re-Use Counts
•Retrieve Statements with the Lowest Plan Re-Use Counts
Top of pageTop of page