SQL Server Performance Forum – Threads Archive

Help with Messages in SQL Server Logs

I am receiving in my SQL Server environment this messages in the SQL Server Logs: WARNING: EC 20c88098, 4 waited 300 sec. on latch 42cad3f0. Not a BUF latch. Right now we have problems with slowness in an application that runs a stored
procedure from this server every time they click a button. Like 20 users run this stored procedure but it takes too long in the application
interface to do this stored procedure.
I really don’t understand this message can someone understand it?

See this URLs for help: http://support.microsoft.com/default.aspx?scid=kb;EN-US;310834 http://support.microsoft.com/default.aspx?scid=kb;EN-US;309093 If these don’t address your issue, and if you have the latest Service Pack installed, it is possible that you have run across a new bug, and you may need to contact Microsoft support. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

As referred by Brad follow the KBA 310834 which addresses the cause of these errors and ensure you’ve tackled them to resolve. Best bet is also go thru event viewer log for additional information. If nothing fetches fruitful results MS Support is the last resort. 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.

]]>