Kevin Holman's OpsMgr Blog : Tuning tip: Do you have monitors constantly “flip flopping” ?

This is something I see in almost all clients when we perform a PFE Health Check.  The customer will have lots of data being inserted into the OpsDB from agents, about monitors that are constantly changing state.  This can have a very negative effect on overall performance of the database – because it can be a lot of data, and the RMS is busy handling the state calculation, and synching this data about the state and any alert changes to the warehouse.

Many times the OpsMgr admin has no idea this is happening, because the alerts appear, and then auto-resolve so fast, you never see them – or don’t see them long enough to detect there is a problem.  I have seen databases where the statechangeevent table was the largest in the database – caused by these issues.

Too many state changes are generally caused by one or both, of two issues:

Kevin Holman's OpsMgr Blog : Tuning tip: Do you have monitors constantly “flip flopping” ?