Skip to content

Dashboard: Add current configuration view alongside change tracking #143

@erikdarlingdata

Description

@erikdarlingdata

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:

  1. SQL views: Create report.current_server_configuration and report.current_database_configuration views that return the latest snapshot from the existing collection tables
  2. New sub-tabs: Add to the Overview section or as a standalone top-level tab
  3. 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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions