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 –
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.
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 !!!
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.