Discussion concerning the free SQL Sentry Plan Explorer
10/25/2011 1:36:02 PM
Aaron Bertrand
Moderator
Posts: 57
|
We've added table-level I/O metrics (for actual plans generated within Plan Explorer) and support for showplan changes in SQL Server 2012 (formerly known as Denali). I've blogged about a few of these changes here:
http://sqlblog.com/blogs/aaron_bertrand/archive/2011/10/25/sql-sentry-plan-explorer-v1-3.aspx
The change list has been updated:
http://downloads.sqlsentry.net/downloads/sqlsentryplanexplorer/PEChange_List.html
Download the free Plan Explorer here:
http://sqlsentry.net/plan-explorer/sql-server-query-view.asp
--
Aaron Bertrand, Senior Consultant
SQL Sentry, Inc.
|
|
0
• permalink
|
10/25/2011 1:38:43 PM
ChrisAVWood
Posts: 41
|
Aaron,
I am using 6.4.921.0 (1.3) and I cannot see the Table I/O tab when I use it on an old SQL2005 plan. Do I need to do something to have this tab displayed?
Thanks
Chris
|
|
0
• permalink
|
10/25/2011 1:41:46 PM
Aaron Bertrand
Moderator
Posts: 57
|
Chris, is it an *actual* plan that you retrieved from within Plan Explorer? Like other runtime metrics, we can't derive that information from an existing plan that was retrieved from Management Studio (or any estimated plan).
--
Aaron Bertrand, Senior Consultant
SQL Sentry, Inc.
|
|
0
• permalink
|
10/25/2011 1:44:48 PM
ChrisAVWood
Posts: 41
|
So you are saying I can only get this from a plan created in Plan Explorer when I paste code under the Command Text tab and ask for the Actual Plan?
Chris
|
|
0
• permalink
|
10/25/2011 1:47:11 PM
Aaron Bertrand
Moderator
Posts: 57
|
Yes, that is correct. The information is not provided in the XML for a plan produced by Management Studio - it can only be derived if you generate an actual plan in Plan Explorer (or if you're reviewing plans you've collected using Performance Advisor).
--
Aaron Bertrand, Senior Consultant
SQL Sentry, Inc.
|
|
0
• permalink
|
10/25/2011 1:56:15 PM
ChrisAVWood
Posts: 41
|
Got it now.
I had opened the GUI up and then opened a previously saved plan and did not see the tab. I saw the tab when I opened the GUI without opening a saved plan directly. Lastly I created the plan in Plan Explorer and can see the new tab.
The product gets better and better all the time. Not having SQL2012 installed does Plan Explorer already know about the 2012 warnings about tampdb spillige and MemoryGrant waits and implicit conversion warnings?
Thanks
Chris
|
|
0
• permalink
|