sp_AskBrent™ Helps You Troubleshoot Slow SQL Servers.

I kept getting emails and phone calls that said, “The SQL Server is running slow right now, and they told me to ask Brent.” Each time, I’d have to:

• Look at sp_who or sp_who2 or sp_WhoIsActive for blocking or long-running queries
• Review the SQL Server Agent jobs to see if a backup, DBCC, or index maintenance job was running
• Query wait statistics to figure out SQL Server’s current bottleneck
• Look at Perfmon counters for CPU use, slow drive response times, or low Page Life Expectancy

Tool sp_AskBrent will do all thing for us quickly. We can configure to log data into a table.

Refer: http://www.brentozar.com/askbrent/