Robert Davis (2/27/2013)

---

ScottPletcher (2/27/2013)

---

Then, set up a start up proc to shrink both tempdb files

NEVER manually shrink tempdb files. It can corrupt the tempdb files. Avoid shrinking files of any database if you can, especially doing it on a regular basis. Putting it in a startup procedure is one of the worst ideas I've heard yet, tempdb or not tempdb.

The key thing that you want to have is all tempdb data files to have the same amount of free space in them. The algorithm SQL uses ends up with being basic round-robin if all data files have the same amount of free space. So simply adding a new file of the same physical size is not sufficient as the new file will have more free space, and all tempdb activity will go to that file only. You need to set them to the same size and then restart SQL so they all start empty (same free space).