Discussion concerning the free SQL Sentry Plan Explorer
1/6/2012 1:50:28 PM
ChrisAVWood
Posts: 41
|
Hi,
I am investigating an issue with SSMS opening a 2nd spid that looks at sys.configurations. On the SQL Forums it was suggested that it could be a plugin causing this. Currently I cannot see in SSMS if I have any plugins installed. Is there a way, in SQL2008R2 RTM SSMS that I can see if the Plan Explorer plugin is installed?
Thanks
Chris
|
|
0
• permalink
|
1/6/2012 1:59:15 PM
Aaron Bertrand
Moderator
Posts: 57
|
Hi Chris,
We don't entrench ourselves deeply in the SSMS add-in hierarchy except for the context menu, so you won't see anything in for example Tools > External Tools... (just like you don't for other add-ins such as SSMS Tools Pack, which creates its own menu system). The quickest ways to check if the add-in is installed:
(1) Control Panel > Programs and Features (or Add/Remove Programs if your O/S is older) - you should see an entry called "SQL Sentry Plan Explorer SSMS Addin" in the list of installed programs.
(2) if you already have SSMS open, generate an execution plan for [SELECT * FROM sys.objects], then right-click the plan. If the add-in is installed, you will see the option "View in SQL Sentry Plan Explorer" in the context menu.
You can easily uninstall the add-in to confirm that the queries against sys.configurations are coming from elsewhere.
Aaron
--
Aaron Bertrand, Senior Consultant
SQL Sentry, Inc.
|
|
0
• permalink
|
1/6/2012 2:09:36 PM
ChrisAVWood
Posts: 41
|
Thanks Aaron. I figured the ability to open in Plan Explorer was the method.
Chris
|
|
0
• permalink
|