Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2006-09-08 : 20:14:42
|
| 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 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-09 : 04:53:34
|
| Don't know the answer, but I remember reading somewhere that the multiple files must be carefully constructed - exactly the same size and an exact multiple of the number of CPUs, or somesuch.Just in case that helps your Googling!Kristen |
 |
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
|
|
|
|
|
TempDB Placement - One File Per CPU???