question

nidheesh.r.pillai avatar image
nidheesh.r.pillai asked

Where can you find Extended Events in SSMS?

I have been reading a lot of questions and answers from this forum lately, wherein many experts suggest the use of "Extended Events" over SQL Server Profiler, due to its benefits. I went through Books Online and few other links on the internet related to Extended Events to understand it better. However, what I couldn't figure out yet was where in SSMS is the tool present? In one of the articles, someone mentioned it is present in the Management section of the Object Explorer, but I couldn't find it there in my SQL Server 2008 machine. I also checked the Tools menu in the Standard toolbar and also searched the SQL server folder present under Start > All programs menu, still I couldn't find it. Can someone please throw some light as to where one can find "Extended Events" in SSMS 2008 and above? Does it come as a separate setup file that needs to be downloaded and installed from Microsoft and/or Is it bound by version restrictions (Express - Enterprise, 32bit/64 bit)?
sql-server-2008extended-events
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Fatherjack avatar image
Fatherjack answered
Working with Extended Events (XE) in SSMS is limited by the version of SSMS that you are using. It is natively incorporated in SSMS 2012 and above. For later versions (ie 2008 and 2008R2) you will be limited to working with XE via TSQL or you will need to install a 3rd party addin. The best (only?) addin for this is written by SQL Server MVP Jonathan Kehayias and is available via codeplex at http://extendedeventmanager.codeplex.com/.
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

nidheesh.r.pillai avatar image nidheesh.r.pillai commented ·
Thankyou for the response @Fatherjack. An additional clarification - Can this addin be compatible with any available edition or version of SQL Server 2008/2008R2?
0 Likes 0 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
yes, you can use this addin with either 2008 or 2008 R2 as far as I am aware. I think it also works with later versions but all the details will be on the codeplex page. This means that you can use SSMS 2012 to manage XE sessions on earlier versions of SQL Server - something that SSMS 2012 doesnt allow natively, it only manages sessions from 2012 (or later) instances.
0 Likes 0 ·