dbo.Alert flooded

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

dbo.Alert flooded

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> System Center Products >> System Center Operations Manager >> dbo.Alert flooded

Page: [1]

Message

<< Older Topic Newer Topic >>

dbo.Alert flooded - 8/26/2008 7:42:43 AM

GizMo

Posts: 3
Score: 0
Joined: 7/25/2008
Status: offline

Hi all,

we have a clustered scom server with an extra DB Cluster. on this DB cluster der are the DBs OperationsManager and OperationsManagerDW. Reporting Service is not installed.

Our problem is, that the table OperationsManager.dbo.Alert have about 2million entries and is 5GB. only this 1 table. Grooming is set to 7 days, but did not work (maybe because our SQL team backup the TLog every 10min and the grooming process interrupt everytime.)

but our problem is, that we have not 2million real alerts, there are only ~500 alerts,

i ran a
select count(*)
from Alert
where alertname ='Microsoft.SystemCenter.NTService.ServiceStateMonitor'

and the Result was a counter of ~1million.

so in this table there are 1million sensless information about the ServiceStateMonitor.

the other 1million data look like this:

and it repeats alle the time...

any1 know why and has a solution for this?

thanks in advance
-Oli

/edit: while i wrote this, 300.000 new "alerts" in the table -.-

< Message edited by GizMo -- 8/26/2008 7:46:45 AM >