Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jonathan Kehayias Getting Started with SQL Server Event Notifications RE: Getting Started with SQL Server Event Notifications

  • July 6, 2012 at 4:42 pm

    #1509922

    vinay.kumar (7/6/2012)

    HI,

    Thanks For the Post.

    I tried the sample Event Notification given in the blog. And it looks all fine.

    For the each Event(ERRORLOG) it is using one Conversation Group for all the raised errors. SO i manually ended the conversation and then i raised a custom exception. This time no messaes sent to any Queue.

    Please let me know your thought

    Thanks,

    Vinay K

    Why would you do that? The conversation being reused by the Event Notification is normal behavior, and reuse of conversations can be a a major performance improvement.

    http://rusanu.com/2007/04/25/reusing-conversations/%5B/url%5D

    Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
    My Blog | Twitter | MVP Profile
    Training | Consulting | Become a SQLskills Insider
    Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]