Skip to main content

All Questions

Filter by
Sorted by
Tagged with
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 ...
user avatar
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 ...
user avatar