Get Server Configuration
mssql_server_configInspect SQL Server configuration settings and flag risky values such as uncapped max server memory, MAXDOP 0, or xp_cmdshell on; default returns only flagged items.
Instructions
Server configuration (sp_configure, sys.configurations) with a Flag for risky values: max server memory not capped, cost threshold for parallelism at 5, MAXDOP 0, priority boost, optimize for ad hoc workloads off, xp_cmdshell on, and more. onlyFlagged=true (default) returns only flagged settings.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| onlyFlagged | No | Return only settings that triggered a risk/review Flag. Set false to return every configuration option. |