Post reply

Unallocated Space

  • October 14, 2011 at 9:49 am

    #390623

    Hi All,

    I am trying to free unallocated space on tempdb.

    I am assuming a restart of the sql service would help. Any other alternatives.

    I have tried shrink but it only frees Unused space and not unallocated.

    Thanks,

    Suri

  • October 14, 2011 at 10:29 pm

    #1394909

    ALTER DATABASE tempdb MODIFY FILE...

    followed by restarting sqlserver is the easiest way.

    If your tempdb grew too big, you might consider pre-sizing it big and disabling auto-growth.

  • October 15, 2011 at 12:53 am

    #1394932

    I am trying to free unallocated space on tempdb.

    May I know why do you want to do that? If you have any issues, following article might help you.

    Troubleshooting Insufficient Disk Space in tempdb

    http://msdn.microsoft.com/en-us/library/ms176029.aspx

    Optimizing tempdb Performance

    http://msdn.microsoft.com/en-us/library/ms175527.aspx

    Capacity Planning for tempdb

    http://msdn.microsoft.com/en-us/library/ms345368.aspx

  • October 17, 2011 at 11:56 am

    #1395508

    SpringTownDBA (10/14/2011)

    ALTER DATABASE tempdb MODIFY FILE...

    followed by restarting sqlserver is the easiest way.

    If your tempdb grew too big, you might consider pre-sizing it big and disabling auto-growth.

    I do not recommend disabling auto-growth on tempdb. You can size it larger and adjust how it grows, but I would not disable the auto-growth.

    Jared

    Jared
    CE - Microsoft

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

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