Resource Governor - How to Trace Events

  • 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

  • 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)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply