Discussion concerning the free SQL Sentry Plan Explorer
11/28/2011 5:35:24 PM
Gokhan
Posts: 9
|
If there is already a Plan Explorer windows open and I right click to a query plan in ssms a new window of Plan Explorer won't open. If I save the execution plan from SSMS and then open a new Plan Explorer and open the file than a multiple windows can be used but I think that's defeating the purpose of the Addin.
Thank you
|
|
0
• permalink
|
11/28/2011 5:45:43 PM
Jason Hall
Administrator
Posts: 88
|
Hi Gokhan,
The Plan explorer SSMS addin will use one Plan Explorer window for the same session from SSMS. This means that if you launch Plan Explorer from SSMS, then make a change to the query, and get new plan within the same SSMS workspace (same session) the same window will be used.
If you open a new session in SSMS and launch Plan Explorer from there a new window will open.
This is actually a feature designed to avoid being lost in multiple windows while working within the same session over time.
|
|
0
• permalink
|
11/28/2011 6:21:10 PM
Gokhan
Posts: 9
|
It make sense why the feature is added. Maybe this should be an option default set to current setting. In our case opening multiple SSMS is cluttering and time consuming, SSMS windows have the same caption in the taskbar and after opening 2-3 it's difficult to track, and opening SSMS and connecting to a database might take about a minute vs Sentry loads withing 3-4 seconds most.
Lately I have been trying to optimize an application, which makes many (over 60) database calls and over 30 application instances ran in the last 3 hours. I am getting top 100 of all the cached plan xml in grid mode (which cached was freed before applications ran) ordered by duration (or etc) desc and clicking on the xml opens a new ssms window with execution plan and I can only have one SQL sentry window opened automatically, the rest 20-30 plans I scan through I have to save them as files from SSMS and then open the file in SQL sentry (by the say if a file is save in SQL Sentry it shows in the explorer taskbar therefore it's easy to locate). In our case addin is not helpful
Our other cases are also similar executing a stored procedure check the plan then the next etc. Opening multiple SSMS windows for these tasks are very messy and time consuming.
I guess for people working with one query plan at a time this is a good option but not if you would like to see many query plans in a row quickly.
Thank you
|
|
0
• permalink
|
11/29/2011 8:48:50 AM
Jason Hall
Administrator
Posts: 88
|
Gokhan,
I'm actually not referring to opening an entire new SSMS window. All you need to do is open a new connection/session in the same SSMS window. You can do this by simply using the "New Query" option on the toolbar (Ctrl + N hotkey by default).
It will open a new query session in another tab, which will be associated with a different SPID, and each of those query sessions will spawn a new Plan Explorer window.
Please give that a try and let me know your findings.
|
|
0
• permalink
|