Do splitting tempdb data files according to the number of processors will gain performance improvement? I am more interested to hear about this.
-
Follow
Following
Already have a WordPress.com account? Log in now.
Do splitting tempdb data files according to the number of processors will gain performance improvement? I am more interested to hear about this.
SQLSailor 
The optimal solution is yes,but it depends on your work load(Too many TempDB data files (like one per core on an 80-core system).
#datafiles=No.of cores/2
Note:SQL Server recommends that you create as many files as there are COREs or CPUs to minimize allocation bottlenecks.
True, This was an old post when I tried Q/A based polls.
I normally go with less to start with an increase if there is contention.