What exists today to do Microsoft SQL Server Load Balancing on Windows Server and being transparent to any programmatic access. Is this built in or does a solution have to be purchased?

297    Asked by CameronOliver in SQL Server , Asked on Feb 7, 2023

What exists today to do Microsoft SQL Server Load Balancing on Windows Server and being transparent to any programmatic access. Is this built in or does a solution have to be purchased?

I'm trying to find out if there is a solution today that makes this very easy from the viewpoint of the web servers or other database access to SQL Server.

There is no "standard" SQL Server load balancing setup for MS SQL Server that you can run via a wizard.


This would be adatabase architecture decision and implemented at the database level not the server level. Techniques would be:

  • Scaling out/federating the database servers
  • Partitioning
  • Offload your reporting requirements
  • Perhaps replication

If anyone disagrees, then I'd like to see an article by a respected known MS SQL figure saying clustering is load balancing. The articles quoted above do not mention load balancing. For example, A Microsoftie (Chas Boyd) says it is not here.

My question to the OP would be what kind of load do you expect?

Database servers are usually IO and memory bound, so proper disk configuration and as much RAM as possible will go a lot further than any solution above. Don't forget: SQL Server 200 /Windows 2003 Enterprise 32-bit goes to 32GB RAM (of which you'd have 26-28GB data cache) and you are not limited by drive letters because of NTFS mount points. As for x64…


Your Answer

Interviews

Parent Categories