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 |
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
 Posted - 2008-07-31 : 03:49:49
|
| Hi,We have a plan for server cosolidation in to a cluster.Pls suggest good hard ware configuration whcih can support1) Only 16 sql 2000 instances2) some sql 2000 instances + some sql 2005 instancesAlso how many instances a single cluster can support with a good hardware config.Thanks In AdvanceThanks & Best Regards,Krishna |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-07-31 : 16:10:54
|
| As given, it sounds like a disaster in the making. Each Virtual Server is going to need its own dedicated disk resource. Unless you reduce the number of SQL Server instances, you are looking at over 17 (gotta have a quorum, remember?) dedicated disks. This puts you well into the "Requires a SAN" range.As for what sort of server to buy for the physical nodes, remember that if you have an outage, you will want the remaining node(s) to be able to carry the load from all of these servers at once, so you will need a minimum of two servers that can run the load of all of these instances at the same time. With over 16 instances of SQL Server running around, they are all going to be fighting one another for memory just about all of the time. Once again, you will need to reduce the number of instances involved. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-31 : 16:17:47
|
| We run 11 instances on a 4-node cluster. Each node has 16 CPUs (8 dual-core currently) and 32GB of RAM. About half of the instances are mission critical and have high availability constraints. We mirror out to a DR site.All of our instances are SQL Server 2005. We use mount points so that we don't run out of drive letters. So we only need 13 drive letters (11, quorum, and MSDTC) but are using 44 mount points.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2008-07-31 : 19:33:20
|
| Hi mcrowley,tkizerThanks for your info, very useful. Tkizer, you are having a n+1 cluster or all acitive? Also how many instances a node owns primarily ? Also I hope 11 instance will work with as 2 node cluster with the same configuration.ThanksThanks & Best Regards,Krishna |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-01 : 00:49:23
|
| All 4 nodes are active in our cluster. Each node has between 2-4 instances active on them.We wouldn't be able to run the 11 instances on only 2 nodes. We'd have a huge performance problem in that configuration.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2008-08-01 : 13:52:11
|
| Hi tkizer,I was searching to know about a general config needed for a 4 node or so large 2 node multi-instance cluster. Appreciate your fast & good response.Thanks & Best Regards,Krishna |
|
|
|
|
|
|
|
|
Pls Advice