Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning sys.dm_exec_sessions - High CPU RE: sys.dm_exec_sessions - High CPU
e4d4
SSCertifiable
Points: 5777
More actions
August 28, 2013 at 4:32 am
#1645477
Use a sp_WhoIsActive with the @delta_interval option:
http://sqlblog.com/blogs/adam_machanic/archive/2011/04/26/delta-force-a-month-of-activity-monitoring-part-26-of-30.aspx
and you can also save the results in a table, but the @delta_interval option should be enough for you:
http://sqlblog.com/blogs/adam_machanic/archive/2011/04/25/capturing-the-output-a-month-of-activity-monitoring-part-25-of-30.aspx