During the heat of the battle, during a critical downtime, the basics get skipped by the accidental DBAs. In this six-minute video, Allen shows all accidental DBA’s multiple ways to determine if SQL Server is the root cause of your slowness or just a symptom.
SQL Server Sample Code
/* See all requests */
select * from
sys.dm_exec_requests r
OUTER APPLY sys.dm_exec_sql_text(r.sql_handle) AS st
/*Filter out the noise */
select * from
sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS st