Groups | Blog | Home
all groups > sql server clustering > november 2004 >

sql server clustering : SQL Cluster on SAN



Randy
11/21/2004 8:41:03 PM
I'm designing a 3 node cluster that will be running SQL Server and Exchange
in an Active/Active/Passive configuration. The cluster will be using a small
SAN for storage (HP MSA 1000). The first active node will run SQL. The 2nd
active node will run Exchange, and the 3rd passive node will be failover for
both. Exchange will support approximately 150 concurrent users with a ~10GB
store. SQL will support 4 active databases/apps with approximately 80 total
concurrent users. Please advise if this is a viable cluster configuration.

More importantly, please advise on the best storage configuration for the
cluster. We have 4 Ultra320 SCSI buses with 7 drive bays each (28 total) on
the MSA1000 and attached dual bus enclosure. Also, we have 12 Ultra320 10K
146GB drives we'd like to re-use in the array. We can populate the remaining
drive bays with whatever drives we need.

Randy
11/21/2004 9:01:04 PM
Here are the possible shared logical drive requirements that I'm aware of:
* Cluster Quorum
* MS-DTC
* SQL T-Log(s)
* SQL TempDB
* SQL Data drive(s)
* Exchange log
* Exchange data

Option A
2x36GB 15K RAID 1 (A/B buses) - 1 LUN - Quorum
6x36GB 15K RAID 0+1 (A/B buses) - 4 LUNs - MS-DTC, Exchange logs, SQL logs,
TempDB
2x36GB 15K online hot spares (one each A/B buses)

12x146GB 10K RAID 0+1 (C/D buses) - at least 3 LUNs (Exchange data, SQL
data, TDB data)
2x146GB 10K online hot spares (one each C/D buses)

SQL performance and scalability is primary concern. Please advise if this
configuration is optimum. If not, any recommendations?

Thanks in advance! - rg
Alfred XYZ
11/26/2004 12:42:30 AM
Hi,

MSA1000 supports ADG RAID that allows at most 2 physical
disks failed without loss of data. ADG array is formed by
at least 4 disks, which offers available sizes of 2 disks,
with 5 has 3, with 6 has 4, and so on.

In my company, all logical drives for SQL data, quorum and
MSDTC are created on ADG RAID drives for optimal
redundancy.

In contrast, for log files, use 0+1 RAID type for higher
rate of write I/O. (MSA1000 can create 0+1 array with 2
physical disks)

Both 0+1 drive and ADG drive are created on seperate array.
In my case, 4 drives forms ADG while 2 drives forms 0+1.

Finally, my system have 2 clustered SQL servers sharing
the same MSA1000. Always create arrays specific to the
services. This could prevent degrade of performance on
both services, especially signficant to collect
information of performance log. In your case, don't put
files of SQL server and Exchange on the same arrays.

My final conclusion, you should create 2 arrays: One
always creating ADG drives, for quorum, MSDTC, SQL server
data, tempdb and SQL & Exchange install. One creating 0+1
drive for SQL server transaction log and exchange log

Hope this help. ^^


[quoted text, click to view]
Alfred XYZ
11/26/2004 12:50:46 AM
!!!Correction.!!!
My final conclusion, you should create 4 arrays: One
always creating ADG drives, for quorum, MSDTC, SQL server
data, tempdb and SQL install.
One creating 0+1
drive for SQL server transaction log
Two for Exchange data and log respectively.


[quoted text, click to view]
AddThis Social Bookmark Button