SQL Server database administrators need to be able to quickly find out what queries and stored procedures are running slow. Microsoft includes sp_who and sp_who2 in SQL Server 2005 and 2008, but there’s a much better tool, and it’s completely free.
Where to Download sp_WhoIsActive
- You can download sp_WhoIsActive for free (click on the latest blog post version)
- Read Adam’s posts about sp_WhoIsActive
- If you like it, tell Adam by leaving a comment on his blog
- How to collect sp_WhoIsActive results into a table over time for troubleshooting history