Does a SQL Server cluster support load balancing?

          

Interview questions

SQL Server - Does a SQL Server cluster support load balancing?

Next>>         SQL Server tutorial  

SQL Server - Does a SQL Server cluster support load balancing? - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

Does a SQL Server cluster support load balancing? Explain

SQL Server cluster does not natively support load balancing. Cluster has only one purpose and that is of boosting fault tolerance of the database. When a cluster fails, instance of SQL Server running on the failed server is simply moved to another server which then catches up with the load.

SQL Server - Does a SQL Server cluster support load balancing? - May 05, 2009 at 22:00 PM by Rajmeet Ghai

Does a SQL Server cluster support load balancing? Explain

SQL server cluster does not support load balancing. In clustering, fault tolerance of a server is increased. When this cluster fails, another instance of this server takes over.

SQL Server - Does a SQL Server cluster support load balancing? - June 21, 2009 at 09:00 AM by Amit Satpute

No. SQL Server doesn’t support load balancing.

Clustering is used to boost fault tolerance.
When a cluster fails over, the SQL Server instance running on the failed server is shifted to another server.
If the other server has an instance running on it, it will now have two instances running.


Next>>

Also read

What are the ways to code efficient transactions?

Answer - Database users can have permission to execute a stored procedure without being....

What are the differences among batches, stored procedures, and triggers?

Answer - A batch is a group of one or more SQL statements. SQL Server compiles the statements......

What security features are available for stored procedures?

Answer - Database users can have permission to execute a stored procedure without being......

What is the effect of DBCC CHECKDB and DBCC DBREINDEX on the Transaction log?

DBCC DBREINDEX is an offline operation is used to rebuild the indexes of a table dynamically.............

How to alter a user-defined data type?

The only way to alter a User Defined Data Type is to drop the existing and create a new one..........



Write your comment - Share Knowledge and Experience


 

 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring