Discussion Locked

SQL2000 Clustering

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Ok, here is what I would like to do/try. Cluster two Compaq ML770's (MS DataCenter servers with 16 cpu's) and SQL 2000. I then would stop the Clustering services and and keep the SQL services running all conected to the same drive array. What do youthink? Will I get sharing violations? My ultimate goal is to use Resonate (Performance based alancing software)to load balance SQL. Has anyone tried this????

3 replies

by gbworld

This solution is potentially scary. While the load balancing potential here is nice, the product is not specifically designed for SQL Server 2000, on or off DataCenter server.

Has anyone tried this? Is this a troll? First off, this is some prettyexpensive hardware to risk throwing into a situation like this. Second, what kind of load are you talking about that needs this type of load balancing?

I would imagine that you would not be able to "get around" the sharing violations here. The primary problem is that you are having two database servers share the same mdb, ndb and ldb files without the other being aware of the other's file access. It is more likely that the other database server will view the database as suspect after an update from one. Without some form of software that works with SQL Server, this is most likely a best case scenario. Taking a quick look at their site, I cannot see where the product integrates with SQL Server, which is definitely needed to share files with two servers.

I would personally love the opportunity to play with the toys you have to play with, but I would find another load balancing solution for SQL Server 2000, esp. with DataCenter Server. This is far too much money to integrate into asolution not specifically designed for SQL Server.

GB

This discussion is closed to new replies.