SQL Database temp database

Any idea how to split the temp database in serveral files in order to improve the SQL database performance ?

We will replace the SQL server and I'm thinking of use a SSD hdd to put the tempdb and log file. Any comment ? Any fact for the new server to improve the performance is appreciated ?

Great Tks.
Who is Participating?
PadawanDBAConnect With a Mentor Operational DBACommented:
I always like how the Ozar team explains stuff: http://www.brentozar.com/?s=tempdb.  Specifically recommended, the Bob Dylan explanation of the TempDB =)
AXISHKAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.