J Hines (12/14/2010)
Chris,Did you have any luck installing more than 25 instances of SQL on your cluster?
We have over 50 instances installed on a 4 node Polyserve Cluster. The maximum you can intall on 1 machine is 50 instances. So each instance can only failover to either 1 or 2 other nodes.
We're looking at doing a major SQL consolidation effort next year I would like to do something similair to what you are doing... installing 40-50 SQL instances on a 3 node (large node verses more nodes) cluster. Sounds like Microsoft is limiting us on our options though.
Also, how are did you partition your local drives out for your cluster? Are you using mount points?
In our Polyserve cluster we have a RAID 1 C: for OS and installs, a RAID 1 D: for pagefile, temp folders.
We don't use mount points, had some issues but I can't remember what they were. Polyserve is fantastic software for consolidation but beware at the moment, they have no support for 2008 R2 and they are being very poor at releasing any information about the roadmap for the software.
Thanks,
Jamey