Allen Dunn
My feedback
2 results found
-
31 votes
An error occurred while saving the comment An error occurred while saving the comment Allen Dunn commentedCreate 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.
An error occurred while saving the comment Allen Dunn commentedCreate 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.
Allen Dunn supported this idea · -
54 votes
An error occurred while saving the comment Allen Dunn commentedThis would be extremly useful as some monitors such as long running queries or Job Duration could be scheduled against a particular database or Job to be ignored at set times.
I manage VLDB databases and when running index rebuilds or integrity checks on these machines the job duration alert among others will always kick in.
If we could schedule these alerts to ignore them at set times or disable the job against a database for a set period this would reduce alerts waiting for you on Monday mornings considerably.
The amount of alerts is always higher on Mondays due to long running maintenance routines that get picked on several alerts which is always a by product of working on VLDB's.
Scheduling against types or databse would negate these excess alerts.Allen Dunn supported this idea ·
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_configure
A scheduled check against default results could discover any unauthorized changes such as 'allow updates', 'awe enabled', 'blocked process threshold', 'c2 audit mode'. etc