Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

PC/System Configuration for small SQL App

Posted on 2014-01-03
8
Medium Priority
?
384 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:
David earned 2000 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
New Tabletop Appliances Blow Competitors Away!

WatchGuard’s new T15, T35 and T55 tabletop UTMs provide the highest-performing security inspection in their class, allowing users at small offices, home offices and distributed enterprises to experience blazing-fast Internet speeds without sacrificing enterprise-grade security.

 
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

[Video] Create a Disruption-Free Workspace

Open offices have their challenges. And Sometimes, it's even hard to work at work. It's time to reclaim your office and create a disruption-free workspace. With the MB 660, you can:

-Increase Concentration
-Improve well-being
-Boost Productivity

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

New style of hardware planning for Microsoft Exchange server.
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

886 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