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)?
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