SCOM Alert subscription query high watermark
Hi all,
I have a SCOM 2007 SP1 with CU1 and I started geting some strange allerts:
Event Type: Warning
Event Source: Health Service Modules
Event Category: None
Event ID: 11410
User: N/A
Computer: <<RMS>>
Description:Alert subscription data source module encountered alert subscriptions that took a long time to execute their database query. Check the database and/or simplify the alert subscription criteria.
Alert subscription ruleid, Alert subscription query low watermark, Alert subscription query high watermark:
<<ID>>, <<DATE1>>, <<DATE2>>
Does anyone knows what is the reason of this?
Br,
Adrian
LE: I have deleted the curent profiles rom the RMS and cleared cache from all console!, I`m waiting to see if new alerts appear
April 19th, 2011 4:24am
It looks like your database is having a hard time serving the load. You should check the database for performance issues.Regards,
Marc Klaver
http://jama00.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
April 19th, 2011 9:15am