Post reply

tempdb wont shrink

  • January 14, 2007 at 9:51 pm

    #90880

    HI, my tempdb database is getting bigger 5GB, it wont shrink ??

    I ideas to fix it or diagnose the issue ?

  • January 14, 2007 at 10:06 pm

    #683150

    How to shrink the tempdb database in SQL Server

    http://support.microsoft.com/kb/307487

     

    MohammedU
    Microsoft SQL Server MVP

  • January 14, 2007 at 10:13 pm

    #683152

    I know how to shrink the tempdb, its the fact that it wont shrink.

    I use method 2 from link ...

    Why wont it shrink, what could be the causes !!!

  • January 15, 2007 at 10:24 am

    #683300

    what is the defined size of the tempdb? tempdb gets recreated every time you stop and start the server, so if you stoip and start, and it is still 5 gig, then it's proable defined as that big:

    EM is the easiest: right click on the temp db...properties..Data files tab... look at the Space Allocated fields

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 4 posts - 1 through 4 (of 4 total)

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