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 |
|
aqualityplace
Starting Member
1 Post |
 Posted - 2008-06-03 : 04:57:58
|
Easy question, I hope  We are setting up an active active sql cluster. The management have done everything the wrong way around and purchased the hardware already. We are planning on having 2 databases 1 in each instance. We will place the transaction log files for each database on their own cluster "physical disk" resource. We only have 4 disks availalbe for the transaction log files. To make things a little more complicated I have been given no information on the expected transaction use other than they should be no larger than 50GBHere are my options 1. 2 Mirrored raid arrays one for each sql instance2. 1 Raid 10 array with 2 logical drives (so the transaction logs are sharing the same disk spindles)What would you do? seperate the disk spindles or share them and go for fast disk performace.Thanks in advanced |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-03 : 15:41:56
|
| You need two raid1 arrays. |
 |
|
|
|
|
|
Log File Location