7/8/2011 10:42:55 AM
ChrisAVWood
Posts: 41
|
I have just learnt about trace flag 2301 thanks to this blog post by Grant Fritchey http://www.scarydba.com/2011/06/20/make-the-optimizer-work-harder/ I have started to post queries into the Command Text box and then click estimated or actual plan to see what is happening or may happen. I could use trace flag 2301 by getting an sqlplan file from SSMS but could Plan Explorer add this functionality somehow?
Thanks
Chris
|
|
0
• permalink
|
7/8/2011 12:04:04 PM
Jason Hall
Moderator
Posts: 267
|
Hi Chris,
Just to be clear, are you requesting that we provide that ability to enable/disable the 2301 trace flag from within Plan explorer?
--
Jason Hall, SQL Sentry Support, SQL Sentry, Inc.
P: 704.895.6241 | F: 704.895.8771
|
|
0
• permalink
|
7/8/2011 12:09:35 PM
ChrisAVWood
Posts: 41
|
I think being able to have 'additional optimizing' in Plan Explorer would be a great thing. So yes I am asking for the ability, when using Command Text to use trace flag 2301 for the session.
Thanks
Chris
|
|
0
• permalink
|
7/8/2011 12:16:27 PM
Jason Hall
Moderator
Posts: 267
|
Thanks Chris,
I'll put in the request, along with links to this thread and the blog post.
--
Jason Hall, SQL Sentry Support, SQL Sentry, Inc.
P: 704.895.6241 | F: 704.895.8771
|
|
0
• permalink
|
9/23/2011 12:50:06 PM
ChrisAVWood
Posts: 41
|
If this is being looked at could you also look at trace flags 9204 (SQL2005 onwards) and 9292 as referenced in this blog entry http://sqlblog.com/blogs/paul_white/archive/2011/09/21/how-to-find-the-statistics-used-to-compile-an-execution-plan.aspx
I just think that it would be great to run this FREE product with the ability to set trace flags that can help with the execution plan creation.
Thanks
Chris
|
|
0
• permalink
|
9/23/2011 12:59:26 PM
Aaron Bertrand
Moderator
Posts: 57
|
Chris, the problem is that those options produce DBCC-style output (essentially they behave like print commands). Since Plan Explorer is not a query tool, it doesn't currently have a way to consume or display the results of a query (be it RETURN, OUTPUT, SELECT or PRINT). That was an intentional choice. You can of course run Paul's version of the query with the QUERYTRACEON options from within the Command Text pane, generate the plan and consume all the metrics that come along with it... but we'll have to investigate how involved it would be to support those options and the work required to consume and present the output in a meaningful way.
--
Aaron Bertrand, Senior Consultant
SQL Sentry, Inc.
|
|
0
• permalink
|
9/23/2011 1:01:52 PM
ChrisAVWood
Posts: 41
|
Thanks for the speedy response Aaron. I think that I am probably expecting too much from Plan Explorer. Maybe you should produced a paid Plan Explorer Plus.
Chris
|
|
0
• permalink
|
9/23/2011 1:06:00 PM
Aaron Bertrand
Moderator
Posts: 57
|
If we were to go down this path, I think it would be more likely to become either a free feature in Plan Explorer, or a feature in one of the paid products we already develop, Performance Advisor (which already has several advantages in the area of plan analysis that enhance what Plan Explorer currently provides for free).
--
Aaron Bertrand, Senior Consultant
SQL Sentry, Inc.
|
|
0
• permalink
|