tempdb multiple files RRS feed

  • Question

  • We've been advised to create more tempdb files for our prod server as currently we have only 1 tempdb file.


    1/ How do I create multiple tempdb files ? Is it correct that a 1st tempdb file (tempdev) is primary with .mdf, then add a 2nd tempdb file with .ndf, and so on ??

    2/ Does it require any down time to relocate temdb file to a different drive ?

    Tuesday, August 28, 2012 5:25 AM


All replies