Script Center Home > Script Repository > SQL Server > SQL Server 2005

Performance (General)

Sample scripts for monitoring and managing SQL Server 2005 performance.

•List Cached Plans Where Worker Time Exceeds Elapsed Time
•List Currently-Executing Parallel Plans
•List Recompiled Statements
•List Runnable Queues
•List Statements With the Highest Average CPU Time
•List Statements with the Highest Execution Counts
•List Top Wait Types for a Workload
Top of pageTop of page