none
tempdb multiple files

    Question

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

    Question:

    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

Answers

All replies