title: SQL Server tempdb optimization tips for a new server?
body: <p>I am planning a fresh installation of <strong>SQL Server 2005</strong> on a new machine, which I have to order. I know that <strong>tempdb tuning</strong> is very important to the overall <strong>performance</strong> of the SQL Server instance.</p>
  
  <p>I've read that it's best practice to create as many tempdb files as you have CPU's (or cores?). Is that correct? Are there any other recommendations, e.g. for harddisk/RAID setup configuration I should pay attention to?</p>
  
  <p><em>Thanks!</em></p>