Sage 100

I am looking for a ""real world"" answer to how much RAM should a 2008 R2 Server have that is running SAGE 100 adv with 20 users. I am not as interested in the Sage configuration as in what a MAS200 database of 15GB and 20users would need for optimal performance.

I have a client running at a similar level and they have 8 GB on the server. They have about 12 GB of data and 20-25 users. I'd like to see them go to 12 GB. There are occasional issues that more RAM would correct.

If you ask 20 people that question, you will get 10 different answers based on client experiences. I know you're looking for a straightforward answer but in the end the final real world answer for amount of RAM and processor to decide on always depends on a bunch more factors than just number of users and size of data, such as frequency and number of integrated external apps, imports, exports, and reporting that is occurring at same time regular MAS stuff is happening. Also how the AV is configured, how the RAID array(s) is arranged. Also 6 months to a year from now what is the projected size of data, number of users, what new apps will be in place (e.g. a WMS) and what is overall growth of the company. In the end, the short answer from me personally is a minimum of 8GB of RAM (higher depending on answers to above) but know that processor power and number of processors/cores is critically important too, and should be brought up in the same conversation as the one for increasing RAM. One advantage of being in a virtualized environment is the host system can allocate more processor and RAM to the guest o/s that's running MAS 200. Hope that helps. If it confused or muddied the waters, I'm sorry.

I would extend Alnoor's comments just a bit. RAM is pretty cheap, and it's definitely cheaper when the server is fairly new than a year or two later when a particular RAM chip might not be available. Virtualization, especially with W1012, is very, very attractive. So, I recommend that a new server always be viewed as really supporting at least 3 vm's. (Your MAS 200 server would then be one of them.) So, 16 GB or better, and high-speed processors will extend the hardware's useful life by at least 2 yrs, while also doing the work of 3 boxes.

Thanks to all three for great answers. I think the main attribute I see is min 8GB with flexibility to add as needed. @AlnoorCassim your answer was in-depth and I find it most helpful.

Your welcome!