casinos

Denali–Extended Events November 24th, 2010

Vinod Kumar

As I installed Denali (next version of SQL Server) on my machine, I have been trying to figure out what all have been added as part of this CTP1. On playing around with the SQL Server Management Studio I found something very interesting -

image

Now Extended Events in completely integrated inside of SQL Server and this is such a cool thing. Though there is very less we can do with this in this CTP1 release. I just tried to query from the database to figure out that the there are tons of events and actions already there inside the database.

image 

I am sure the subsequent CTP’s we are sure to see more of this xEvents infrastructure. As shown in the figure 1, there is already an Event on System_Health check which has been configured out-of-box. Interesting to play around, you can script it out and check how it has been configured. Remove the grouping and the wealth of events and actions come out …

More on this later, but you get the point. Extended Events are now part of UI and lots of fun things are coming round the corner !!!

Tags: , , , , , , , , ,

This entry was posted on Wednesday, November 24th, 2010 at 12:06 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.


2 Responses to “Denali–Extended Events”

  1. vinodkumar says:

    Yes Jonathan. The system_health was also available. Now getting an UI for xEvents out-of-box via the SSMS makes this very interesting thing to watch out for !!!

  2. The system_health session is running out of the box in all SQL Server 2008 and 2008 R2 instances.  Its not new in Denali, but there have been changes to the event session to add SQLCLR events that are new in Denali.

    If you are interested in Extended Events in SQL 2008 and 2008 R2, I wrote a SSMS Addin that is available for free download on Codeplex:

    extendedeventmanager.codeplex.com

    I am currently updating the code to work against Denali as well as maintaining backwards compatibility for 2008 and 2008 R2, and should be releasing a beta build that will remain free and opensource sometime next month.

Leave a Reply