Solved

Appropriate RAM size for HP Netserver LC2000

Posted on 2001-06-14
9
222 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
  • 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
 
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Is it worth it to buy an Echo? In a word, yes! For me it was definitely worth it. I use mine on a daily basis. Prologue & Privacy At first, I was very skeptical about the Amazon Echo. In general, I don't like voice assistants. I don't li…
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.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

746 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now