Dual Processors Xeon Support

Dear SQL Server Users,
How do I configure Sql Server 2000 to supports dual cpu (Xeon)?
Kind Regards
Charles
By default, the installation chooses all the CPUs. You can change it to use
only 1 CPU later.
Gopi
"Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
news:67E77C3C-899A-47E9-AE60-EE98D32C48BC@.microsoft.com...
> Dear SQL Server Users,
> How do I configure Sql Server 2000 to supports dual cpu (Xeon)?
> Kind Regards
> Charles
|||a related question: if you have two instances and one dual cpu xeon,
can you set the processor affinity to use one processor per instance?
if so, does this buy you as much as setting the processor affinity for
two (separate) processors?
thanks,
arthur
|||Hi Rgn,
Could you point me to further information on Sql Server for DUAL CPU
environment?
Kind Regards
Charles
"rgn" wrote:

> By default, the installation chooses all the CPUs. You can change it to use
> only 1 CPU later.
> Gopi
> "Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
> news:67E77C3C-899A-47E9-AE60-EE98D32C48BC@.microsoft.com...
>
>
|||What kind of information? Standard edition or above will use multiple
processors by default. You don't have to do anything.
Andrew J. Kelly SQL MVP
"Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
news:2594534E-DF3A-448A-98DA-5D8325AEBC0C@.microsoft.com...[vbcol=seagreen]
> Hi Rgn,
> Could you point me to further information on Sql Server for DUAL CPU
> environment?
> Kind Regards
> Charles
> "rgn" wrote:
|||Arthur,
Check the Microsoft website for a whitepaper on HT processors. These were
first introduced on Xeon Server processors
and the OS (MicroSoft) does treat them as two logical CPUs even though it is
one Physical CPU.
Microsoft itself mentions that the performance gain is not that significant
(as of WIN2K/SQL2K) as the performance gain
is only about 30% when compared to two Physical CPUs and this is because
WIN2K/SQL2K is not designed to make
use of the Hyper Threading features.
Please check the Microsoft website. I cant recollect the URL as I had read
this 2 years before.
Gopi
"arthur" <alangham@.gmail.com> wrote in message
news:1108394471.350245.286640@.f14g2000cwb.googlegr oups.com...
>a related question: if you have two instances and one dual cpu xeon,
> can you set the processor affinity to use one processor per instance?
> if so, does this buy you as much as setting the processor affinity for
> two (separate) processors?
> thanks,
> arthur
>
|||Hi Andrew
I'm looking for documentation on how to tune-up SQL Server Standard Edition
on Dual CPU Xeon.
Kind Regards
Charles
"Andrew J. Kelly" wrote:

> What kind of information? Standard edition or above will use multiple
> processors by default. You don't have to do anything.
> --
> Andrew J. Kelly SQL MVP
>
> "Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
> news:2594534E-DF3A-448A-98DA-5D8325AEBC0C@.microsoft.com...
>
>
|||There isn't much regarding the dual cpu part. The tuning is mostly the same
as it pertains more to I/O and poor queries or schemas. Have a look at
these:
http://www.microsoft.com/sql/techinf...perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.co...ance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.co...mance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/de...rfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
news:B77F9EBF-ACD1-4D20-8AE6-72B80469BC62@.microsoft.com...[vbcol=seagreen]
> Hi Andrew
> I'm looking for documentation on how to tune-up SQL Server Standard
> Edition
> on Dual CPU Xeon.
> Kind Regards
> Charles
> "Andrew J. Kelly" wrote:

Dual Processors Xeon Support

Dear SQL Server Users,
How do I configure Sql Server 2000 to supports dual cpu (Xeon)?
Kind Regards
CharlesBy default, the installation chooses all the CPUs. You can change it to use
only 1 CPU later.
Gopi
"Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
news:67E77C3C-899A-47E9-AE60-EE98D32C48BC@.microsoft.com...
> Dear SQL Server Users,
> How do I configure Sql Server 2000 to supports dual cpu (Xeon)?
> Kind Regards
> Charles|||a related question: if you have two instances and one dual cpu xeon,
can you set the processor affinity to use one processor per instance?
if so, does this buy you as much as setting the processor affinity for
two (separate) processors?
thanks,
arthur|||Hi Rgn,
Could you point me to further information on Sql Server for DUAL CPU
environment?
Kind Regards
Charles
"rgn" wrote:

