Number of Files for Tempdb
Posted by decipherinfosys on July 16, 2009
For those who have worked in SQL Server for some time, know that one of the best practices that is recommended for tempdb is to have multiple data files – 1 data file per CPU as seen by SQL Server since it creates a logical scheduler for each CPU that it can access. You can read more on this post by Robert Dorr @ the CSS SQL Server Engineers blog post.
