Solved

PC/System Configuration for small SQL App

Posted on 2014-01-03
  • Windows 7
  • C#
  • Programming
  • Hardware
  • Desktops_PCs
  • +1
8
372 Views
Last Modified: 2016-11-23
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
2 1TB,SATA,3.5",7200,32M
 
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
1 RAID,CNTRL,INTEL,PAYG,A,T3600
0
Comment
Question by:Tony Giangreco
8 Comments
 
LVL 2

Expert Comment

by:kerick
ID: 39755338
What database engine are you using and does it use all the ram you give it?
Ram is a cheap upgrade to the system you quoted.
0
 
LVL 25

Author Comment

by:Tony Giangreco
ID: 39767382
We plan to use Sql express. I understand ram is cheap but Sql express on uses 1 Gig so at this point, there is no need for more ram.
0
 
LVL 47

Accepted Solution

by:
dlethe earned 500 total points
ID: 39770922
RAID0 is nuts.  Go RAID1.  This not only improves I/O by doubling read performance, but it protects against data loss.  

DO NOT USE the embedded intel RAID chip. This does not do read load balancing.  There is no performance benefit like using the native windows software RAID.   Just disable the fakeraid, and set the controller to AHCI and let the O/S do the RAID.

As for the rest, you are throwing away a great deal of money with a quad processor.  Go dual and use the delta for RAM and/or higher quality disks.  (Make sure those disks are true enterprise class drives designed for 24x7x365, and not cheap desktop drives).
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 32

Expert Comment

by:_
ID: 39771659
ditto dlethe
0
 
LVL 18

Expert Comment

by:Gary Davis
ID: 39773818
Also, look into a hosted solution for the database so they don't have the issues with maintaining a server. Perhaps a sql azure solution (database in the cloud) or some hosting ISP.
0
 
LVL 25

Author Comment

by:Tony Giangreco
ID: 39773834
There is no budget right now for a hosted solution. I will explore the other solutions.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Suggested Solutions

In the modern office, employees tend to move around the workplace a lot more freely. Conferences, collaborative groups, flexible seating and working from home require a new level of mobility. Technology has not only changed the behavior and the expe…
This paper addresses the security of Sennheiser DECT Contact Center and Office (CC&O) headsets. It describes the DECT security chain comprised of “Pairing”, “Per Call Authentication” and “Encryption”, which are all part of the standard DECT protocol.
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now