Server Sizing - CPU & Memory Usage

Here's what I've got:

Dell PowerEdge SC1420 Xeon 3Ghz

1GB RAM (400MHz) 80GB C: drive (SATA, hardware mirroring) SBS 2003 Premium - not running MS Exchange - DHCP/DNS for 12 clients. - two print queues, both very lightly used - folder redirection of My Documents folders for 9 users

Here's what I'm asking it to do (outside of the O/S based stuff above): Host Store Ops database - 2 lanes, occassionally as many as 6 concurrent SO Manager sessions. Host HQ Database - HQ Server for 4 stores Connection Schedule: - Store A (on same machine), every 3 minutes - Store B, every 4 minutes - Store C, every 5 minutes - Store D, every 6 minutes HQ Client for local Store Ops DB Host private IM server - Wildfire (CPU usage rarely over 1%, memory usage 350MB (two processes, one as Administrator [300MB] and another as SYSTEM [50MB]).

Question: Should I budget for a dedicated HQ server next year?

Is >90% CPU usage normal for this scenario? I didn't think I was asking all that much of my hardware, but at times the response from the server is pretty slow.

CPU usage *really* spikes when the HQ Client connects to HQ server on the same machine.

I'd love to hear from anyone with similar usage and/or hardware.

Thanks, Tom

Reply to
Terrible Tom
Loading thread data ...

I have a similar spec server, similar requirements. i had to go up to 4GB of RAM before i got much of an improvement, SQL Server just seems to eat up as much RAM as it can get hold of! I also found that if i restarted the server it performed much better, so i have scheduled an event to restart it every morning at 6am so its up and ready for the days trading by the time we open our doors, its been much much better since..

Reply to
Philip Gass

Host Store Ops database - 2 lanes, occassionally as many as 6 concurrent SO Manager sessions. Host HQ Database - HQ Server for 4 stores Connection Schedule: - Store A (on same machine), every 3 minutes - Store B, every 4 minutes - Store C, every 5 minutes - Store D, every 6 minutes HQ Client for local Store Ops DB Host private IM server - Wildfire (CPU usage rarely over 1%, memory usage 350MB (two processes, one as Administrator [300MB] and another as SYSTEM [50MB]).

Question: Should I budget for a dedicated HQ server next year?

Is >90% CPU usage normal for this scenario? I didn't think I was asking all that much of my hardware, but at times the response from the server is pretty slow.

CPU usage *really* spikes when the HQ Client connects to HQ server on the same machine.

I'd love to hear from anyone with similar usage and/or hardware.

Thanks, Tom -- Stop fishing for e-mail

Reply to
CptSoft

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.