Hardware Requirements for SQL server DB Clustering

Hi,
I want to cluster my SQL server DB and just wondering what hardware (how
many systems, adapters, what will be installed on what etc) will be required
to do the same. We are planning to use Win2k3 "Server Cluster" service for
the same.
Where will SQL Server DB reside? What will be installed on Nodes?
Thanks in advance
Pankaj A. Chitriv
Its a pretty vague question with a lot of decisions to be made. You need at
least two servers with the same hardware. Each server should have at least 2
nic cards. You need to decide what type of shared storage you want. It can
range from a scsi drive array to a fiber channel SAN.
The database needs to reside on the shared storage. If you have only one
database you will be using and active/passive clustering model.
You can Google or search MS for SQL and clustering and come up with a slew
of reading. Check with your hardware vendor to work out the hardware details
and come up with something you want and can afford. We'll be here to help
along the way.
Hope it helps.........
dw
Don Wilwol
http://spaces.msn.com/members/wilwol/
"Pankaj" <pankajchitriv@.rediffmail.com(donotspam)> wrote in message
news:36FB2975-3CCB-4160-8503-DAD488F140E0@.microsoft.com...
> Hi,
> I want to cluster my SQL server DB and just wondering what hardware (how
> many systems, adapters, what will be installed on what etc) will be
> required
> to do the same. We are planning to use Win2k3 "Server Cluster" service for
> the same.
> Where will SQL Server DB reside? What will be installed on Nodes?
> Thanks in advance
> Pankaj A. Chitriv
>
|||Pankaj,
I've got more information for you. I'm most familiar with
COMPAQ/HP cluster implementations, so I'll suggest
something from their product line that will give you an
idea as to what hardware is needed. There is something
called a "packaged cluster", which contains what you need
(a baseline config only. There are many options to consider)
Just google for "DL380 packaged cluster" and hit the first link
that comes up. (today, anyway) It should
Now, for more in-depth "how-to-do-it" information, I will
suggest that you get a book called
"Sql server 2000 Black Book" by Coriolis.
This book explains in great detail what needs to be done to
get clustered SQL working. Only about 40 pages of it is
for clustering, but I still think that it is the best
printed resource.
Costs about 60 bucks but worth it, since you are about to spend 40K or more...
Good Luck!
jg

Quote:

Originally posted by Pankaj
Hi,
I want to cluster my SQL server DB and just wondering what hardware (how
many systems, adapters, what will be installed on what etc) will be required
to do the same. We are planning to use Win2k3 "Server Cluster" service for
the same.
Where will SQL Server DB reside? What will be installed on Nodes?
Thanks in advance
Pankaj A. Chitriv

|||Thanks a lot Don.
"Don Wilwol" wrote:

> Its a pretty vague question with a lot of decisions to be made. You need at
> least two servers with the same hardware. Each server should have at least 2
> nic cards. You need to decide what type of shared storage you want. It can
> range from a scsi drive array to a fiber channel SAN.
> The database needs to reside on the shared storage. If you have only one
> database you will be using and active/passive clustering model.
> You can Google or search MS for SQL and clustering and come up with a slew
> of reading. Check with your hardware vendor to work out the hardware details
> and come up with something you want and can afford. We'll be here to help
> along the way.
> --
> Hope it helps.........
> dw
> Don Wilwol
> http://spaces.msn.com/members/wilwol/
>
> "Pankaj" <pankajchitriv@.rediffmail.com(donotspam)> wrote in message
> news:36FB2975-3CCB-4160-8503-DAD488F140E0@.microsoft.com...
>
>