Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Hardware Requirements for SQL server DB Clustering

 
   Database Help (Home) -> Clustering RSS
Next:  Irregular shape as Buttons  
Author Message
Pankaj

External


Since: Feb 10, 2005
Posts: 10



(Msg. 1) Posted: Fri Feb 11, 2005 11:49 am
Post subject: Hardware Requirements for SQL server DB Clustering
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

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

 >> Stay informed about: Hardware Requirements for SQL server DB Clustering 
Back to top
Login to vote
Don Wilwol

External


Since: Feb 10, 2005
Posts: 2



(Msg. 2) Posted: Fri Feb 11, 2005 2:40 pm
Post subject: Re: Hardware Requirements for SQL server DB Clustering [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
<a rel="nofollow" style='text-decoration: none;' href="http://spaces.msn.com/members/wilwol/" target="_blank">http://spaces.msn.com/members/wilwol/</a>


"Pankaj" wrote in message

 > 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
 >
 >

 >> Stay informed about: Hardware Requirements for SQL server DB Clustering 
Back to top
Login to vote
Pankaj

External


Since: Feb 10, 2005
Posts: 10



(Msg. 3) Posted: Mon Feb 21, 2005 11:43 am
Post subject: Re: Hardware Requirements for SQL server DB Clustering [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://spaces.msn.com/members/wilwol/</font" target="_blank">http://spaces.msn.com/members/wilwol/</font</a>>
 >
 >


  > > 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
  > >
  > >
 >
 >
 >
 >> Stay informed about: Hardware Requirements for SQL server DB Clustering 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQL Clustering Options - I have read that SQL Server with MSCS supports an Active/Active setup via a NAS, however, DOES NOT support and Active/Active setup via a SAN. Can anyone shed light on this? Any support documentation that would help would be great! Thank you.

3/4 Node Clustering - Hi, We plan to install/setup 3-4 node SQL Clustering using Windows 2003 (Enterprise Edition)/SQL2000 (Enterprise Edition) on SAN (EMC) we plan to initially setup/install clustering using two servers (S1& S2) as an ACTIVE/PASSIVE and then later ad...

4 Queries about DB clustering - Hi, Below are few queries: 1. Say for 2 nodes cluster, Do we need to have 2 copies of Databases( 1 on each node) 2. Hows does the data Synchronization between different nodes of databases takes place? 3. In Active/Passive mode, does the passive node...

setup SQL2005 clustering walkthrought? - Hi, Is there a detailed walkthrought on how to setup SQL2005 with ms clustering? The SAN storage already available to both nodes. Prefer a video. Thanks!

Changing SubNet Mask in Virtual SQL server - Hi, Due to re-engineering of our Network infrastructure, we need to change the SubNet Mask Properties in the SQL Virtual IP resource. We are using SQL 7.0 clustered on 2 Active & Passive nodes. The SubNet masks and Gateway of the 2 nodes also req...
   Database Help (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]