For a server load that light you can use workstation hardware with onboard RAID for data redundancy. A major cost will be your Server OS license if you don't already have one to use. What do you think of something like the build below?
You have a handful of users so, in all reality, you could use 5400RPM drives and the user experience wouldn't be any different. Going with an SSD RAID would be VERY nice, but it isn't all that cost effective. The VelociRaptor setup above is a good option for speed and costs... If you want to use an SSD, I would go with the Corsair below as it would be faster than the Intel, cheaper and larger. For a 2TB, the Samsung F4 2TB is 5400RPM but its speeds rival 7200RPM units. Good drive all around...
...or maybe the best option is a RAID1 on a pair of Force 3 SSDs, then a pair of F4 2TB drives in RAID1 for storage. Plenty of good storage options out there and, as long as you use the drives talked about here, you should be fine with whatever you go with.
Sorry I should have clarified... we use the server as an SQL Server and as a Team Foundation Server, any delays in data fetch are a nightmare for us that's why I'm thinking SSD's would be a worthwhile investment.
I guess the trouble from there would be to find a good hardware company that could set the software up for us if we setup the hardware.
Neither the SSD or VeliciRaptor solutions would cause any latency with SQL.
How much storage do you actually need? Plan on install the OS, SQL and Team Foundation Server, and all other apps on the OS / Boot partition? ...making the 2TB drive simply for storage and backups? The reason I ask is for sizing. For an SSD to perform optimally, the general rule of thumb is to keep 50% free disk space. For the OS and all apps you may need to step up to a 180GB or 240GB.
The problem I see is that most desktop/mainstream motherboards do not support Windows Server OSs. What I did when building my test server was use a server motherboard that accepted mainstream components. A core build I'd probably consider today would be something like:
I don't see what the problem is. There are some mainstream motherboard that do support Server OSs, but they're difficult to find. Basically, check each board to see if it has driver support for your chosen OS.
The server motherboard I linked above, while more expensive, does use mainstream components and does support Windows Server. It's a MicroATX form factor, has PCI-E slots for RAID/Graphics, etc.
...and whoops! I forgot that I actually did find a mainstream motherboard for my test server build (see signature).
The problem I see is that most desktop/mainstream motherboards do not support Windows Server OSs.
I can tell you first hand that the ASUS board below is fine with Server 2008 R2. I would suspect the Sabertooth would be just fine also. Doing a quick Google search shows plenty of users running the Server OS on the Sabertooth X58 motherboard. Drivers seem to be readily available, but may have to go directly to Intel for an updated RAID controller...