Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Resource Governor - How to Trace Events Expand / Collapse
Author
Message
Posted Monday, June 10, 2013 11:05 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:08 PM
Points: 268, Visits: 306
I am trying to set up an automatic email when a user in a resource group goes over a threshhold. I found the resource governor event REQUEST_MAX_CPU_TIME_SEC that according to the documentation does exactly what I'm trying to do. (The reference is following.) I have set the event in the resource governor, but cannot figure out how to trace the event. I did not see the event in SQL profiler and have not been able to find any examples of this. I'm just beginning with the resource governor. I think I may be tracking down the wrong thing because everything I've found doesn't seem to relate to trapping the event and sending an email.

The documentation says:

1.Set a limit on CPU usage for the ad hoc group. (DONE)
2.Monitor SQL Trace events (Resource Governor management class event). (???)
3.Perform an action on the event. For example, ignore the event, send an e-mail, send a page, or execute the KILL command on the request. (???)

http://msdn.microsoft.com/en-us/library/bb933944(v=sql.105).aspx

Any help is appreciated.

-Brian
Post #1461680
Posted Thursday, June 27, 2013 12:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 18, 2014 12:44 PM
Points: 1, Visits: 328
1.Set a limit on CPU usage for the ad hoc group. (DONE)
2.Monitor SQL Trace events (Resource Governor management class event). (CPU Threshold Exceeded Event Class)
3.Perform an action on the event. For example, ignore the event, send an e-mail, send a page, or execute the KILL command on the request. (Use Event Notification)
Post #1468285
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse