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
>> >>
>> >>
>> >>
>>