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 |
|
MichaelP
Jedi Yak
2489 Posts |
 Posted - 2003-09-18 : 14:42:55
|
| I've got a 6GB SQL Database that gets mostly reads. I've got another database that we use for IIS logs (~4GB) that is all writes. We are moving to a SAN solution, and I wanted to get some opinions on what's best. And now the question....What is the optimal configuration for the databases (data, TX Logs, temp db etc), disks, RAID, etc.I think I want a RAID 1 Array for my TX Logs (and maybe the IIS logs) and then a RAID 10 array for my data.Thanks all!!Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
JohnDeere
Posting Yak Master
191 Posts |
Posted - 2003-09-18 : 15:03:41
|
| Are all these arrays going to be using the same controller? I would recommend putting the TX log array and data array on separate controllers. If you can afford it moving Tempdb to its own array and controller is nice. Be sure to check/test the controller cache and SQL. SQL2000 SP3 is showing some issues with disk caching controllers (KB826433). We are experiencing these problems now and have turned off all caching on the disk controllers. Funny thing so far we have not experienced any performance slow downs.Lance Harra |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-09-18 : 15:07:16
|
| I think that we are only going to have one controller, with a passive backup controller. It's a 2Gbps connection to the SAN, so that should really help things out. I think we can scale to addtional controllers down the road for a lot more $$$.That disk cache thing is REALLY good info. Thanks for that KB article.We are going for a 2Gbps Fibre Channel SAN with 73GB 15K RPM Fibre Channel Drives. Beats the hell out of our existing SCSI config!Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
JohnDeere
Posting Yak Master
191 Posts |
Posted - 2003-09-19 : 00:28:28
|
| Check with your vendor about recovery issues if you run with caching turned off. Make sure the onboard drive cache is disabled or that will defeat the protocol that SQL server uses to ensure data integrity. KB230785Our vendor is telling us that we are at risk if we have a hard down by turning off the cache, but it has been over 24 hours without an error and before we got at least 2 transient 823's per day.Lance Harra |
|
|
|
|
|
|
Perfect Disk Setup?