Solved

Appropriate RAM size for HP Netserver LC2000

Posted on 2001-06-14
9
232 Views
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.
0
Comment
Question by:HuiLin
[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
  • 2
  • 2
  • 2
  • +3
9 Comments
 
LVL 44

Expert Comment

by:CrazyOne
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.
0
 
LVL 11

Expert Comment

by:RoadWarrior
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......
0
 
LVL 32

Expert Comment

by:jhance
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...
0
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

by:magarity
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.
0
 
LVL 32

Expert Comment

by:jhance
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.
0
 
LVL 13

Expert Comment

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

Expert Comment

by:jjeff1
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.
0
 

Expert Comment

by:ComTech
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,
ComTech
Community Support Moderator
0
 

Accepted Solution

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

ComTech
Community Support Moderator
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Does your iMac really need a hardware upgrade? Will upgrading RAM speed-up your computer? If yes, then how can you proceed? Upgrading RAM in your iMac is not as simple as it may seem. This article will help you in getting and installing right RA…
pc, laptop  monitor connection configurations
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

705 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