Re: Using sql server clustering

Clustering in SQL Server is a hardware failover technology only. There is no
load sharing of any kind and there are no performance benefits from running
SQL Server in a Windows cluster. The only thing a cluster will get you close
to is #3. But only 1 server at a time is active. You best bet is to optimize
your existing applications / database or to scale up with the hardware.
Another option may be to use replication but it sounds like you will need
Merge and that would not be my first choice.

--
Andrew J. Kelly SQL MVP

"Roy Goldhammer" <roy@xxxxxxxxxxx> wrote in message
news:%23t7HmyasHHA.1412@xxxxxxxxxxxxxxxxxxxxxxx
Hello there

I have huge sql server databese that works on single server right now.

To the database there are at least 6 applications that update the data and
use it.

as a result of that there are problems on performance.

I've heard that by using sql server clustering i can do 3 things that will
improve my performance:
1. setting 6 diffrent servers for each application and due to sql server
clustering(as i've been heard) the data is immidietly being update on each
other server
2. the clustering can assist the performance by getting to one application
data from more then one server
3. Recovery: this way if one server is down the other server fills its
action until the server is online again.

my question:
1. is all true that it can be achived on sql server clustering?
2. how can i start learing and using it?
3. what hardware i need to test it and to place at the client?



.

Relevant Pages

  • Re: Newb Active-Passive / Active-Active Single Instance Question
    ... The Disk space is SAN storage. ... node and one virtual server. ... cluster node as it is no longer like Windows Clustering is it that SQL 2005 ... Also, SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: Using sql server clustering
    ... Clustering will give that one high availability. ... other 4 can still handle the load while you fix the one that is down. ... add more server for incoming data wich is failover cluster. ... About the servers to pull data, can i use sql server clustering in order ...
    (microsoft.public.sqlserver.clustering)
  • Re: 4 Queries about DB clustering
    ... Server clustering is available on Windows Server 2003 Enterprise Edition. ... "Single Data Store" is not a service, ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: So exactly what IS clustering?
    ... I'd go with .server and .programming for this type of question. ... Edition of SQL Server. ... There's clustering and then there's clustering. ... So I've just run the index tuning wizard over ...
    (microsoft.public.sqlserver.clustering)
  • Re: Memory Allocation - Win2k3 SP1 and SQL Server 2K SP4
    ... Microsoft SQL Server MVP ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)