Load Balancing - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Load Balancing

Author

Topic

wkm1925
Posting Yak Master

207 Posts

Posted - 2009-12-25 : 01:14:08

Hi,

In Web application, we have load balancing server to distribute the load among the group of servers to entertain high capacity of HTTP request

In database, what the technology is available?

ajitgadge
Starting Member

12 Posts

Posted - 2009-12-28 : 08:41:25

Typically, Active/Active clusters are used in such a type of scenario. But you can also think for data mirroring , replication or log shipping as per your business requirement.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-28 : 13:09:01

Active/active cluster does not provide load balancing. SQL Server doesn't provide load balancing except through partitioning.

Mirroring also does not provide load balancing since the mirror database is not available for queries.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-12-28 : 14:29:14

We use replication to keep several SQL Servers in synch.

Web servers point to different SQL Servers via config files.

For example:
Web1 --> SQL001
Web2 --> SQL002
Web3 --> SQL003

Load balancer distributes HTTP requests accross the web servers

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-28 : 15:00:39

We only ever load balance the web and app servers. We purchase database server hardware that is adequate or better for the application's needs. We have an 800GB database that has a performance requirement of 300ms or less for 99% of the queries and haven't needed to setup any "load balancing".

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-12-28 : 15:31:03

all of your web servers point to same database server(s) ?

in our case, multiple apps read from same databases, thus the replication. though we have far more horsepower in sql servers (hardware-wise) than we need for the next year or so -- a nice luxury

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-28 : 15:36:12

Well we have many database servers, but each application points to one database server. Some database servers are shared by a few applications. Each application can have many application or web servers.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-12-28 : 15:41:54

That pretty much sums up our situation too. Except that we have a couple apps that point to 2 db servers (read from one, write to the other)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources