Re: Keep getting Event ID 31551   

Hello opsmgr,

Check and see if you have any 2115 events in the Operations Manager Event 
Log. While 1 or 2 an hour is ok, if you have 20, or 30 or more, it is a clear 
indication of latency in writes to the data warehouse. If this is the case, 
start by using the Windows Perf Counters to look for disk latency. Also, 
check memory to see how much SQL is consuming. If the server is absolutely 
tapped of memory (or SQL usage has been capped by your DBA0, I have seen 
this lead to latency as well.

Regards,

Pete Zerger, MCSE(Messaging) | MCTS(SQL 2005) | MCTS(Opsmgr) | MVP - Opsmgr
URL:http://www.systemcenterforum.org
Training: http://www.systemcenterforum.org/training
User Group: http://www.systemcenterusergroup.com


> Hi Anders,
> 
> I have verified these account multiple times and they do exist. We get
> event id 31551 followed by 31554 in few minutes with the same workflow
> name. I am just curious to find out exactly what is causing all these.
> Thanks.
> 
> "Anders Bengtsson [MVP]" wrote:
> 
>> Hi opsmgr,
>> 
>> Please take a look at
>> http://blogs.technet.com/alipka/archive/2006/07/05/440223.aspx
>> 
>> --
>> Anders Bengtsson
>> Microsoft MVP - Operations Manager
>> Microsoft Certified Trainer (MCT)
>> http://www.contoso.se
>>> Failed to store data in the Data Warehouse. The operation will be
>>> retried. Exception 'SqlException': Timeout expired
>>>

date: Wed, 23 Jul 2008 13:11:33 +0000 (UTC)   author:   Pete Zerger (MVP)