SQL 2008 with more cpu core

[OceanDeep via SQLMonster.com]

We are using SQL 2008 64 bit sp 1 std on Windows 2008 std 64 bit for a new
reporting server. We are planning to buy a dell server with two CPU's. Is
it true that we should buy as many cores as our budget allows? So if there
is a 12 core server out there, we should get it. As far as I know, unless
we configure it differently, SQL 2008 should spread the load across all cores.

Also, since the top speed cpu is quite expensive, what would be the prefer
configuration, a higher speed of cpu but less core or medium speed CPU with
more core.

is there any issue with parallelism muliple core configuration esp 12 core?

od

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-performance/201005/1

[Erland Sommarskog]

OceanDeep via SQLMonster.com (u46587@uwe) writes:
> We are using SQL 2008 64 bit sp 1 std on Windows 2008 std 64 bit for a
> new reporting server. We are planning to buy a dell server with two
> CPU's. Is it true that we should buy as many cores as our budget
> allows? So if there is a 12 core server out there, we should get it.
> As far as I know, unless we configure it differently, SQL 2008 should
> spread the load across all cores.
>
>
> Also, since the top speed cpu is quite expensive, what would be the
> prefer configuration, a higher speed of cpu but less core or medium
> speed CPU with more core.

Not any simple question to answer, as there is a lot of "it depends".
But assuming a multi-user load, I'd say more cores is better than raw
CPU speed.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx