Solved

Windows 2000 Adv Server Cluster Vs SQL 2000 Enterprise Server cluster

Posted on 2002-03-13
3
236 Views
Last Modified: 2013-11-15
Hi,
  I need to implement cluster feature for my server, current configuration is as follow
Processor: Dual processor Pentium 1.13Ghz
Memory : 1G
Storage: 70G
Configuration: 2U server.
  Partition C: OS -> 4G
  Partition D: Data -> remaining
  Application is has already been installed
  OS: windows 2000 server
  Database engine: SQL 2000 std edition.

  If I need to have cluster feature. Is this configuration
 go enough? Do I need to have Windows 2000 Advance server & SQL 2000 Enterprise edition for it to work?
   Please advise
   Thanks in advance.
   CT2000
0
Comment
Question by:CT2000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 25

Accepted Solution

by:
dew_associates earned 200 total points
ID: 6863649
Hi CT,

The issue isn't necessarily just whether or not your current hardware configuration is "good enough". There are other issues as well. You don't mention whether you are building a server cluster or implementing the Windows Cluster Service, therefore under the circumstances I will presume you're just implementing the service.

I'd suggest that before you go any further you read the following documentation:

Microsoft Cluster Service Installation Resources

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q259267

You may also want to review these to see which applies to your configuration and setup.

http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=msall&Query=%2522clustering%2520requirements%2522&Queryc=%22clustering+requirements%22&REF=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=25

Be careful of URL wrapping!

Dennis
0
 
LVL 5

Expert Comment

by:matt023
ID: 6866949
There are different ways of clutering - ie: MSCS, parallel processing and load balancing.  the cheapest is to use MS load balancing, however, it's not a good software from my experience.  MS doesn't support parallel processing - Unix related OS's do -- so do Oracle and some other vendors.  MSCS is better, however, the basic harwares that you'll need in order to implement an MSCS solution are:  at leat 2 servers and a shared storage.  there are steps and strict procedures in implementing a cluster solution.  Follow Dennis' advice and get familiar with clustering.
0
 
LVL 4

Expert Comment

by:TheSpirit
ID: 7791186
If you want to use MSCS you would need 2 servers with some kind of shared disk, you would also need to be running Windows 2000 Advanced Server and SQL2000 Enterprise edition. The hardware should also be on the HCL as a solution, it is not enough that each component is on the HCL
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question