• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

Appropriate RAM size for HP Netserver LC2000

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
HuiLin
Asked:
HuiLin
  • 2
  • 2
  • 2
  • +3
1 Solution
 
CrazyOneCommented:
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
 
RoadWarriorCommented:
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
 
jhanceCommented:
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
Worried about phishing attacks?

90% of attacks start with a phish. It’s critical that IT admins and MSSPs have the right security in place to protect their end users from these phishing attacks. Check out our latest feature brief for tips and tricks to keep your employees off a hackers line!

 
magarityCommented:
"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
 
jhanceCommented:
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
 
magarityCommented:
When am I yelling at you? Doesn't 'no kidding' == 'this person is not joking'  ?
0
 
jjeff1Commented:
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
 
ComTechCommented:
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
 
ComTechCommented:
With HuiLin not responding this question will move to PAQ, and will deduct the points.

ComTech
Community Support Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Protect Your Employees from Wi-Fi Threats

As Wi-Fi growth and popularity continues to climb, not everyone understands the risks that come with connecting to public Wi-Fi or even offering Wi-Fi to employees, visitors and guests. Download the resource kit to make sure your safe wherever business takes you!

  • 2
  • 2
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now