• Though im not going to argue with your analysis, the premise of the article

    "Best practices call for tempdb to have one datafile per processor (core)"

    is based on a myth

    http://sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%281230%29-tempdb-should-always-have-one-data-file-per-processor-core.aspx

    "So, why is one-to-one not always a good idea? Too many tempdb data files can cause performance problems for another reason"

    My emphasis.



    Clear Sky SQL
    My Blog[/url]