Post reply

Detailed deadlock event notifications via email

  • November 1, 2015 at 11:06 am

    #312733

    Hi there,

    Wondering if anyone can offer some insight. We have (running SQL 2012 Std) and have enabled trace flag 1204 and 1222 for capturing deadlock through extended events. I have enabled deadlock notification through email .But it only send deadlock event occurred notification from the sql server error log . I was wondering if its possible to email the deadlock details they get generated in extended events via DB mail.

    Thanks in advance !

  • November 1, 2015 at 2:41 pm

    #1836948

    I Believe you are talking about two things here , Event Notification Vs Extended Events which is a new feature in 2012 where is no mail alerting mechanism embedded and possible . but how ever we can still use the 2008 feature of event notifications using service broker...

    check out the link below for more in-depth info. correct me i am wrong.

    https://www.sqlskills.com/blogs/jonathan/event-notifications-vs-extended-events/

    @JayMunnangi

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

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