Monthly Archives: April 2011

script to quickly find out which spid is using most CPU and/or IO and what that SPID is doing

Technorati Tags: SQL Server,CPU,DBA Hey Guys, This is a bit off-topic, and specific to SQL Server, but this script has been very useful to me when the server is running slow.  Run the first part up to the 2nd dashed … Continue reading

Posted in Uncategorized | Leave a comment