Skip to content

Allen Dunn

My feedback

2 results found

  1. 31 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    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_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

    An error occurred while saving the comment
    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.

    An error occurred while saving the comment
    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.

    Allen Dunn supported this idea  · 
  2. 54 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    Allen Dunn commented  · 

    This 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  · 

Feedback and Knowledge Base