This is done via Performance Monitor (perfmon). % Processor Time : Processor : > 80% :: Potential causes include memory pressure, low query plan reuse, non-optimized queries. Context Switches/sec : System : > 5000 x processors :: Potential causes include other applications on the server, more than one instance of SQL server running on the [...]