SQL Server Performance Forum – Threads Archive
Errorlog Warning
Hello This is what I found in my Errorlog (MSSQL2000(sp3)-WINSRV2000):WARNING: EC 2e181550, 0 waited 300 sec. on latch 19cfc0f4. Not a Buf latch. Anybody have an idea what is the meannig of the warning ? Thanks,
Oryan
Latch timeouts indicate a disk issue. I would monitor the performance counters for the disks to investigate further. It could also indicate a page hot spot if you read/write the data on the same data or index page very frequently. Searching on the error on google it seems there have been some known bugs causing the error you get as well. All before SP3 though: FIX: Parallel Index Operations Might Cause Latch Warning Messages
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q810195 FIX: Bulk Insert Operation May Cause Blocking
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q322379 FIX: Buffer Latch Timeouts or Server Sluggishness Occurs When You Remove Procedures From Cache
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q309093 /Argyle
Most of it covered by Argyle with KBA references, BTW what is the level of service pack on SQL & OS? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
The service pack on SQL is SP3 and same for OS. Oryan
As Argyle said warning came from disk.
How about update statistics, defrag index and monitor disk activity to find issues disk?
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
Monitor the activity and findout exactly at what point this error occurs and follow as referenced by KBAs above. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
I will try to tune the DB/Server according yours replies,
and I will inform you about actions taken and results. Thanks you all,
Oryan
]]>