Post reply

reconfiguring tempdb

  • June 7, 2021 at 11:40 am

    #3892937

    hi folks

    i have a sql server that has 15 tempdb files split over 2 drives, and autogrowth of 10mb or 64 mb depending on location

    the server has only access to 8 cpu's.

    i want to reduce the files to 8, size them up equally with plenty of space and put them all onto one drive.

    what is the best approach to this? should i shrink the files and then remove, do i need to be offline to do this?

    any advice appreciated

     

    thanks

     

    mal

  • June 7, 2021 at 3:22 pm

    #3893016

    Make catalog changes to that your new tempdb file set up takes effect the next time SQL starts up.  You just have to delete the old tempdb files yourself.  I personally wouldn't remove tempdb files on a running system.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

  • June 14, 2021 at 1:03 pm

    #3895933

    One other thing is that all of the files should be sized exactly the same and have autogrowth set to the same size.  I personally would have the autogrowth way higher than 10 and 64mb as you will have a lot of fragmentation to the files in tempdb.

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

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