Hi All,

Currently i am facing DW size issue. When i check the stats Event Dataset collecting more data and utilizing more size. Kindly let me know how to find which event is collecting more in Event dataset.

I used "Most common alerts" report in reporting and disabled those alerts too. even after disabling the event collection is not yet reduced.

Kindly help me.

Regards,
Sandy.

Hi Sandy,

It has nothing to do with alerts. You forgot to tell what OpsMgr version you're using...

You can check this queries (events section): http://blogs.technet.com/b/kevinholman/archive/2007/10/18/useful-operations-manager-2007-sql-queries.aspx

Hi Alexey,

I am using SCOM 2007R2.

So, the Events section above contains the queries you want. You can find the most common events and disable the collecting rules.

Hi Alexey,

Apart from this any other way is there to identify.

You can try this, but those reports are using almost the same queries...  http://www.systemcentercentral.com/scc-health-check-reports-management-pack-v2/

Gives top 20 alerts in an Operational Database, by Alert Count:

SELECT TOP 20 SUM(1) AS AlertCount, AlertStringName, AlertStringDescription, MonitoringRuleId, Name  
FROM Alertview WITH (NOLOCK)  
WHERE TimeRaised is not NULL  
GROUP BY AlertStringName, AlertStringDescription, MonitoringRuleId, Name  
ORDER BY AlertCount DESC