One good way to quickly diagnose System slowdowns is to make use of the sp_who2 SQL function in the following way:
EXEC sp_who2
This helps identify High CPU Usage, Blocking and High IO Usage.
Visit the DevX Tip Bank
