Performance counters to watch (SQL)
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 same server, [...]