> By default, the installation chooses all the CPUs. You can change it to us
e
> only 1 CPU later.
> Gopi
> "Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
> news:67E77C3C-899A-47E9-AE60-EE98D32C48BC@.microsoft.com...
>
>|||What kind of information? Standard edition or above will use multiple
processors by default. You don't have to do anything.
Andrew J. Kelly SQL MVP
"Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
news:2594534E-DF3A-448A-98DA-5D8325AEBC0C@.microsoft.com...[vbcol=seagreen]
> Hi Rgn,
> Could you point me to further information on Sql Server for DUAL CPU
> environment?
> Kind Regards
> Charles
> "rgn" wrote:
>|||Arthur,
Check the Microsoft website for a whitepaper on HT processors. These were
first introduced on Xeon Server processors
and the OS (MicroSoft) does treat them as two logical CPUs even though it is
one Physical CPU.
Microsoft itself mentions that the performance gain is not that significant
(as of WIN2K/SQL2K) as the performance gain
is only about 30% when compared to two Physical CPUs and this is because
WIN2K/SQL2K is not designed to make
use of the Hyper Threading features.
Please check the Microsoft website. I cant recollect the URL as I had read
this 2 years before.
Gopi
"arthur" <alangham@.gmail.com> wrote in message
news:1108394471.350245.286640@.f14g2000cwb.googlegroups.com...
>a related question: if you have two instances and one dual cpu xeon,
> can you set the processor affinity to use one processor per instance?
> if so, does this buy you as much as setting the processor affinity for
> two (separate) processors?
> thanks,
> arthur
>|||Hi Andrew
I'm looking for documentation on how to tune-up SQL Server Standard Edition
on Dual CPU Xeon.
Kind Regards
Charles
"Andrew J. Kelly" wrote:

> What kind of information? Standard edition or above will use multiple
> processors by default. You don't have to do anything.
> --
> Andrew J. Kelly SQL MVP
>
> "Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
> news:2594534E-DF3A-448A-98DA-5D8325AEBC0C@.microsoft.com...
>
>|||There isn't much regarding the dual cpu part. The tuning is mostly the same
as it pertains more to I/O and poor queries or schemas. Have a look at
these:
http://www.microsoft.com/sql/techin.../perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.c...mance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.c...rmance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/d.../>
on_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
news:B77F9EBF-ACD1-4D20-8AE6-72B80469BC62@.microsoft.com...[vbcol=seagreen]
> Hi Andrew
> I'm looking for documentation on how to tune-up SQL Server Standard
> Edition
> on Dual CPU Xeon.
> Kind Regards
> Charles
> "Andrew J. Kelly" wrote:
>

Dual Processors Xeon Support

