I *largely* agree with your issues. There is no hard and fast rule about 1 file per core or CPU. An aweful lot depends on your disk subsystem and how the spindles are spread out. For those with local disks 1 file per core/CPU will probably not be useful because you are likely to have trouble breaking that file up accross spindles unless you have a LOT of local disks, which hasn't been my experience. For those with SAN or equivalent this is a lot easier, however you might start at 1/4 and work your way up. The advice about the autogrow/shrink is correct, turn them off. Set all the tempdb files the same size. Like most things, it depends, I've read the number of files should be an evenly divisible of the number of cores. ie: 8 cores, 2 files, 4 files, or 8 files, NOT 3, 5, 6, or 7 files. I wish I could find that article right now..