search

trimble-oss / dba-dash

DBA Dash - SQL Server Monitoring Tool
MIT License
268 stars 62 forks source link

compatibility Level #1056

Open aachaemenes opened 1 month ago

aachaemenes commented 1 month ago

I think we need to have compatibility level check in the main dbadash window or as a report. When we move databases around there are good chances that we miss to match the compatibility level to the new version as this wont happened automatically.

I have missed so many databases and would love to have this if possible.

DavidWiseman commented 1 month ago

On the DB Options tab at root level, you can see a report showing the number of databases with an old compatibility level (Old Compat Level column).

Note: Using an old compatibility level helps maintain the performance characteristics of the previous versions and enables smoother migrations. It's generally better to be on the latest compatibility level, but switching it can cause performance regressions.

I don't think this belongs as part of a daily check on the summary tab, but if you wanted to you could add a custom check for it. A custom report could also be created if you wanted the information in a specific format different from the DB Options tab.