This video explains how some Microsoft SQL Server DBA scripts help find slow stored procedures and applications quickly. It shows specifically how Adam Machanic’s sp_WhoIsActive works.
[youtube 1&v=vvziPI5OQyE]
Video Producer: http://www.brentozar.com/