SQL Server Performance

Help with Messages in SQL Server Logs

Discussion in 'Performance Tuning for Hardware Configurations' started by luis.garcia, Mar 8, 2004.

  1. luis.garcia New Member

    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?
    luis.garcia, Mar 8, 2004
    #2

  2. bradmcgehee New Member

    bradmcgehee, Mar 8, 2004
    #2

  3. satya Moderator

    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.
    satya, Mar 8, 2004
    #2

Share This Page