Re: CHECKDB causes tempdb to grow

From: Richard Ding (rding_at_acadian-asset.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 16:58:03 -0400

DBCC checkdb ususally doesn't use a lot of space like DBCC DBREINDEX. But if
tempdb does not shrink automatically, check open transactions using DBCC
OPENTRAN.

"Susan" <sjones@sartox.com> wrote in message
news:7dea01c48493$ad643120$a401280a@phx.gbl...
> We run a DBCC CHECKDB statement against each of our
> databases once a week (during off-hours). It runs
> successfully, but each morning after it runs I end up
> having to shrink tempdb's data and log files.
>
> I know that CHECKDB uses alot of tempdb, but why doesn't
> it shrink back down on its own when CHECKDB is finished?
>
> Thank you!
> Susan Jones

Relevant Pages

  • Re: database space
    ... Because page locking in work table is unreliable, shrink ... skips work table and work file during tempdb shrink. ... file to a smaller size - the result will translate to a lot of 'unallocate ... Any object/index could use the space. ...
    (microsoft.public.sqlserver.server)
  • Re: tempdb sizing
    ... During the DBCC CHECKDB (Integrity Check Job via ... It is NOT the transaction log that was heavily hit. ... I saw the tempdev datafile filling up quickly so I added ... the datafile on the tempdb than the transaction log. ...
    (microsoft.public.sqlserver.server)
  • Re: database space
    ... I would like to know when my tempdb starts to grow and caused by ... it means the database used very little space in ... >> skips work table and work file during tempdb shrink. ... >>>> Microsoft SQL Server Storage Engine ...
    (microsoft.public.sqlserver.server)
  • TempDB wont shrink
    ... set to auto shrink. ... DBCC SHRINKFILE does nothing. ... If I look in TempDB for any temporary tables, ... I've looked for reindexing operations in their code and didn't see ...
    (comp.databases.ms-sqlserver)
  • Re: A very strange behaviour
    ... > The result of the reports started to produce different results every time ... I execute the procedures, after hours of investigation I tries to shrink the ... When I shrink the tempdb again the same behavior repeated again. ...
    (microsoft.public.sqlserver.programming)