Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Tempdb Contention - sys.dm_os_waiting_tasks RE: Tempdb Contention - sys.dm_os_waiting_tasks

  • January 31, 2011 at 7:24 pm

    #1280718

    Hello Kevin,

    Thanks for your reply.

    I understand that DBCC CheckDB uses TempDB heavily. But is it a normal thing to observe the wait duration of 20 ms during the DBCC CheckDB run as I am experiencing?

    Cheers