Latch Timeout

• MostInterestingMan

  SSCertifiable

  Points: 6291

  More actions

  May 11, 2009 at 12:31 pm

  #204134

  Hi,

  I'm getting the following error messages due to latch timeouts and need some assistance please:

  Timeout occurred while waiting for latch: class 'LOG_MANAGER' id 03DF28C0 type 4 Task 0x008DCC58 : 0 waittime 300 flags 0xa owning task 0x006E9F18. Continuing to wait.

  Time-out occurred while waiting for buffer latch type 4 for page (1:982734) database ID 7.

  I ran the following query to determine the exact timeouts duration and got the results below:

  SELECT latch_class, waiting_requests_count, wait_time_ms, max_wait_time_ms

  FROM sys.dm_os_latch_stats

  ORDER BY max_wait_time_ms DESC

  latch_class waiting_requests_count wait_time_ms max_wait_time_ms

  ----------- ------------------------ ---------------- -----------------

  LOG_MANAGER 734 40984030 1273375

  BUFFER 328954561 57944170 300000

  Any help is greatly appreciated.

  Thanks,

  MCTS: BI 2008, MCITP: BI 2008
  Stay Thirsty My Friends

• ajitgadge

  Old Hand

  Points: 334

  More actions

  May 12, 2009 at 2:25 am

  #992685

  How much phy memory on your Box ? How much you assign to SQL server ?

  What kind of queries running while you getting this error ?

• SQLDBA346

  SSC Veteran

  Points: 289

  More actions

  September 14, 2011 at 8:30 am

  #1381336

  hi

  How did you resolve this problem ? I am having same problem in QA. I am not able to change properties of database. can you help me out for this ?

  Thanks in advance