Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Feb 1, 1999

Hardware config. development server

Question:
I plan to create a SQL Server 7 database containing about 40 - 70GB of data. The data will be generated by queries. How should I spend my money for a development server? What is most important--fast disk, cache, RAID or RAM, or processor speed? Will I be able to benefit from two processors?

Answer:
First of all, you ask the question concerning your development server. Do you know what your production server will look like? Your development server should, if possible, mimic production so that you can conduct proper stress tests to simulate your actual production environment.

How many users do you foresee having?

How many queries and transactions will you have per hour?

Is this a data warehouse or an OLTP application?

As far as benefiting from two processors, you can benefit if you need it--that is, if you are maxing out on CPU cycles. I'd recommend getting a machine with two processors that allows for later expansion.

Its hard to say what is most important. A deficiency in CPU, RAM, or IO can cripple your performance. The key is to get the proper configuration of each. As a general rule, people seem to pay more attention to CPUs and RAM. They buy lots of both but overlook the importance of IO. This is especially the case when it comes to planning for backups (dumping to disk is fastest).

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date