SCOM Monitoring

  • I'm posting here as I'm mainly looking at using the SQL 2014 management pack for SCOM, but please correct me if this should be somewhere else.

    I'm setting up some SCOM monitoring for SQL and am looking for any guides, which I've been going round in circles trying to find, on the recommended overrides for each type of alert specifically for the SQL management packs.  You wouldn't believe how difficult it is to find anything. 

    I have started by overriding a few of the monitors just to make them enabled and set up some subscriptions to just these alerts so far, these were for the alwayson failover events which are pretty straight forward.  What I want to stop happening is that I switch on the other alerts and get flooded with 5000 alerts because all of the default Microsoft settings need to be adjusted to some sensible levels for such things as waittime and CPU.  I know it's good to know sometimes when events happen at a lower threshold but my aim is to send these to a helpdesk and have incidents logged for them, so don't want an incident for every low level nice to know alert that will clear itself in 2 minutes, that's what the rules writing to the datawarehouse in SCOM are for! (rules vs monitors in SCOM).

    So does anyone have any recommended blogs or articles that could help with recommended threshold settings for SQL Management packs for the overrides for SCOM monitors?

    Thank you.

  • Just bumping this to the top, please advise if I should post in another forum on here, or elsewhere as not sure where to turn with this now.

  • BU69 - Wednesday, January 24, 2018 3:58 AM

    Just bumping this to the top, please advise if I should post in another forum on here, or elsewhere as not sure where to turn with this now.

    One of the SCOM forums might get you some information. Maybe try these:
    Systems Center Operations Manager
    System Center Central

    Sue

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply