Hi, I work for a SaaS vendor with a great problem to have... lots of growth. We are currently in the planning phase of our Generation 3 high availability infrastructure. Currently, we use a combination of MS clustering and redundant equipment in aa active production site with a passive warm DR site receiving data in near real-time using WANSync. One thing we really want to do is deploy load balancing at the database level. This(along with other changes) would allow us to have Active/Active production sites rather than Active/Passive, with the expensive DR equipment collecting dust unless we fail over. Im not talking about Multi-instance or Active/Active SQL clustering, were looking to actually distribute database transactions the same way you might load balance a website.
So my questions is wed rather buy than build, but there seem to be few or no products on the market which can do this for MS SQL. GIRDSCALE seems to have the right feature set, but no SQL support. Any suggestions?