Add files to TEMPDB for optimal performance
This is somewhat of a reminder for SQL Server installations. In a Technet article titled Storage Top 10 Best Practices (published in 2006), Microsoft recomend that, in the case of the TEMPBD database, the number of files is equivalent to the number of CPU’s. The below script is an example...
[Read More]