SQL Server Performance

Resize and split tempdb in SQL 2008 r2

Discussion in 'ALL SQL SERVER QUESTIONS' started by David_W, Feb 21, 2012.

  1. David_W New Member

    Hi, i have a 2 node cluster running on windows 2008 R2 with SQL 2008 R2.

    I am wanting to resize my Tempdb size from 10gb to 2gb and split it into 6 files.

    Now in my testing environment i just restarted the SQLserver service to clear the tempdb database.
    Then I change the file size to 2048mb under the db propertise for the TEMPdb mdf. i restarted the sql services again(so i could confirm the size changed to 2gb) then ran a script to create 5 more tempdb ndf files with the same size and auto resize properties.

    This seemed to work fine but before doing this on my live clustered environment i just wanted to see if this method is ok or if there is a more preferred method?
  2. Luis Martin Moderator

    Fine to me.
    Also you can create new files using tempdb properties.
    How many processor do you have?
  3. David_W New Member

    24 physical cores, thanks.
  4. Luis Martin Moderator

Share This Page