Pain free way to identify if SQL Server is the root cause or symptom
In this six-minute video, Allen Kinsel shares multiple ways to quickly determine whether SQL Server is the root cause or a symptom of your performance problem. Demo 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 […]