Problem
When a plan is captured via the "Run Repro Script" button, the resulting Advice for Humans report does not include the server context block:
=== Server Context ===
Server: SQL2022 (Developer Edition, 16.0.4222.2)
Hardware: 8 CPUs, 65,534 MB RAM
MAXDOP: 8 | Cost threshold: 50 | Max memory: 57,344 MB
Database: StackOverflow2013 (compat 160, SQL_Latin1_General_CP1_CI_AS)
Since we have an active connection when running the repro script, this information should be queryable and included in the analysis output.
Requested
When "Run Repro Script" captures a plan, query the server context (edition, CPUs, RAM, MAXDOP, cost threshold, max memory, database compat level/collation) and include it in the Advice for Humans report, the same way it appears when a plan is captured from the query editor.
Problem
When a plan is captured via the "Run Repro Script" button, the resulting Advice for Humans report does not include the server context block:
Since we have an active connection when running the repro script, this information should be queryable and included in the analysis output.
Requested
When "Run Repro Script" captures a plan, query the server context (edition, CPUs, RAM, MAXDOP, cost threshold, max memory, database compat level/collation) and include it in the Advice for Humans report, the same way it appears when a plan is captured from the query editor.