Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feature request: sp_BlitzCache showing 2019's new air_quote_actual plans #2019

Closed
BrentOzar opened this issue Apr 7, 2019 · 0 comments

Comments

Projects
None yet
1 participant
@BrentOzar
Copy link
Member

commented Apr 7, 2019

Is your feature request related to a problem? Please describe.
SQL Server 2019 adds sys.dm_exec_query_plan_stats. When that's available, let's include that in the output of sp_BlitzCache rather than the estimated plan.

Gotchas:

  • Don't do version detection - just see if the DMF and field is available
  • Try to detect whether the plan is an actual or an estimate - this DMF shows estimated (not mostly_actual) plans when trace flag 2451 isn't enabled
  • If it's a mostly_actual plan, add a warning for this query, "Last Actual Plan"

Are you ready to build the code for the feature?
Yep. Not jumping on it right away since we've got some time before 2019 RTMs, so if someone wants to code this before I get to it, go for it - just make a note in here that you're doing it so we can chat in Slack.

@BrentOzar BrentOzar changed the title Feature request: sp_BlitzCache showing 2019's new mostly_actual plans Feature request: sp_BlitzCache showing 2019's new air_quote_actual plans Apr 23, 2019

BrentOzar added a commit that referenced this issue Apr 23, 2019

BrentOzar added a commit that referenced this issue Apr 23, 2019

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.