Appropriate RAM size for HP Netserver LC2000

Posted on 2001-06-14
Last Modified: 2013-11-10
A HP Netserver LC2000 with the following specifications :
- PentiumIII processor and
- 128 MB RAM

is running Windows 2000 Server and SQL Server 2000.

May I know that whether 128 MB RAM is able (or appropriate) to work efficiency and effectively under this environment or not? If not, please give comments.
Question by:HuiLin
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
  • 2
  • 2
  • 2
  • +3
LVL 44

Expert Comment

ID: 6193928
I would guess that has a lot to do with what these machines are going to be doing and how much of a load is going to be put on them. For testing puposes you could use the task manager to see how much is being used at any given time to get an idea of what is happening to the memory load.
LVL 11

Expert Comment

ID: 6193972
Let's put it this way, you can have three buses, and call yourself a bus company, and have one secretary run the whole operation, then there's Greyhound, it's still a bus company, but has thousands of buses.............. the key here is volume, how much data, how many users, how fast a network. If your database is Gigabytes large, then after about 256Mb improvements will be marginal with increasing memory size until you approach a sizable fraction of the size of the database. If it is  a couple of hundred megabytes, then allow that 128 you have for the OS, and add as much as will cache the database in RAM and get really zippy performance...... until your user count goes high, or you hit the limitations of your current network..... or your management comes up with half a dozen spiffy new applications you just have to install......
LVL 32

Expert Comment

ID: 6194728
It's impossible to say what is the right amount of memory since you've said virtually nothing about what your system is doing.

I will say that 128MB is probably really low!  W2K Server by itself should have 256MB or more for reasonable operation unless you are just playing around with it.

SQL Server memory requirements can run from modest to EXTREME.  It would not be unusual to see an SQL Server machine with 1G or more of RAM.  It just depends on the application, the load characteristics, and database size.

So my bottom line is 128MB is NOT ENOUGH for any useful W2K Server/SQL Server situation.  I'd consider 256MB to be the ABSOLUTE MINIMUM for a real server.  What you really need, however, will take some analysis to determine.

Of course you can just keep thowing more RAM at the system until the performance falls into line with your expectations...
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.

LVL 13

Expert Comment

ID: 6195049
"So my bottom line is 128MB is NOT ENOUGH for any useful W2K Server/SQL"

No kidding! Microsoft's SQL is a complete hog for memory.  Its cleanup routines are nonexistant.  SQL handles Win2K's roaming profile data and I've seen a 200 workstation lab use up 700MB on the server just in the SQL profile database.  Completely absurd.  Consider MySQL as a replacement.
LVL 32

Expert Comment

ID: 6195095
Why are you yelling at _ME_ about this?  I didn't make this product, nor do I defend it!  

You'll get no  argument from me that SQL is a major resource hog.  

That doesn't change the fact that people buy and use it.
LVL 13

Expert Comment

ID: 6196327
When am I yelling at you? Doesn't 'no kidding' == 'this person is not joking'  ?

Expert Comment

ID: 6196680
Settle down Beavis.

I think you guys are all right. A decent Win2K server should have 256MB to run just the OS. Without more data about how the server is used we can all only guess how much more you may need. Then again, with the low price of RAM these days, its pretty hard to hurt yourself by buying too much.

Expert Comment

ID: 6283835
Hi all,

This question has been open for awhile. I am going to allow feedback from the questioner and experts. If it is not resolved, I will delete or accept an answer based on the info I have been given. Experts, feel free to offer input. I will monitor this question for a period of 5-7 days and come back and evaluate the situation.

If an Expert has helped, please accept with the answer button.

If returned to I will leave open for discussion.

Please do NOT accept this notice as answer.

Thank you,
Community Support Moderator

Accepted Solution

ComTech earned 0 total points
ID: 6324445
With HuiLin not responding this question will move to PAQ, and will deduct the points.

Community Support Moderator

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Retrieval of photos from ipad after hardware reset 12 93
canon pixma mg2922 printer scan 10 66
IIS on Server 2012 R2 Datacenter 5 84
benchmarks for comparing CPU head to head.. 13 92
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
What do we know about Legacy Video Conferencing? - Full IT support needed! - Complicated systems at outrageous prices! - Intense training required! Highfive believes we need to embrace a new alternative.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question ( here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

749 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