Re: SQL Load Balancing

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: RS (rspen_at_yahoo.com)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 08:53:51 -0600

Paul may correct me if I am wrong, but I don't think you can truly load
balance a SQL server on a cluster. The reason being is that each engine
must maintain complete control over the database files. You can however,
use replication to move data to another server for reporting purposes, and
that should remove a lot of the load off of the OLTP server. That is a
pseudo load balance.

Thanks,
RS
"Duke" <dburrell@fbfs.com> wrote in message
news:77fd01c402ba$2fecfed0$a501280a@phx.gbl...
> We are currently using SQL 2000 in an Active/Passive
> clustering mode and would like to explore the
> possibilities of load-balancing access to the database.
> Is Microsoft replication services within SQL adaquate
> maintaining the databases on the load-balanced nodes?
> has anyone had any experience with this scenerio?
>
> Thanks
> Duke
>

Relevant Pages

  • Re: N+1 Configuration
    ... Jasper Smith (SQL Server MVP) ... But looking in the cluster admin tool, ... mounting all other drives under that drive ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Question
    ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... Do you want to cluster SQL? ... > you cannot install Cluster on a Small Business Edition, ...
    (microsoft.public.windows.server.clustering)
  • Re: Clustering Question
    ... The SQL Cluster would need to be ... SQL will need to Enterprise as well. ... So if I understand you correctly one computer will need Windows Server ...
    (microsoft.public.windows.server.clustering)
  • Re: WVNETcluster uptime reaches 10 years...
    ... so a backup server takes over the personality of the primary server. ... Many servers in the cluster can each concurrently be hosting many writes, each to one portion of the overall file resource. ... and that hosting load can be ... fail-over which means you either have a pile of HW sitting at the ...
    (comp.os.vms)
  • Re: Issues creating a new failover cluster on the same server
    ... G:\Microsoft SQL Server\MSSQL.1 ... CHNSQL04 Cluster Group ... Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running ...
    (microsoft.public.sqlserver.clustering)