Check DB MSDB

• MarvinTheAndriod

  SSCarpal Tunnel

  Points: 4972

  More actions

  May 29, 2009 at 9:17 am

  #1002117

  hi_abhay78 (5/29/2009)

  ---

  so its trying to create the sparse file , hitting the latch waittime issue ..

  I am very sure that you are also getting the dump generated ..

  i know of on sparse file issue that logged and fixed in SQL Server 2005 SP3 ..

  Any advise on how to proceed? SP3 installed. Only error as mentioned earlier in the post is:

  Time-out occurred while waiting for buffer latch type 3 for page (1:712)

• Paul Randal

  One Orange Chip

  Points: 29544

  More actions

  May 29, 2009 at 10:41 am

  #1002174

  Try creating your own database snapshot of msdb and then run DBCC CHECKDB on that. I think you're still going to run into the same issue, but it's worth a try.

  Can you also try:

  DBCC TRACEON (3604)

  DBCC PAGE ('msdb', 1, 712, 3)

  Thanks

  Paul Randal
  CEO, SQLskills.com: Check out SQLskills online training!
  Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
  SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
  Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

• MeenakshiSundaram Lakshmanan

  SSC Veteran

  Points: 214

  More actions

  July 30, 2012 at 2:24 am

  #1519024

  Check the mount point whether ADS (Alternate Data Stream) is enabled or not?

  DBCC CheckDb uses internal snapshot.

  NTFS file system alternate streams that are used for the internal snapshot

  With Regards
  MeenakshiSundaram Lakshmanan