Well, if the server only needs to support 12 users it does not need to be powerful by server standards. A simple single socket budget quad solution should be enough for you daily usage. However, this all depends on the amount of users using the server at the same time and whether you plan to increase the workload over a longer period of time. If your requirements remain roughly static a single slot solution should be enough for you. However if the business is a growing one you might want to invest in a motherboard with more sockets for future expansion.
Also, you might want to consider alternative server options that may be cheaper to run for small business such as a server mac mini which is inexpensive for the reliablilty and security of such a SMB platform.
Just a few questions:
Just answering you questions, based on your current workload a single quad-core should be enough for your organization. Trust me, it will blow your Pentium 4 out of the water.
SAS disks will require a bigger investment but the motherboard will allow for drive hot swapping. FOr your business size, I recommend SATA drives, they are cheaper to buy and putting two into mirrored RAID should guarantee reliability. Try to stick to Hard Drives with long warranties, like the Caviar Black series.
I'm guessing your mail and fileserver useage are relatively low?
otherwise this isnt an ideal combination combined with an SQL server.
any modern single quad processor box will run rings around the current server.
I'd go for 8gb ram and a 64bit os if possible.
For storage I'm not sure what you are calling raid 2?
do you mean read 1-- drive mirroring?
the standard would be something like a single drive for os, and a 3-4 drive raid 5 array.. that is backed up nightly.
You could also consider one of the new enterprise class SSD's if they are big enough to meet your needs.
also theoretically the only thing you would want on the raid array would be the SQL database,
but this might also be overkill in your application.
It would depend on what type/size of files you were transferring with the file server
Its hard to recommend something as I dont know the workload or business you are in..
something with marketing would obiviously be very different than say.. engineering.
Thanks for the advice so far.
You are right I meant to say RAID 5 or RAID 1.
Yes, the file and mail usage is low -- office paper shuffling.
Backup via swapping external drives daily -- no problem with that.
Storage -- the photo and video archive has grown and is now held on a workstation. That works fine.
On the file server we need less than 250g now so less than 500g in the future. A NAS could be used for files in the future if required.
The mail server software is MDaemon which I'm happy with. Considering changing at some point to Exchange but I simply don't have time to do that now. MDaemon uses less resource than Exchange -- should that be a consideration?
The key factor is speeding up this SQL database which we use for contact relationship management.
I suppose we could even keep the old server running with the files and mail while we setup the new server with the database.
As for me, I'm the accidental techie around here and I call in IT techs when required. I've asked two office networking pros and have received different recommendations from each one.
Well, trust me, when you do upgrade to a single quad the performance difference will be massive. I think you won't need anything more than a single socket CPU. Perhaps a Xeon quad-core with Hyperthreading?
I'd aim to find a motherboard that supports e-sata. E-sata is the fastest consumer interface for swapping external hard drives. It's as fast as SAS, just without the extra cost.
I'd say that 2 or 4 1TB drives in RAID 1 would be the way to go regarding the amount of data you use.
If you are happy with the current software, why change?