All Questions
2 questions
4
votes
1
answer
8k
views
Tempdb Add files require Restart
Does adding Tempdb files require a restart? We would like to Add files on the same drive, Not Delete and Not modify. We tested in Dev and QA environment, restart was not required. However for ...
0
votes
2
answers
913
views
Tempdb files Solid state on Same drive?
We currently have tempdb (8 files) on solid state drive.
We know that primary mdf and transaction log ndf are recommended to be on different drives, to reduce contention. Should tempdb files be on ...