Re: Using sql server clustering

You need to use some sort of load balancing for the web servers that spreads
the load across all of them. Most of these tools have the ability to
temporarily disregard a server that it can not communicate with or you can
manually take it out of the pool. Sorry but that part is outside of my area
of expertise and is more of a windows or networking question.

--
Andrew J. Kelly SQL MVP

"Roy Goldhammer" <roy@xxxxxxxxxxx> wrote in message
news:ey$bOOwtHHA.3588@xxxxxxxxxxxxxxxxxxxxxxx
I'm agree with you andrew

My question about the 5th read servers. What is the simplest way to make
sure that if one of them is falling down the application that use it will
start using one of other 4 servers?

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:u0OEa8ntHHA.768@xxxxxxxxxxxxxxxxxxxxxxx
You can cluster any one or all of them if you are worried about any of
them going down. But the mainone (the one that you load data on) is
probably the most likely candidate. Clustering will give that one high
availability. As for the ones that are used to read from I personally
wouldn't bother with clustering them. I would add a 5th read server so
that if one fails the other 4 can still handle the load while you fix the
one that is down. This is much cheaper than clustering all 4 and a LOT
easier to manage.

--
Andrew J. Kelly SQL MVP

"Roy Goldhammer" <roy@xxxxxxxxxxx> wrote in message
news:O9lTYujtHHA.4440@xxxxxxxxxxxxxxxxxxxxxxx
WHell Andrew

I got more information about the system i should manage:

for the 6 applications that uses the same data
there is only one application that only load data from sources and there
are 5 applicaions that just showing the data.

So it seems that i need replication for that. and not merge but
transactioal replication but this is not for this forum.

my question is: it seems that in order to make the system better i
should add more server for incoming data wich is failover cluster.

About the servers to pull data, can i use sql server clustering in order
to make that if one of the 5 is fallen down anoter server use it?

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:OR4ZBscsHHA.4572@xxxxxxxxxxxxxxxxxxxxxxx
Wow, you are really starting at the bottom:). I suggest you start here
to get an idea of what options are available to SQL Server in terms of
HA.

http://www.microsoft.com/sql/technologies/highavailability/default.mspx


--
Andrew J. Kelly SQL MVP

"Roy Goldhammer" <roy@xxxxxxxxxxx> wrote in message
news:umBRnjbsHHA.1184@xxxxxxxxxxxxxxxxxxxxxxx
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: 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)