SQL Server Performance Forum – Threads Archive
Help with Messages in SQL Server LogsI 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
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.