Re: Transition from Stand-ALone SQL Server to Cluster

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 01/23/05 

Date: Sun, 23 Jan 2005 01:21:39 +0100

Hi

A Cluster is for high availability and not load balancing a single instance.
If you can put one DB on each node, you have a solution. If they have to run
on the same node, it won't help performance.

Make sure your hardware is on the Windows HCL for clustering, otherwise you
will just have a lot of trouble.

http://www.microsoft.com/windowsserver2003/technologies/clustering/default.mspx

http://www.microsoft.com/sql/evaluation/features/reliable.asp

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"dark_15" <dark_15@discussions.microsoft.com> wrote in message
news:297A4A6B-2D86-4C52-85E1-B8660B32E9FF@microsoft.com...
> Hello Everyone,
>
> Here is my situation:
> I have stand alone sql server 2000 and with 2 databases. Unfortunately
> that server, which was supposed to be able to handle the workload of both
> database and database apps, is not able to do so. So I am looking into
> setting up something to distribute the workload between more servers. I
have
> two other servers coming along my way, as well as a SAN system for the
> storage of the SQL Data.
> So I am wondering if SQL clustering would be useful in this situation and,
> if so, what would I be looking at in configuring these servers? Right
now, I
> am just in the designing and planning stage, so I can change hardware and
> storage design if necessary.
>
> Thank you for your time.

Relevant Pages

  • Re: SQL 2005 servers with multiple instances
    ... Have you checked out the latest possible hardware configurations for SQL ... I have built two-node clusters with dual-proc dual core brand name servers ... Clustering is no ... controller is being shared for the Live data and the Redundant data/logs. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2000 Enterprise
    ... You can't have a DB on two servers at the same time. ... SQL 2000 Clustering was ... MVP - Windows Server - Clustering ... > I would like to setup SQL Enterprise in a 2 node cluser ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL serrer 2005 failover clustering issues
    ... In clustering, the network name is part of the group and is the same no matter which physical host is running the SQL instance. ... We have set up failover clustering for our production servers. ... We are experiencing connection time out. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Want to load balance and cluster 3 SQL 2005 servers
    ... So how could I load balance the servers? ... SQL instance is the right approach. ... Clustering nodes, ... I'm guessing I need to set up Network Load Balancing in order to load ...
    (microsoft.public.windows.server.clustering)
  • Transition from Stand-ALone SQL Server to Cluster
    ... I have stand alone sql server 2000 and with 2 databases. ... database and database apps, is not able to do so. ... setting up something to distribute the workload between more servers. ... storage design if necessary. ...
    (microsoft.public.sqlserver.clustering)