Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

True Load-Balancing Using SQL Server 2008. Expand / Collapse
Author
Message
Posted Tuesday, July 27, 2010 8:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 29, 2012 9:19 AM
Points: 136, Visits: 51
Hello All:
This is a question that has been baffling me for quite some time. Can SQL Server act as in a Load-balancing mode for better performance instead of the typical fail-over mode with SQL Server 2008? The infrastructure team in our company are pushing for implementing SQL Server 2008 in Load-Balancing mode. I am not sure if SQL Server works in this mode in real mode.

Thanks in Advance,
Regards,
Mangesh.



Post #959427
Posted Tuesday, July 27, 2010 8:52 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:11 PM
Points: 3,081, Visits: 11,230
SQL Server 2008 has no true load balancing, meaning having multiple database servers actively updating the same database.

There are possible ways to off load specific tasks to other servers. For example, replicate data to another server, and run reporting on that server.




Post #959445
Posted Tuesday, July 27, 2010 8:55 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 6:26 AM
Points: 419, Visits: 722
The reason for this limitation is because no two instances of SQL Server can reference the same data files at the same time.

--J
Post #959449
Posted Tuesday, July 27, 2010 9:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 29, 2012 9:19 AM
Points: 136, Visits: 51
Thank you so much both for the replies. I just wanted to clear the myth that is making the rounds that Load-balancing is possible with SQL Server 2008.


Post #959476
Posted Tuesday, July 27, 2010 9:19 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:07 AM
Points: 22,507, Visits: 30,223
Just to play devils advocate, but wouldn't using Peer to Peer replication allow one to develop a solution that could provide a form of load balancing? I've never used Peer to Peer replication, so I would think someone with more knowledge of this technology would be better suited to answering the question.


Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #959484
Posted Tuesday, July 27, 2010 9:27 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:11 PM
Points: 3,081, Visits: 11,230
mangeshv (7/27/2010)
Thank you so much both for the replies. I just wanted to clear the myth that is making the rounds that Load-balancing is possible with SQL Server 2008.


Load-balancing can mean a lot of things, so you could just ask the people that are pushing for it what they actually mean.

It could be that they just don't know what they are talking about, but they may have something specific in mind.

For example, it is possible for multiple servers to share a read-only database by having multiple servers mount the same SAN volume, but this is probably only useful in a limited, data mart application to spread a heavy reporting workload over multiple servers.


Post #959494
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse