Is there any way to track tempdb usage when checkdb is running

  • d

  • Depends on what exactly you want to know.

    You can either use SQL Profiler for tracing what is happening on the tempdb itself or you can use the Performance Monitor. Have a look at all the counters and choos what you need 🙂

  • Command

    DBCC CHECKDB('yourdbname') WITH ESTIMATEONLY

    will not check your database, but will give you estimation on how much tempdb space will be needed for checkdb.

    If you need to track what is happening during real DBCC execution, you can use standard tools like DMVs, trace, perfmon, extended events - depending on what you really want to track.

    _____________________________________________________
    Microsoft Certified Master: SQL Server 2008
    XDetails Addin - for SQL Developers
    blog.sqlxdetails.com - Transaction log myths

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply