• Yes, my apologies for not being more precise. When there are more than 8 CPU cores, I generally don't create a TempDB file for each one above the initial 8. It's pretty much as the post says. And as always: It depends...


    Kind regards,

    Vegard Hagen
    Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
    @vegard_hagen on Twitter
    Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)

    It is better to light a candle than to curse the darkness. (Chinese proverb)