Sample Header Ad - 728x90

Splitting TempDB into multiples files equal to number of CPUs

8 votes
2 answers
11548 views
The article SQL Server tempdb Best Practices Increase Performance suggests that I should split tempdb into a number of files equal to the number of cores. So for 4 cores you get 4 files. > By having the larger number of files, you can increase the number of > physical I/O operations that SQL Server can push to the disk at any > one time. The more I/O that SQL Server can push down to the disk > level, the faster the database will run. With standard databases, SQL > Server can cache a large amount of the data that it needs into memory. > Because of the high-write nature of the tempdb, the data needs to be > written to the disk before it can be cached back up into memory. Though it sounds good in theory, is it really that good as a general optimisation? Is it something that may only apply for specific systems where IO is very high?
Asked by Preet Sangha (907 rep)
Jan 23, 2013, 10:21 PM
Last activity: Sep 26, 2019, 11:15 PM