Hi,

Today we received an alert in SCOM console but the alert was raised 9 hrs ago. I could not find the reason as why was it displayed so delayed in the SCOM 2012 Operations console.

Any suggestions.

Thanks,

Srini

To  investigate the alert latency issue you can use this sql query against OperationsManager database:

SELECT AlertID, 
  TimeRaised,
  TimeAdded,
  DATEDIFF(minute,TimeAdded,Timeraised) as TimeDiffInMin
FROM [dbo].[Alert]
WHERE 
DATEDIFF(minute,TimeAdded,Timeraised)>= 1
order by TimeDiffInMin desc

Let me know what you get.

Hi,

TimeRaised
Timestamp, created when the Alert is raised on the agent.

TimeAdded
Timestamp, created when the Alert is written into the OpsMgr database.

The difference between TimeRaised and TimeAdded is called Alert logging latency.

I would like to suggest you go through the article below to get more details:

Analyzing SCOM 2012 Alert logging latency

http://blogs.technet.com/b/dirkbri/archive/2014/08/19/analyzing-scom-2012-alert-logging-latency.aspx

Regards,

Thanks Jeff.

That gave me the information I need. I got the alert latency informatoin for all the alerts.

Regards

Srini

• Marked as answer by Srijai980 22 hours 59 minutes ago

Hi Yan,

Thanks for sharing this link which is really informative and very helpful :)

Regards,

Srini

Thanks Jeff.

That gave me the information I need. I got the alert latency informatoin for all the alerts.

Regards

Srini

• Marked as answer by Srijai980 Friday, February 20, 2015 12:33 PM

Thanks Jeff.

That gave me the information I need. I got the alert latency informatoin for all the alerts.

Regards

Srini

• Marked as answer by Srijai980 Friday, February 20, 2015 12:33 PM