devxlogo

Hardware config. development server

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).

See also  How to Block Websites During Certain Hours on a Mac Computer
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist