Discussion concerning the free SQL Sentry Plan Explorer
1/23/2012 5:05:52 AM
mpburtt
Posts: 2
|
Hi
I have an XML query plan (see attached) that contains the original compiled parameters but when I paste the XML plan into Plan Explorer (version 1.4 build 6.4.933.0) the "Parameteres" tab in the bottom section is hidden. Is there anything I can do to make this visible again?
Thanks
Malcolm Burtt
|
|
0
• permalink
|
1/23/2012 7:57:16 AM
Aaron Bertrand
Moderator
Posts: 57
|
Hi Malcolm,
Is this an actual plan or an estimated plan? What happens if you run the same query to generate an actual plan from within Plan Explorer? I believe we will only show the parameters tab when there is a valid ParameterList section in the XML.
I don't see your plan attached. Can you send your plan to me at abertrand [at] sqlsentry.net?
Thanks,
Aaron
--
Aaron Bertrand, Senior Consultant
SQL Sentry, Inc.
|
|
0
• permalink
|
1/23/2012 8:21:09 AM
mpburtt
Posts: 2
|
Hi Aaron
The plan has come from the SQL DMVs so I guess that makes it a compiled plan but it only includes the parameter values supplied at compile time.
I've emailed the plan to you (although I think every plan I have ever taken from the DMVs exhibits this problem.
Malcolm
|
|
0
• permalink
|
1/23/2012 11:03:39 AM
Aaron Bertrand
Moderator
Posts: 57
|
While the parameters tab is actually supposed to be shown whenever there is a valid ParameterList section found in the XML, currently I am seeing the same symptom as you - certain estimated plans are not showing the tab. We are investigating.
--
Aaron Bertrand, Senior Consultant
SQL Sentry, Inc.
|
|
0
• permalink
|