Dear SQL Server Users,
How do I configure Sql Server 2000 to supports dual cpu (Xeon)?
Kind Regards
CharlesBy default, the installation chooses all the CPUs. You can change it to use
only 1 CPU later.
Gopi
"Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
news:67E77C3C-899A-47E9-AE60-EE98D32C48BC@.microsoft.com...
> Dear SQL Server Users,
> How do I configure Sql Server 2000 to supports dual cpu (Xeon)?
> Kind Regards
> Charles|||a related question: if you have two instances and one dual cpu xeon,
can you set the processor affinity to use one processor per instance?
if so, does this buy you as much as setting the processor affinity for
two (separate) processors?
thanks,
arthur|||Hi Rgn,
Could you point me to further information on Sql Server for DUAL CPU
environment?
Kind Regards
Charles
"rgn" wrote:
> By default, the installation chooses all the CPUs. You can change it to use
> only 1 CPU later.
> Gopi
> "Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
> news:67E77C3C-899A-47E9-AE60-EE98D32C48BC@.microsoft.com...
> > Dear SQL Server Users,
> >
> > How do I configure Sql Server 2000 to supports dual cpu (Xeon)?
> >
> > Kind Regards
> > Charles
>
>|||What kind of information? Standard edition or above will use multiple
processors by default. You don't have to do anything.
--
Andrew J. Kelly SQL MVP
"Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
news:2594534E-DF3A-448A-98DA-5D8325AEBC0C@.microsoft.com...
> Hi Rgn,
> Could you point me to further information on Sql Server for DUAL CPU
> environment?
> Kind Regards
> Charles
> "rgn" wrote:
>> By default, the installation chooses all the CPUs. You can change it to
>> use
>> only 1 CPU later.
>> Gopi
>> "Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
>> news:67E77C3C-899A-47E9-AE60-EE98D32C48BC@.microsoft.com...
>> > Dear SQL Server Users,
>> >
>> > How do I configure Sql Server 2000 to supports dual cpu (Xeon)?
>> >
>> > Kind Regards
>> > Charles
>>|||Arthur,
Check the Microsoft website for a whitepaper on HT processors. These were
first introduced on Xeon Server processors
and the OS (MicroSoft) does treat them as two logical CPUs even though it is
one Physical CPU.
Microsoft itself mentions that the performance gain is not that significant
(as of WIN2K/SQL2K) as the performance gain
is only about 30% when compared to two Physical CPUs and this is because
WIN2K/SQL2K is not designed to make
use of the Hyper Threading features.
Please check the Microsoft website. I cant recollect the URL as I had read
this 2 years before.
Gopi
"arthur" <alangham@.gmail.com> wrote in message
news:1108394471.350245.286640@.f14g2000cwb.googlegroups.com...
>a related question: if you have two instances and one dual cpu xeon,
> can you set the processor affinity to use one processor per instance?
> if so, does this buy you as much as setting the processor affinity for
> two (separate) processors?
> thanks,
> arthur
>|||Hi Andrew
I'm looking for documentation on how to tune-up SQL Server Standard Edition
on Dual CPU Xeon.
Kind Regards
Charles
"Andrew J. Kelly" wrote:
> What kind of information? Standard edition or above will use multiple
> processors by default. You don't have to do anything.
> --
> Andrew J. Kelly SQL MVP
>
> "Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
> news:2594534E-DF3A-448A-98DA-5D8325AEBC0C@.microsoft.com...
> > Hi Rgn,
> >
> > Could you point me to further information on Sql Server for DUAL CPU
> > environment?
> >
> > Kind Regards
> > Charles
> >
> > "rgn" wrote:
> >
> >> By default, the installation chooses all the CPUs. You can change it to
> >> use
> >> only 1 CPU later.
> >>
> >> Gopi
> >>
> >> "Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
> >> news:67E77C3C-899A-47E9-AE60-EE98D32C48BC@.microsoft.com...
> >> > Dear SQL Server Users,
> >> >
> >> > How do I configure Sql Server 2000 to supports dual cpu (Xeon)?
> >> >
> >> > Kind Regards
> >> > Charles
> >>
> >>
> >>
>
>|||There isn't much regarding the dual cpu part. The tuning is mostly the same
as it pertains more to I/O and poor queries or schemas. Have a look at
these:
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
news:B77F9EBF-ACD1-4D20-8AE6-72B80469BC62@.microsoft.com...
> Hi Andrew
> I'm looking for documentation on how to tune-up SQL Server Standard
> Edition
> on Dual CPU Xeon.
> Kind Regards
> Charles
> "Andrew J. Kelly" wrote:
>> What kind of information? Standard edition or above will use multiple
>> processors by default. You don't have to do anything.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
>> news:2594534E-DF3A-448A-98DA-5D8325AEBC0C@.microsoft.com...
>> > Hi Rgn,
>> >
>> > Could you point me to further information on Sql Server for DUAL CPU
>> > environment?
>> >
>> > Kind Regards
>> > Charles
>> >
>> > "rgn" wrote:
>> >
>> >> By default, the installation chooses all the CPUs. You can change it
>> >> to
>> >> use
>> >> only 1 CPU later.
>> >>
>> >> Gopi
>> >>
>> >> "Charles Tam" <CharlesTam@.discussions.microsoft.com> wrote in message
>> >> news:67E77C3C-899A-47E9-AE60-EE98D32C48BC@.microsoft.com...
>> >> > Dear SQL Server Users,
>> >> >
>> >> > How do I configure Sql Server 2000 to supports dual cpu (Xeon)?
>> >> >
>> >> > Kind Regards
>> >> > Charles
>> >>
>> >>
>> >>
>>

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.

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.

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.