Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    95

    Unanswered: TempDB Placement - One File Per CPU

    I need some help understanding the benefit of creating tempdb with one file per processor. I believe the benefit has something to do with the way SQL Server utilizes processor threads, but I'm a bit weak on the details.

    Thanks, Dave

  2. #2
    Join Date
    Jan 2003
    Posts
    95
    Here's some more information. Any help is appreciated. If you open the links search for "round robin".

    http://download.microsoft.com/downlo...WithTempDB.doc

    http://support.microsoft.com/kb/328551/en-us

    Thanks, Dave

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •