Results 1 to 8 of 8
  1. #1
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    Unanswered: tempdb.mdf is eating sapce

    Hi all,
    sql server 7.0

    I have tempdb.mdf which .mdf file is taking up 1.33gb of my hard disk.
    Is there any way i can solve this problem.
    will it help me by just restarting the sqlserver


    Waiting for ur reply.

    Pls help its very urgent

    TIA
    Adil

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Restarting will have no affect on the size allocated. Look up DBCC SHRINKDATABASE(...) in BOL.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    It only got that big because it needed to. You can shrink it, but chances are it will grow again.

    Someone doing large sorts or extensive joins?
    Fred Prose

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    How big is your hard drive?

    How big are the databases?

    How much free space do you have left?

    Is tempdb set to automatically grow? By what percentage?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    What's the name of the server?
    What's the name of tempdb?
    What's your name?
    What's your DBA's name?
    Did you have a bowel movement this morning?

    Come on, DBCC SHRINKDATABASE/SHRINKFILE will do what is needed! Of course (!!!) tempdb will grow unless you restrict the growth, that's what Autogrowth setting is for.

    And it shouldn't be viewed as a problem unless the result of the analysis of the number and sizes of your databases makes you believe that it's "too big."
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    THE POST ABOVE (the first part of it) IS A JOKE! PLEASE DO NOT START AN ATTACK!
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by rdjabarov
    THE POST ABOVE (the first part of it) IS A JOKE! PLEASE DO NOT START AN ATTACK!
    pftttt...you know me better than that....

    BUT, If they have a 80GB HD, and 40GB Free...Who cares...

    You know, in that case over managing it will cause more overhead and be worse for the server...

    Agree?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  8. #8
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Yup, right on!
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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