SQL Server 2005 Standard Ed on 4 way servers

26 Aug 2006 9:53 AM

andsm

I looking at results of tpc-c tests for 4 way computers. Best results for
SQL2k5 was established on 4x AMD Opteron dual core servers, with usage of SQL
Server 2005 Enterprise Edition. The question is - why Enterprise Edition, why
not Standard Edition which also support 4 CPUs and same memory? I guess
something in Enterprise Edition works faster? I looked at some used SPs, not
found anything specific to Enterprise Edition..

26 Aug 2006 10:22 PM

Erland Sommarskog

andsm (an***@discussions.microsoft.com) writes:

> I looking at results of tpc-c tests for 4 way computers. Best results
> for SQL2k5 was established on 4x AMD Opteron dual core servers, with
> usage of SQL Server 2005 Enterprise Edition. The question is - why
> Enterprise Edition, why not Standard Edition which also support 4 CPUs
> and same memory? I guess something in Enterprise Edition works faster? I
> looked at some used SPs, not found anything specific to Enterprise
> Edition..

On ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/81f3e917-884a-4cc8-
aca2-0a5fea89f355.htm
in Books Online, you can see which features that are includd in the
various editions. I found at least one that is likely to be related to
the TPC-C test, "Enhanced Read-ahead and Scan (Super Scan)".

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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx