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
(thinking…)
Sign in with: oidc
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
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base