Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

SSMS bug: SET STATISTICS PROFILE ON is enabled when both actual plans and live plans are enabled

Using SSMS 17.9 (14.0.17285) and SQL Server 2017 (14.0.3037.1), click Query, Include Actual Execution Plan, and then click Query, Include Live Query Statistics. Then run any query, like:

SELECT * FROM sys.databases;

You get a second result set with the content of STATISTICS PROFILE, as if you'd set SET STATISTICS PROFILE ON.

This only happens when you turn on both Actual Plans and Live Query Statistics. It doesn't happen when you turn on either one individually.

Expected behavior: STATISTICS PROFILE data should only be enabled if you turn it on.

3 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Brent Ozar shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base