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 |
|
shebert
Yak Posting Veteran
85 Posts |
 Posted - 2012-08-27 : 13:20:12
|
| Hellothe computer 2 CPU 32 total coresso I have a mirrored c drive and 4 - 1T drives Raided should I create a E:\ data partition, an F:\ log partion and G:\tempDB partion of 320gig ?I have read that I should create 32 10gig TempDB files on G:Any suggestions?Thanks AgainSteve |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-08-27 : 14:42:15
|
| You won't need 32 tempdb files. At most, you probably will only need 8 files - if you have PAF issues with your tempdb. It won't hurt to create the multiple files but creating that many won't be needed. |
 |
|
|
|
|
|
Moving DB to New server, part2 Disk setup