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 improvements
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.4Ghz
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 using
more than one processor.
John
"Marks70" wrote:
> 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 improvements
> 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.4Ghz
> single core processors.
> Thanks.