Posted by: Denny Cherry
SQL Server, Top 10
I'm a DBA (shocking I know), so I plan everything possible that I can to the servers that I'm setting up for clients. In this case that includes thinking about what's going to happen when the server (or VM) totally fails and they need to rebuild the OS from scratch and get everything back up and...
How TempDB should be setup is a question that comes up a lot, mostly because there is a lot of bad information out there. So here's how I typically setup TempDB for the bulk of my clients, and these settings will probably work for you as well.