Solved

Windows 2000 Adv Server Cluster Vs SQL 2000 Enterprise Server cluster

Posted on 2002-03-13
3
228 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
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Acronis True Image is Reporting a Bad Sector! 12 260
Tape Management 8 110
Screen Mirroring 7 77
data center consolidation 8 106
How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

831 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