Hardware recommendations for two node cluster

Giganews Newsgroups
Subject: Hardware recommendations for two node cluster
Posted by:  Michael MacGregor (nospam@nospam.com)
Date: Fri, 19 Oct 2007

I am looking at putting the specs together for a new SQL Server 2005
cluster, two nodes. It needs to be capable of supporting multiple customer
databases, around 20-30, average database size is 3GB but several will be in
the region of 10-20GB, capable of handling 10,000 transactions per minute
minimum.

I am actually mostly interested in what would be required in order to
provide a cluster array that can provide physically separate disk drives so
as to place different databases on different drives, accessed by different
controllers, i.e. such that there is no bottleneck or disk contention, or to
at least minimise such.

Any and all recommendations are welcome.

Michael MacGregor
Database Architect

Replies