Alert History groomed out before Alert is Resolved

As you might seen your Alert History information is groomed out from the OperationsManagerDB for non resolved alerts in Operations Manager 2007. This is caused of the stored procedure p_AlertGrooming. The part of the stored procedure that makes this is:

DELETE dbo.AlertHistory
WHERE TimeAdded < @GroomingThresholdUTC

and if you like me would like to have your Alert History intact until the Alert is resolved you should change this to:

DELETE dbo.AlertHistory
WHERE TimeAdded < @GroomingThresholdUTC
AND ResolutionState = 255

With this change of the stored procedure the Alert History is intact until the Alert is Resolved.

SQL 2000 Block Analysis Alerting is disabled by default

Since the release of the SQL MP 6.0.6247.5 the SQL 2000 Blocking Analysis monitor is active and enabled BUT the alerting is default disabled so if you want to get alerts for this monitor you have to make an override to enable the alerting. You can also set parameters as the "Wait in minutes" for the monitor by overrides.

Useful Operations Manager 2007 DB SQL queries

Have you ever wondered what the number of Alerts per Day by Resolution State is in your Ops Mgr 2007 Management Group? This and a lot more you can get by look at Kevin Holman´s OpsMgr blog. He has a lot of useful SQL queries, very useful for us not so good SQL Admins. Take a look at his listning of queries and you can save youreself a lot of time and get good knowledge about your Ops Mgr installation.