Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2003
    Posts
    3

    Exclamation Unanswered: TEMPDB is taking over the hard drive

    After a system reboot the tempdb is using all 37 gb of free disk space for file growth and will not allow me to change the properties... Any suggestions? This is not allowing me to use the other databases on the system.. Thanks

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: TEMPDB is taking over the hard drive

    Originally posted by user2131
    After a system reboot the tempdb is using all 37 gb of free disk space for file growth and will not allow me to change the properties... Any suggestions? This is not allowing me to use the other databases on the system.. Thanks
    You can shrink the tempdb by the following command:

    dbcc shrinkdatabase(tempdb)

  3. #3
    Join Date
    Jul 2003
    Posts
    1
    Try using the following first before trying to use dbcc shrinkdatabase:

    BACKUP DATABASE TEMPDB WITH TRUNCATE_ONLY.

    This will clear out all unneccesary/redundant working tables and allow you to gain most of the disk back when you issue the DBCC statement.

    Hope it helps...

  4. #4
    Join Date
    Feb 2003
    Location
    Montreal, Canada
    Posts
    117
    ...and be sure that the recovery model is set to simple. (enterprise manager-db properties-options)

    Originally posted by ShadowMan
    Try using the following first before trying to use dbcc shrinkdatabase:

    BACKUP DATABASE TEMPDB WITH TRUNCATE_ONLY.

    This will clear out all unneccesary/redundant working tables and allow you to gain most of the disk back when you issue the DBCC statement.

    Hope it helps...
    Steve

  5. #5
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102
    a tip to keeping the tempdb a bit smaller to start with - do you use
    a great deal of #table temp tables?
    If so, have you considered using memory tables ( @table ). not only are they faster as they are kept in memory, this should also decrease the amount of objects needing to be stored in tempdb
    -des

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •