"The current recommendation from Microsoft is that you have a file per logical CPU for tempdb so as to balance load not only for object creation but for extent allocation and performance."
Ref : SQL Server write behaviour with multiple files in a file group
So, split TempDB by the number of processors.
Using current size of TempDB as a guide (2GB) and 2 Processors, split to 2x 1GB files.
My previous blog entry on how to do > Moving / Adding files to TempDB
No comments:
Post a Comment