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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

  • 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