sp_AskBrent™ Helps You Troubleshoot Slow SQL Servers.

20:28

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/