Today I thought I would blog about TempDB performance.  On one of my new servers, with 24 cores, I allocated eight TempDB files as that should be enough to distribute the load, reduce contention and improve performance.  However, I forgot to restart the server after hours and it went on for a week and performance did not improve.  It was at this point that I discovered that the files were not be proportionately filled.  A simple Server restart resolved the issue and now it is running like a champ. 

For more advice, check out Microsoft’s guidelines for Optimizing tempdb Performance.

Enjoy!