SQL 2000 Load Balancing Question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello

I have a question that I hope someone can shed some light on. We are
currently running a dedicated Dell 2850 SQL server box with a single
database on it that has become very heavily used over the last year. What
we'd like to do is to add another server (rather than buying higher spec
hardware) to load balance the SQL database. I'm aware that I will need to
buy some shared storage (such as a Dell PV 220s) and connect the 2 servers
to this but will I be able to load balance the single database in this
situation so that half the traffic goes to one server and half to the other?
I've read a bit about clustering and would like to setup a cluster where
both nodes are accessing the same database and if one node fails, the otehr
will take over (albeit with a performance reduction of course).

Thanks for your help guys.


.

Relevant Pages