Do splitting tempdb data files according to the number of processors will gain performance improvement? I am more interested to hear about this.
Question of the day : Multiple tempdb data files will gain performance?
2 responses to “Question of the day : Multiple tempdb data files will gain performance?”
-
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/2Note: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.
-
Cloud & SQLSailor 
Leave a reply to Anup Cancel reply