How to Capacity Plan for CPU and Memory for a new SQL SERVER Setup

Hi all,

We are going to setup a new server,so for that How to Capacity Plan for CPU and Memory ,Hard Disk for a new SQL SERVER Setup.

Is there any specific criteria for capacity planning ?in which base we should do this part.

Thanks

Kumar

In general...

...if the database is big, buy more RAM.

...if the database is subject to heavy modification, buy fast hard drives.

...if you have a lot of users and/or have a lot of complex queries running, but faster/more/multi-core CPUs.

It's not an exact science.

-Ryan / Kardax

|||

Hi Ryan,

Thanks alot.

Is there any other way to plan so that it's easy for Newsetup Servers.

|||

Hi,

How to plan the Capacity Plan for CPU and Memory for a new SQL SERVER Setup.