Save DMV Snapshots for Analyzing and monitoring changes
Idea is to save snapshots of DMV's so that the changes can be analyzed. For example sys.dmexecprocedure_stats shows only total, last and average elapsed time. It will be great to know how the average changed over a period of time.
Common use case: sysproperties
afroz ahmed
shared this idea
-
Michael Berry
commented
As Idera has, I would like to see exactly what was running in the past should a problem/issue happen and it didnt trigger an alert. This is one feature I will miss and hope you can bring it in... also would like to have alerts only if a condition changes rather than every time.. if its the same thing then one alert. and give option for alert when things are back to normal.
-
Allen Dunn
commented
Create an alert to monitor instance global configuration settings.
i.e. the below retrieves the global configuration settings.
EXEC sp_configure 'show advanced option', '1'
RECONFIGURE
EXEC sp_configureA scheduled check against default results could discover any unauthorized changes such as 'allow updates', 'awe enabled', 'blocked process threshold', 'c2 audit mode'. etc
-
Allen Dunn
commented
Create an alert to monitor server SERVERPROPERTY results.
i.e. select SERVERPROPERTY('Edition') retrieves instance edition.A scheduled check against default results could discover any unauthorized changes to the server instance such as IsClustered, IsFullTextInstalled, IsIntegratedSecurityOnly, IsSingleUser, IsSyncWithBackupetc, etc.
-
Allen Dunn
commented
Create an alert to monitor Database properties.
i.e. select * from sys.databases retrieves the settings for all the databases.A scheduled check against default results could discover any unauthorized changes to the databases such as compatibility_level, UserAccess, Collation, IsTornPageDetectionEnabled, SQLSortOrder, etc.