Discussion Locked

Win2000/SQL 200 minimun requirements

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am looking for any serious benchmarks or references that show minimum real-time requirements for a Windows 2000 Server running standard MSSQL 2000. Specifically, I would like to see threshholds of RAM and DISK requirements as a database grows at a standard 10%. At what point should I upgrade either or both? Of course, I could keep adding RAM and DISK space regardles of requirements. But, I've read that there is performance degradation by adding too much RAM or too much DISK. However, I need to know the bottom baseline when it is time to upgrade. Being a little bit more negative, how much RAM/DISK space do I need before either Win2K or SQL2000 becomes unstable? how much is too much?
Please, Do not submit "Installation requirements"
Thanks.

1 reply

by masteraaron

The first thing off is what type of program will you use for database. We use a program called Made 2 Manage and we use a Compaq DL580 with 2 1meg 700 xeon processors, and 1 gig of ram. We plan to upgrade the box this month. Two more Xeon Processorsand 2 gig of ram. The reason is we will need the extra processor power for sister company that will be using this program through a terminal services connection. The size of the database is relative to the amount of information the you will have entered into the database. How much at day. This comes with a siff price of course 18,000 for the server alone. We have about 100 gig of space, and raid 10 running, on 14 drives. What you need and want are dependant on what you are doing with the server.

This discussion is closed to new replies.