What is the Ideal SQL Server Test Box?

Posted on by

I’m thinking about setting up a SQL Server test box in my home office for doing some extensive, real-world SQL Server performance testing. So far, here is what I am thinking about getting:

–Because I have limited space, the test box will need to be a tower. I will also be limited to one physical test box because of a lack of room (and budget).

–CPU: 2 sockets with a total of at least 8 cores. Haven’t decided on the specific chips yet.

–RAM: At least 36GB. I want to have the ability to set up multiple virtual servers in the test box.

–RAID Controller: Must support RAID 1, 5, & 10, and any mixture of these RAID levels.

–Drives: I am looking at getting 8-16, 15K SAS drives, with a minimum capacity of 450GB each. The number of  drives will depend on what I can fit into my budget, and how many can fit in a tower.

I am still very much in the research stage, so my question to you is, if you could spec out your own SQL Server home test system, and you had $10,000 to spend, what you buy, and why?

PS: If you are a hardware vendor and would be interesting in letting me borrow such a test box from you for the next year or so, I would be very interested in talking with you.  🙂

3 thoughts on “What is the Ideal SQL Server Test Box?”

  1. Pingback: Tweets that mention What is the Ideal SQL Server Test Box? | SQL Aloha -- Topsy.com

  2. I would look at systems with two Xeon X5650 or better processors. That would give you 12 (or 24 with HT enabled) cores. Something like a Dell PowerEdge T610 or T710 meets most of your requirements for about $10K.

  3. Hi Glenn. I am in the process of getting a quote from Dell on a T710 that is fully loaded, as you have suggested, it seems the T710 be one of the better options I have for meeting my goals.

Comments are closed.