Thursday, September 11, 2008

TempDb Optimization for Multiple Processors

"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: