This script returns a focused snapshot of instance-level configuration settings that DBAs commonly review when validating a server, inheriting an environment, or troubleshooting unexpected behaviour.
It intentionally surfaces settings that have operational, security, or performance impact when misconfigured or left unchecked.
The Script
Example Output
The result set shows the current values for key instance configuration settings covering memory, parallelism, backups, security surface area, and general stability.
This provides a fast baseline view when reviewing a new server or checking for obvious configuration risks.
Notes
- Focuses on commonly reviewed settings rather than all configuration options
- Intended as a quick validation snapshot, not a tuning recommendation
- Useful for comparing environments or checking inherited servers
- Keeps noise low by excluding rarely adjusted or niche settings
Leave a Reply