This is a great topic and one that resonates with some of the challenges that I have daily with my colleagues. One of my original mentors gave me the...

Thanks for the informative reply. I've come to the conclusion that there is nothing that I can do as a sysadmin to work around the limitations of the application....

Thanks for the reply. Did you find something through Google that I haven't? Everything there seems to say that you can't really load balance SQL server. You...

Wayne,

What should I be looking into for load balancing purposes? I've been trying to do some research about distributed servers but have not come up with much.

The SAN guys should be able to run reports to show you the IO performance of your LUN. If your application is fairly small you can probably get away...

I use Backup Exec 2010 with the SQL Server agent and I point it at the cluster virtual server (not the actual node).