How to determine hardware specs for a new SQL Server 2005 box.

Last Post 18 Apr 2010 06:37 PM by rm. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
KPSQL
New Member
New Member

--
16 Apr 2010 11:01 AM
Hi,

We are using SQL Server 2005 (SP3). Enterprise Edition (64 bit). We are going to upgrade the hardware in a year.

I am trying to spec out the new hardware.

I am planning to do the following:

1. Get the current database size(s). Monitor and see how they grow over the next year.
2. Estimate how many new databases we are going to add on the new server.
3. Monitor the CPU, Memory and Disk usage over a year.

My questions are:

1. How to determine an optimum CPU for the new box.
2. How to determine the optimum RAM for the new box. 4 GB, 8 GB, 16 GB etc. How is this determined.
3. Disk allocation. This can be determined by the database size growth over a year.

Any tips? Pointers? Articles? Blogs? any one can refer me will help a lot.

Thanks


gunneyk
New Member
New Member

--
16 Apr 2010 11:37 AM
This is a very wide topic and there are lots of things to consider which may be specific to each isntance. The biggest piece of advice I can offer is if in doubt go larger. Meaning things like Memory and even procesors these days are relatively inexpensive and its better to have more than not enough. But hopefully some of these can help you to get closer to the actual numbers you need.

http://www.sqlmag.com/article/iscsi...nment.aspx

http://sqlcat.com/top10lists/archiv...tices.aspx
http://sqlcat.com/whitepapers/archi...dance.aspx

If you plan to move to 2008 you might consider compression and this should be of interest.
http://sqlcat.com/whitepapers/archive/2009/05/29/data-compression-strategy-capacity-planning-and-best-practices.aspx
rm
New Member
New Member

--
18 Apr 2010 06:37 PM
Server vendors have hardware spec tool, check their web site.


Acceptable Use Policy
---