Re: Using sql server clustering

Thankes Andrew

If what you are saying is true i need it only for recovery.

Do you have offical a documentation from microsoft about it?

secondly' i've seen some documentation about sql server clustering witch is
being used by windows clustering (as far as i know). but on the document
i've seen something about create virtual server.

what is this thing?

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:O1MU$KbsHHA.4612@xxxxxxxxxxxxxxxxxxxxxxx
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: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Best replication architecture?
    ... Looking for a SQL Server replication book? ... So if it is subscribing to Publisher 1, ...
    (microsoft.public.sqlserver.replication)