Add database changes details based on the zoom range
In the "Databases" section when selecting one, we would like to have a list of the database changes that happened based on the "zoom range" period.
Right now I'm thinking based on the SQL Server error log
Example:
1 - Database Status changed. Online/Offline/Read-Only/Read-Write/etc
2 - Compatibility Level changed - This will be great to co-relate some situations with the CL change.
3 - Page Verify
Etc
In the end, any message that uses any of these texts:
SELECT * FROM sys.messages
WHERE text like '%Setting database%'
This includes query store changes
7
votes
Cláudio Silva
shared this idea