Post reply

Does SQL Server 2008 provides Load Balance Cluster

  • March 21, 2012 at 1:25 am

    #258095

    Hi,

    Does SQL Server 2008 or R2 provides Load Balance Cluster?

    I knew this supports only "Fail Over Cluster"..

    Thanks.

  • March 21, 2012 at 1:59 am

    #1462038

    no, its only a fail over cluster for the database engine, you can load balance SSRS but that is done via stand alone nodes using scaled out deployment, SSRS and SSIS are not cluster aware

  • March 21, 2012 at 2:09 am

    #1462039

    Thanks Anthony.

    However, found one MS post technet article (http://msdn.microsoft.com/en-us/library/ms151196.aspx), which says through P2P Replication we can implement the similar feature..

    Is this meaningful?

    Regards.

    Thanks.

  • March 21, 2012 at 2:14 am

    #1462040

    its not true load balancing, you can spread out the reads but you cant spread out the writes.

  • March 26, 2012 at 3:56 am

    #1464130

    you cant spread out the writes

    Not strictly true. You can spread out the writes:

    1 By very careful setup and operation of P2P. You need to assign ranges of identity values to each node, and make totally sure you do not run out of values on a given node. If this sounds a bit risky then you may have underestimated the problem.

    2 By custom application design so that you include the node name or Id number as part of every primary key. This avoids the risk of identity range clashes. As this sounds, it can be very costly to implement.

    By far the simplest and most reliable and least risky way to manage P2P is to sent all writes to a designated server. It is best to have a vanity DNS name to identify the master write server, and a site standard that says you must connect using the vanity name if you want to write. In this way you avoid the risk of conflicting updates, and can quickly change which server you write to by re-pointing the vanity name. But as already pointed out this does not give you load balancing of the writes.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply