Diagnose SQL server by viewing running and queued queries
If you run a busy SQL server an experience performance issues, there are several things you can do to diagnose issues. I’ll ignore the obvious ones for now (ensuring your queries are streamlined and using the SQL Profiler) and will provide you with an additional script to run which will give you a view of