Take the 2-minute tour ×  I have a SQL server cluster that is
often reaching 100% CPU out of working hours. I want to gather
some information to help troubleshooting when the actual
condition is taking place.  I'm thinking of gathering info from
sys.dm_exec_requests for example.  Question: How can i trigger
this information gathering to take place based on CPU
utilization condition  For Example: Insert the results of
sys.dm_exec_requests into a table when CPU > 95%  suggestions
for anything else I should gather are very welcome!  It appears
that I might be able to do this with alerts, but I need to
better understand the counters as my example doesn't fire,
despite CPU >5%  USE [msdb] EXEC msdb.dbo.sp_update_alert
@name=N'My Test CPU Alert',
@performance_condition=N'Resource Pool Stats|CPU usage
%|default|=|5',  share|improve this question  migrated from
stackoverflow.com Oct 6 '12 at 4:24  This question came from our
site for professional and enthusiast programmers.  1 Answer 1
up vote 4 down vote accep