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

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
  • 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...
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Dell T5810 (and which processor) or Dell XPS 8910 Special Edition 6 119
Multiple monitors 4 54
Locked BIOS on HP laptop 9 41
Post Clonezilla image restore issue 6 25
Monitor input from a computer is usually nothing special.  In this instance it prevented anyone from using the computer.  This was a preconfiguration that didn't work.
Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

808 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