philcart (12/23/2009)
Great article Jonathan, looking forward to more. Especially interested in extended events.
Event Notifications and Extended Events are completely different animals in SQL Server. Extended Events are new in 2008 while Event Notifications exist in 2005, and the eventing for the two is very different. If you'd like more information on Extended Events, you can read my whitepaper on MSDN,
Using SQL Server 2008 Extended Events
as well as Paul Randal's article on Technet:
Advanced Troubleshooting with Extended Events
If you'd like some other references I have a tag on my blog for Extended Events posts I write:
http://sqlblog.com/blogs/jonathan_kehayias/archive/tags/Extended+Events/default.aspx
and so does Paul:
http://www.sqlskills.com/BLOGS/PAUL/category/Extended-Events.aspx
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]