I am trying to figure out if it is possible (And how exactly?) to LB a SQL Server.
Say we have 1 DB. Not only do other applications access it (read and write) but say if there is a very intense and long running job that runs on the DB today, is there a way to have some kind of LB where the load gets distributed and still have uptime for the SQL DB so clients still can access it at the time the "mega" job(s) run?
What is involved in this?
How does one set this up?
Would this be clustered based or something else?