SQL Server Performance

Should tempdb files no longer be separated per processor/core when on a VM?

Discussion in 'ALL SQL SERVER QUESTIONS' started by Trev256b, Jun 21, 2013.

  1. Trev256b Member

    Should tempdb files no longer be separated per processor/core when on a VM? i.e. should you not create extra .mdf/.ndf files, and just keep one .mdf files?
  2. ghemant Moderator

    I am not sure at this moment, I will do some research and will post my answer tomorrow.
  3. Trev256b Member

    Hi Ghemant - did you find out the answer, as I can't find this on the internet?
  4. ghemant Moderator

Share This Page