This has worked well for us time and again (we use sql server 2005). This query gives the currently running queries, run it when the cpu is high and review...