Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Is there any way to track tempdb usage when checkdb is running Expand / Collapse
Author
Message
Posted Thursday, June 27, 2013 1:36 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 11:12 AM
Points: 29, Visits: 356
d
Post #1468320
Posted Sunday, June 30, 2013 12:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 29, 2014 5:21 AM
Points: 197, Visits: 730
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
Post #1468844
Posted Sunday, June 30, 2013 5:09 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 5:27 AM
Points: 369, Visits: 1,214
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
Post #1468900
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse