Ideal hardware setup?  
Author Message
CynthiaNottinghamMS





PostPosted: Thu Dec 04 11:33:20 CST 2003 Top

SQL Server >> Ideal hardware setup?

I'm putting a 'wish list' together for next years budget and part of this
will hopefully include a SQL server. I have never used SQL before and
although I have read MS recommended setup, what are peoples thoughts on
ideal hardware setup? eg dual processors (does this affect licensing?)/
memory
thanks

SQL Server147  
 
 
joe





PostPosted: Thu Dec 04 11:33:20 CST 2003 Top

SQL Server >> Ideal hardware setup? if you are new to sql, i would highly recommend looking at:
Microsoft Systems Architecture v2.0
(search: MSA)
there is also an Internet and Enterprise versions
it is not necessarily a matter the right or wrong choice,
sometime its safer to choose the configuration MS and the
system vendor advocate

>-----Original Message-----
>I'm putting a 'wish list' together for next years budget
and part of this
>will hopefully include a SQL server. I have never used
SQL before and
>although I have read MS recommended setup, what are
peoples thoughts on
>ideal hardware setup? eg dual processors (does this
affect licensing?)/
>memory
>thanks
>
>
>.
>
 
 
Eric





PostPosted: Thu Dec 04 12:25:21 CST 2003 Top

SQL Server >> Ideal hardware setup? This is of course a "it depends" question. Since you haven't used SQL
before and probably not Oracle, I will assume you're limited to a
non-cluster/non-SAN install.

OS - W2k3 with 4 GB memory for Std, more if Ent and if you can afford it
RAID 1 for the OS and SQL executables, which means a RAID card and 2 drives.
Typically a RAID card has at least 2 channels. I like to use a channel per
backplane so each "bank" of drives is controlled separately. Honestly, I
like to put a RAID card in each BUS and split out my drives that way. But
basicaly you should want to put your log files for your databases on one
RAID array, (RAID 1+0, or 10 as some say), your data files on another array,
RAID 5 or 10, really depends on your needs, and your tempdb on another
separate RAID 1 or 1+0 array.

Processors, buy the fastest and quantity you can afford. Haven't tested
hyperthreading with SQL so I can't make a recommendation there. Processers
and their quantity DOES affect pricing if you use PER PROCESSOR licensing.
It can get expensive but it costs less than Oracle and a well designed
database will perform great almost wherever you install it.

Gigabit network if you have it.

hth
Eric







> I'm putting a 'wish list' together for next years budget and part of this
> will hopefully include a SQL server. I have never used SQL before and
> although I have read MS recommended setup, what are peoples thoughts on
> ideal hardware setup? eg dual processors (does this affect licensing?)/
> memory
> thanks
>
>


 
 
Support





PostPosted: Fri Dec 05 08:10:59 CST 2003 Top

SQL Server >> Ideal hardware setup? thanks you've both been very helpful




> I'm putting a 'wish list' together for next years budget and part of this
> will hopefully include a SQL server. I have never used SQL before and
> although I have read MS recommended setup, what are peoples thoughts on
> ideal hardware setup? eg dual processors (does this affect licensing?)/
> memory
> thanks
>
>