advise for setting up new sql db for SAP ERP

hello,
I need to get a decent hardware spec going for 20 and 40 users for SAP
ERP system.

http://www.microsoft.com/sql/editions/standard/sysreqs.mspx

I've been to the microsoft sysreqs website for sql standard but this
doesn't really help me.
I know those RAM requirements are way too low for that system to run
well.

What is a good amount of RAM and CPU for a box running win2k3 and sql
2005 standard for 20 and for 40 users?

I'm guessing maxing out 4gb of ram for the 32bit sql server. That
should work for 20 or 40 users. I just want to be sure!

For example, a win2k3 box running terminal server for 20 users needs
4gb of ram to work properly. I can find clear specs stating how much
additional ram per user I need to have.
I can't find this for sql server. Maybe I'm having a bad day...

Thanks,

Oskar

Hello Oskar,

There is no a specific amount to determine RAM or CPU or any other
resources. Because every workload is different. So, it depends on the
workload, not on the user count.

For example, you may have 100 users but if those 100 users querying against
your SQL Server rarely and your database is relatively small then you
probably will not need much resource. And in another example, you you may
have 40 users but those users may be working intensively against your SQL
Server and you may have huge OLTP and OLAP databases then you probably will
need more resource than a 100 users scenario.

Also, you do not stuck with only 4GB of memory when you have a 32Bit system.
If your Windows and SQL Server editions are high enough, then you can add
more RAM to your box and take benefit of it using /PAE, /3GB and AWE
options.

--
Ekrem Önsoy


"pheonix1t@gmail.com" wrote:

> hello,
> I need to get a decent hardware spec going for 20 and 40 users for SAP
> ERP system.
>
> http://www.microsoft.com/sql/editions/standard/sysreqs.mspx
>
> I've been to the microsoft sysreqs website for sql standard but this
> doesn't really help me.
> I know those RAM requirements are way too low for that system to run
> well.
>
> What is a good amount of RAM and CPU for a box running win2k3 and sql
> 2005 standard for 20 and for 40 users?
>
> I'm guessing maxing out 4gb of ram for the 32bit sql server. That
> should work for 20 or 40 users. I just want to be sure!
>
> For example, a win2k3 box running terminal server for 20 users needs
> 4gb of ram to work properly. I can find clear specs stating how much
> additional ram per user I need to have.
> I can't find this for sql server. Maybe I'm having a bad day...
>
> Thanks,
>
> Oskar
>