Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

PC/System Configuration for small SQL App

Posted on 2014-01-03
8
Medium Priority
?
383 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Build and deliver software with DevOps

A digital transformation requires faster time to market, shorter software development lifecycles, and the ability to adapt rapidly to changing customer demands. DevOps provides the solution.

Question has a verified solution.

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

Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

688 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