Lite: Database configuration tab missing many useful sys.databases columns

[erikdarlingdata]

Problem

Lite's database configuration collector only captures 9 columns from sys.databases:

• compatibility_level
• recovery_model_desc
• is_auto_close_on
• is_auto_shrink_on
• is_query_store_on
• page_verify_option_desc
• target_recovery_time_in_seconds
• delayed_durability_desc

Dashboard's collector captures 35+ properties via CROSS APPLY VALUES, including many that are important for troubleshooting:

Missing columns that matter most

• is_read_committed_snapshot_on — critical for understanding blocking behavior
• snapshot_isolation_state_desc — same
• is_encrypted (TDE)
• is_trustworthy_on — security concern
• is_db_chaining_on — security concern
• is_parameterization_forced — affects plan cache and query performance
• is_auto_create_stats_on / is_auto_update_stats_on / is_auto_update_stats_async_on — stats management
• state_desc — ONLINE/OFFLINE/RESTORING/etc.
• is_read_only
• collation_name
• is_fulltext_enabled

Nice to have

• ANSI settings (is_ansi_nulls_on, is_ansi_padding_on, etc.)
• is_recursive_triggers_on
• is_cursor_close_on_commit_on
• is_honor_broker_priority_on

Proposed fix

Expand the Lite collector query to include the high-value columns. Also need to:

1. Update the DuckDB database_config table schema
2. Update the appender in RemoteCollectorService.ServerConfig.cs
3. Update the display DataGrid columns in ServerTab.xaml
4. Update the LocalDataService.Config.cs read query

Don't need all 35 — prioritize the ones that are most useful for performance troubleshooting.

[erikdarlingdata]

This was completed in PR #163 — Lite database configuration expanded from 9 to 28 sys.databases columns with version-gated support for SQL 2019+ and SQL 2025+ features.