-
Notifications
You must be signed in to change notification settings - Fork 26
Description
Problem
Dashboard tracks configuration changes over time (Server Config Changes, Database Config Changes, Trace Flag Changes tabs under Overview), which is valuable for drift detection. But it has no way to see the current configuration state of a server or its databases.
Lite has dedicated Configuration tabs showing current state:
- Server Configuration (setting name, configured value, value in use, dynamic, advanced)
- Database Configuration (per-database properties from sys.databases)
- Scoped Configuration (per-database sys.database_scoped_configurations)
- Trace Flags (flag number, status, global/session)
If you want to know "is RCSI on for this database?" or "what's the current MAXDOP?" in Dashboard, you can't — you can only see if it changed recently.
Proposed fix
Add a "Current Configuration" sub-tab (or tabs) alongside the existing change-tracking tabs. The data is already being collected — the change-tracking collectors snapshot current state to detect deltas. Options:
- SQL views: Create
report.current_server_configurationandreport.current_database_configurationviews that return the latest snapshot from the existing collection tables - New sub-tabs: Add to the Overview section or as a standalone top-level tab
- Dual view: Show current config with a column indicating recent changes (highlight rows that changed in the last N days)
Option 3 would be the most useful — combining current state with change awareness in one view.