Dual Core CPUs and SQL Server 2000

I need to configure and purchase two new servers running SQL 2000 Enterprise
Edition on Windows 2003 Enterprise Edition each equipped with 2 processors.
I'm wondering if anyone has experience with or knowledge of using dual core
Intel Xeon Processors with SQL Server, and if there are definite improvement
s
over single core higher clocked processors. I'm trying to decide whether to
configure the servers with two 2.8Ghz Dual Core Xeon processors or two 3.4Gh
z
single core processors.
Thanks.Hi
You may want to read this
http://www.sql-server-performance.com/jc_processor.asp although not
specifically about dual core I would expect dual core to be the akin to usin
g
more than one processor.
John
"Marks70" wrote:

> I need to configure and purchase two new servers running SQL 2000 Enterpri
se
> Edition on Windows 2003 Enterprise Edition each equipped with 2 processors
.
> I'm wondering if anyone has experience with or knowledge of using dual cor
e
> Intel Xeon Processors with SQL Server, and if there are definite improveme
nts
> over single core higher clocked processors. I'm trying to decide whether t
o
> configure the servers with two 2.8Ghz Dual Core Xeon processors or two 3.4
Ghz
> single core processors.
> Thanks.