PC/System Configuration for small SQL App
Posted on 2014-01-03
We are a few weeks away from designing an application written in c# in Visual Studio 2013. The client who will use the application, only has ten office employees and we see no growth in additional office employees in the next few years.
The application is intended to track work order for maintenance in a small housing association where work orders are created, updated closed and tracked for management reporting.
They don't have a budget or onsite personnel to maintain a server and they have always run a peer to peer network. We are not ready to create a cloud based app. we need to start with a localized server app for now. They want a custom application that works just like their paper process as run for 50 years.
My question is, if we add a dedicated Win7 Pc (peer to peer) running the database for the c# app, what specs should I look for in the Pc to support Win7, the database, and communication with the app running on 10 peer to peer Pc's in the network?
Here are the components we have started looking at in a Dell Pc.
1 Dell Precision T3600,MT,425W
1 Four Core XEON E5-1603, 2.8GHz, 10M
1 8GB DDR3 UDIMM 1600,NECC,4x2GB
1 Nvidia NVS 310, 512MB, 2 DP, dual monitor
Raid 0 - Mirror
1 Windows 7 Professional,No Media, 64-bit,Fixed Precision
1 Integrated Intel controller, SATA 3Gb/s RAID 0/1/5/10 (4 ports)
1 16X DVD+/-RW and 8X DVD
1 Precision T3600,425W 90 Percent Efficiency Power Supply