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.
Thanks for the feedback Brent.
We are reviewing this.