Jump to content

Work Computer


Recommended Posts

I run a PC at work with SQL 2005 to provide company wide reporting. It is a P4 3.8GHz single core processor with 4x1GB of RAM at DDR2 667. Due to the number of accounts extracted, imported and calculated....the system maxes out for 2-3 hours at a time and bogs down numerous other times. I was given the go ahead and a budget of $750 to build a new computer to handle the processing and reporting. Although this was approved outside the normal IT channels, it was approved due to the fact that I am the only one in the company capable of this type of reporting.

 

I ordered the parts today and was wondering what the consensus was on whether I got a good deal or not. Overall, I am happy with the cost vs value of what I bought. Below are the specs:

 

Case: Azzo Salano 1000 Full Tower $129.99 - $40.00 MIR = $89.99

8 internal 3.5" HD

2x230mm fans

2x140mm fans

1x120mm fan

PS: OCZ StealthXStream 700W $84.99 - $20.00 MIR = $64.99

6xSATA

Motherboard: Biostar TA790GXB A2+ $99.99 - $20.00 MIR - $79.99 CD = $0.00

CPU: AMD Phenom X4 II 940BE $189.99

CPU Cooler: Cooler Master GeminII 120mm $34.99

Memory: (2) Wintec AMPX 2x2GB DDR2 800 $85.98 - $10.00 MIR = $75.98

8GB of RAM total

GPU: Integrated ATI 3300

HD: (5) Western Digital Caviar Black 500GB $299.95

RAID 10 on 4 drives with 1 drive as a spare or additional storage

USB Flash: OCZ Diesel 4GB $12.99 - $12.99 CD = $0.00

 

Shipping $33.86

Total Cost $789.75

Link to comment
Share on other sites

The hardware looks fine. However in my opinion it is your choice of windows and Microsoft's SQL server that may be the major bottle neck creating the total max and bog down of the system.

 

You would do much better to use an operating system that handles processing multiple threads and memory management better, along with the use of the superior MySQL to handle the database server services.

Link to comment
Share on other sites

Thanks Bruce. Even though we are building this outside of the IT structure, we are still limited to the software they deem appropriate in the org. Therefore, we are stuck with Server 2003/8 with SQL 2005/8.

 

Dan

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...