In per processor license for Enterprise version of SQL Server 2000, can we
change the affinity mask variable to change the CPU usage and hence restrict
the number of sql server per processor licenses?
Example: In a 4 CPU server, single OS, if I change the sql server affinity
so that it only uses CPU1 and CPU2, and does not use the 3 & 4 processors,
then I would pay only for 2 per processor licenses for SQL Server 2000?
No. You need # of processors corresponding to the numbers that the host OS can see and uses. Here's
a quote from http://www.microsoft.com/sql/howtobuy/faq.mspx
A Processor license gives you the right to install any number of copies of SQL Server 2000 on a
single computer, as long as you have purchased Processor licenses for all of the processors on that
computer. If you have made a processor inaccessible to all operating system copies on which the SQL
Server software is set up to run, you do not need a software license for that processor.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:627E25D7-42D2-4BBE-9991-C204FA1FD206@.microsoft.com...
> In per processor license for Enterprise version of SQL Server 2000, can we
> change the affinity mask variable to change the CPU usage and hence restrict
> the number of sql server per processor licenses?
> Example: In a 4 CPU server, single OS, if I change the sql server affinity
> so that it only uses CPU1 and CPU2, and does not use the 3 & 4 processors,
> then I would pay only for 2 per processor licenses for SQL Server 2000?
>
>
|||I read the Licensing FAQs.. However everywhere it says:
"If you have made a processor inaccessible to all operating system copies on
which the SQL Server software is set up to run, you do not need a software
license for that processor."
Why would you make a processor inaccessible to OS? Do you mean when you have
2 or more OS installed on the same server?
Can you give an illustration of this scenario for clarification, the FAQ and
licesing link does not say much?
Thanks
"Tibor Karaszi" wrote:
> No. You need # of processors corresponding to the numbers that the host OS can see and uses. Here's
> a quote from http://www.microsoft.com/sql/howtobuy/faq.mspx
> A Processor license gives you the right to install any number of copies of SQL Server 2000 on a
> single computer, as long as you have purchased Processor licenses for all of the processors on that
> computer. If you have made a processor inaccessible to all operating system copies on which the SQL
> Server software is set up to run, you do not need a software license for that processor.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Pari" <Pari@.discussions.microsoft.com> wrote in message
> news:627E25D7-42D2-4BBE-9991-C204FA1FD206@.microsoft.com...
>
|||You might want5 to approach an MS sales rep on this. As I understand it, the reasoning why just
cutting down affinity mask doesn't cut it is that everything SQL Server does it does through the
OS...
The licensing terms used to say "numbers of physical processors in the box" (or something to that
effect), but as big boxes came out where you started partitioning the OS, it made more sense to have
it "number of processors that the OS can use", methinks...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:D38F26A9-3F72-4720-B48C-CF581801526D@.microsoft.com...[vbcol=seagreen]
>I read the Licensing FAQs.. However everywhere it says:
> "If you have made a processor inaccessible to all operating system copies on
> which the SQL Server software is set up to run, you do not need a software
> license for that processor."
> Why would you make a processor inaccessible to OS? Do you mean when you have
> 2 or more OS installed on the same server?
> Can you give an illustration of this scenario for clarification, the FAQ and
> licesing link does not say much?
> Thanks
> "Tibor Karaszi" wrote:
Showing posts with label processor. Show all posts
Showing posts with label processor. Show all posts
Sunday, February 12, 2012
affinity mask - license
In per processor license for Enterprise version of SQL Server 2000, can we
change the affinity mask variable to change the CPU usage and hence restric
t
the number of sql server per processor licenses?
Example: In a 4 CPU server, single OS, if I change the sql server affinity
so that it only uses CPU1 and CPU2, and does not use the 3 & 4 processors,
then I would pay only for 2 per processor licenses for SQL Server 2000?No. You need # of processors corresponding to the numbers that the host OS c
an see and uses. Here's
a quote from http://www.microsoft.com/sql/howtobuy/faq.mspx
A Processor license gives you the right to install any number of copies of S
QL Server 2000 on a
single computer, as long as you have purchased Processor licenses for all of
the processors on that
computer. If you have made a processor inaccessible to all operating system
copies on which the SQL
Server software is set up to run, you do not need a software license for tha
t processor.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:627E25D7-42D2-4BBE-9991-C204FA1FD206@.microsoft.com...
> In per processor license for Enterprise version of SQL Server 2000, can we
> change the affinity mask variable to change the CPU usage and hence restr
ict
> the number of sql server per processor licenses?
> Example: In a 4 CPU server, single OS, if I change the sql server affinity
> so that it only uses CPU1 and CPU2, and does not use the 3 & 4 processors,
> then I would pay only for 2 per processor licenses for SQL Server 2000?
>
>|||I read the Licensing FAQs.. However everywhere it says:
"If you have made a processor inaccessible to all operating system copies on
which the SQL Server software is set up to run, you do not need a software
license for that processor."
Why would you make a processor inaccessible to OS? Do you mean when you have
2 or more OS installed on the same server?
Can you give an illustration of this scenario for clarification, the FAQ and
licesing link does not say much?
Thanks
"Tibor Karaszi" wrote:
> No. You need # of processors corresponding to the numbers that the host OS
can see and uses. Here's
> a quote from http://www.microsoft.com/sql/howtobuy/faq.mspx
> A Processor license gives you the right to install any number of copies of
SQL Server 2000 on a
> single computer, as long as you have purchased Processor licenses for all
of the processors on that
> computer. If you have made a processor inaccessible to all operating syste
m copies on which the SQL
> Server software is set up to run, you do not need a software license for t
hat processor.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Pari" <Pari@.discussions.microsoft.com> wrote in message
> news:627E25D7-42D2-4BBE-9991-C204FA1FD206@.microsoft.com...
>|||You might want5 to approach an MS sales rep on this. As I understand it, the
reasoning why just
cutting down affinity mask doesn't cut it is that everything SQL Server does
it does through the
OS...
The licensing terms used to say "numbers of physical processors in the box"
(or something to that
effect), but as big boxes came out where you started partitioning the OS, it
made more sense to have
it "number of processors that the OS can use", methinks...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:D38F26A9-3F72-4720-B48C-CF581801526D@.microsoft.com...[vbcol=seagreen]
>I read the Licensing FAQs.. However everywhere it says:
> "If you have made a processor inaccessible to all operating system copies
on
> which the SQL Server software is set up to run, you do not need a software
> license for that processor."
> Why would you make a processor inaccessible to OS? Do you mean when you ha
ve
> 2 or more OS installed on the same server?
> Can you give an illustration of this scenario for clarification, the FAQ a
nd
> licesing link does not say much?
> Thanks
> "Tibor Karaszi" wrote:
>
change the affinity mask variable to change the CPU usage and hence restric
t
the number of sql server per processor licenses?
Example: In a 4 CPU server, single OS, if I change the sql server affinity
so that it only uses CPU1 and CPU2, and does not use the 3 & 4 processors,
then I would pay only for 2 per processor licenses for SQL Server 2000?No. You need # of processors corresponding to the numbers that the host OS c
an see and uses. Here's
a quote from http://www.microsoft.com/sql/howtobuy/faq.mspx
A Processor license gives you the right to install any number of copies of S
QL Server 2000 on a
single computer, as long as you have purchased Processor licenses for all of
the processors on that
computer. If you have made a processor inaccessible to all operating system
copies on which the SQL
Server software is set up to run, you do not need a software license for tha
t processor.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:627E25D7-42D2-4BBE-9991-C204FA1FD206@.microsoft.com...
> In per processor license for Enterprise version of SQL Server 2000, can we
> change the affinity mask variable to change the CPU usage and hence restr
ict
> the number of sql server per processor licenses?
> Example: In a 4 CPU server, single OS, if I change the sql server affinity
> so that it only uses CPU1 and CPU2, and does not use the 3 & 4 processors,
> then I would pay only for 2 per processor licenses for SQL Server 2000?
>
>|||I read the Licensing FAQs.. However everywhere it says:
"If you have made a processor inaccessible to all operating system copies on
which the SQL Server software is set up to run, you do not need a software
license for that processor."
Why would you make a processor inaccessible to OS? Do you mean when you have
2 or more OS installed on the same server?
Can you give an illustration of this scenario for clarification, the FAQ and
licesing link does not say much?
Thanks
"Tibor Karaszi" wrote:
> No. You need # of processors corresponding to the numbers that the host OS
can see and uses. Here's
> a quote from http://www.microsoft.com/sql/howtobuy/faq.mspx
> A Processor license gives you the right to install any number of copies of
SQL Server 2000 on a
> single computer, as long as you have purchased Processor licenses for all
of the processors on that
> computer. If you have made a processor inaccessible to all operating syste
m copies on which the SQL
> Server software is set up to run, you do not need a software license for t
hat processor.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Pari" <Pari@.discussions.microsoft.com> wrote in message
> news:627E25D7-42D2-4BBE-9991-C204FA1FD206@.microsoft.com...
>|||You might want5 to approach an MS sales rep on this. As I understand it, the
reasoning why just
cutting down affinity mask doesn't cut it is that everything SQL Server does
it does through the
OS...
The licensing terms used to say "numbers of physical processors in the box"
(or something to that
effect), but as big boxes came out where you started partitioning the OS, it
made more sense to have
it "number of processors that the OS can use", methinks...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:D38F26A9-3F72-4720-B48C-CF581801526D@.microsoft.com...[vbcol=seagreen]
>I read the Licensing FAQs.. However everywhere it says:
> "If you have made a processor inaccessible to all operating system copies
on
> which the SQL Server software is set up to run, you do not need a software
> license for that processor."
> Why would you make a processor inaccessible to OS? Do you mean when you ha
ve
> 2 or more OS installed on the same server?
> Can you give an illustration of this scenario for clarification, the FAQ a
nd
> licesing link does not say much?
> Thanks
> "Tibor Karaszi" wrote:
>
affinity mask - license
In per processor license for Enterprise version of SQL Server 2000, can we
change the affinity mask variable to change the CPU usage and hence restrict
the number of sql server per processor licenses?
Example: In a 4 CPU server, single OS, if I change the sql server affinity
so that it only uses CPU1 and CPU2, and does not use the 3 & 4 processors,
then I would pay only for 2 per processor licenses for SQL Server 2000?No. You need # of processors corresponding to the numbers that the host OS can see and uses. Here's
a quote from http://www.microsoft.com/sql/howtobuy/faq.mspx
A Processor license gives you the right to install any number of copies of SQL Server 2000 on a
single computer, as long as you have purchased Processor licenses for all of the processors on that
computer. If you have made a processor inaccessible to all operating system copies on which the SQL
Server software is set up to run, you do not need a software license for that processor.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:627E25D7-42D2-4BBE-9991-C204FA1FD206@.microsoft.com...
> In per processor license for Enterprise version of SQL Server 2000, can we
> change the affinity mask variable to change the CPU usage and hence restrict
> the number of sql server per processor licenses?
> Example: In a 4 CPU server, single OS, if I change the sql server affinity
> so that it only uses CPU1 and CPU2, and does not use the 3 & 4 processors,
> then I would pay only for 2 per processor licenses for SQL Server 2000?
>
>|||I read the Licensing FAQs.. However everywhere it says:
"If you have made a processor inaccessible to all operating system copies on
which the SQL Server software is set up to run, you do not need a software
license for that processor."
Why would you make a processor inaccessible to OS? Do you mean when you have
2 or more OS installed on the same server?
Can you give an illustration of this scenario for clarification, the FAQ and
licesing link does not say much?
Thanks
"Tibor Karaszi" wrote:
> No. You need # of processors corresponding to the numbers that the host OS can see and uses. Here's
> a quote from http://www.microsoft.com/sql/howtobuy/faq.mspx
> A Processor license gives you the right to install any number of copies of SQL Server 2000 on a
> single computer, as long as you have purchased Processor licenses for all of the processors on that
> computer. If you have made a processor inaccessible to all operating system copies on which the SQL
> Server software is set up to run, you do not need a software license for that processor.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Pari" <Pari@.discussions.microsoft.com> wrote in message
> news:627E25D7-42D2-4BBE-9991-C204FA1FD206@.microsoft.com...
> > In per processor license for Enterprise version of SQL Server 2000, can we
> > change the affinity mask variable to change the CPU usage and hence restrict
> > the number of sql server per processor licenses?
> >
> > Example: In a 4 CPU server, single OS, if I change the sql server affinity
> > so that it only uses CPU1 and CPU2, and does not use the 3 & 4 processors,
> > then I would pay only for 2 per processor licenses for SQL Server 2000?
> >
> >
> >
>|||You might want5 to approach an MS sales rep on this. As I understand it, the reasoning why just
cutting down affinity mask doesn't cut it is that everything SQL Server does it does through the
OS...
The licensing terms used to say "numbers of physical processors in the box" (or something to that
effect), but as big boxes came out where you started partitioning the OS, it made more sense to have
it "number of processors that the OS can use", methinks...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:D38F26A9-3F72-4720-B48C-CF581801526D@.microsoft.com...
>I read the Licensing FAQs.. However everywhere it says:
> "If you have made a processor inaccessible to all operating system copies on
> which the SQL Server software is set up to run, you do not need a software
> license for that processor."
> Why would you make a processor inaccessible to OS? Do you mean when you have
> 2 or more OS installed on the same server?
> Can you give an illustration of this scenario for clarification, the FAQ and
> licesing link does not say much?
> Thanks
> "Tibor Karaszi" wrote:
>> No. You need # of processors corresponding to the numbers that the host OS can see and uses.
>> Here's
>> a quote from http://www.microsoft.com/sql/howtobuy/faq.mspx
>> A Processor license gives you the right to install any number of copies of SQL Server 2000 on a
>> single computer, as long as you have purchased Processor licenses for all of the processors on
>> that
>> computer. If you have made a processor inaccessible to all operating system copies on which the
>> SQL
>> Server software is set up to run, you do not need a software license for that processor.
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Pari" <Pari@.discussions.microsoft.com> wrote in message
>> news:627E25D7-42D2-4BBE-9991-C204FA1FD206@.microsoft.com...
>> > In per processor license for Enterprise version of SQL Server 2000, can we
>> > change the affinity mask variable to change the CPU usage and hence restrict
>> > the number of sql server per processor licenses?
>> >
>> > Example: In a 4 CPU server, single OS, if I change the sql server affinity
>> > so that it only uses CPU1 and CPU2, and does not use the 3 & 4 processors,
>> > then I would pay only for 2 per processor licenses for SQL Server 2000?
>> >
>> >
>> >
>>
change the affinity mask variable to change the CPU usage and hence restrict
the number of sql server per processor licenses?
Example: In a 4 CPU server, single OS, if I change the sql server affinity
so that it only uses CPU1 and CPU2, and does not use the 3 & 4 processors,
then I would pay only for 2 per processor licenses for SQL Server 2000?No. You need # of processors corresponding to the numbers that the host OS can see and uses. Here's
a quote from http://www.microsoft.com/sql/howtobuy/faq.mspx
A Processor license gives you the right to install any number of copies of SQL Server 2000 on a
single computer, as long as you have purchased Processor licenses for all of the processors on that
computer. If you have made a processor inaccessible to all operating system copies on which the SQL
Server software is set up to run, you do not need a software license for that processor.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:627E25D7-42D2-4BBE-9991-C204FA1FD206@.microsoft.com...
> In per processor license for Enterprise version of SQL Server 2000, can we
> change the affinity mask variable to change the CPU usage and hence restrict
> the number of sql server per processor licenses?
> Example: In a 4 CPU server, single OS, if I change the sql server affinity
> so that it only uses CPU1 and CPU2, and does not use the 3 & 4 processors,
> then I would pay only for 2 per processor licenses for SQL Server 2000?
>
>|||I read the Licensing FAQs.. However everywhere it says:
"If you have made a processor inaccessible to all operating system copies on
which the SQL Server software is set up to run, you do not need a software
license for that processor."
Why would you make a processor inaccessible to OS? Do you mean when you have
2 or more OS installed on the same server?
Can you give an illustration of this scenario for clarification, the FAQ and
licesing link does not say much?
Thanks
"Tibor Karaszi" wrote:
> No. You need # of processors corresponding to the numbers that the host OS can see and uses. Here's
> a quote from http://www.microsoft.com/sql/howtobuy/faq.mspx
> A Processor license gives you the right to install any number of copies of SQL Server 2000 on a
> single computer, as long as you have purchased Processor licenses for all of the processors on that
> computer. If you have made a processor inaccessible to all operating system copies on which the SQL
> Server software is set up to run, you do not need a software license for that processor.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Pari" <Pari@.discussions.microsoft.com> wrote in message
> news:627E25D7-42D2-4BBE-9991-C204FA1FD206@.microsoft.com...
> > In per processor license for Enterprise version of SQL Server 2000, can we
> > change the affinity mask variable to change the CPU usage and hence restrict
> > the number of sql server per processor licenses?
> >
> > Example: In a 4 CPU server, single OS, if I change the sql server affinity
> > so that it only uses CPU1 and CPU2, and does not use the 3 & 4 processors,
> > then I would pay only for 2 per processor licenses for SQL Server 2000?
> >
> >
> >
>|||You might want5 to approach an MS sales rep on this. As I understand it, the reasoning why just
cutting down affinity mask doesn't cut it is that everything SQL Server does it does through the
OS...
The licensing terms used to say "numbers of physical processors in the box" (or something to that
effect), but as big boxes came out where you started partitioning the OS, it made more sense to have
it "number of processors that the OS can use", methinks...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:D38F26A9-3F72-4720-B48C-CF581801526D@.microsoft.com...
>I read the Licensing FAQs.. However everywhere it says:
> "If you have made a processor inaccessible to all operating system copies on
> which the SQL Server software is set up to run, you do not need a software
> license for that processor."
> Why would you make a processor inaccessible to OS? Do you mean when you have
> 2 or more OS installed on the same server?
> Can you give an illustration of this scenario for clarification, the FAQ and
> licesing link does not say much?
> Thanks
> "Tibor Karaszi" wrote:
>> No. You need # of processors corresponding to the numbers that the host OS can see and uses.
>> Here's
>> a quote from http://www.microsoft.com/sql/howtobuy/faq.mspx
>> A Processor license gives you the right to install any number of copies of SQL Server 2000 on a
>> single computer, as long as you have purchased Processor licenses for all of the processors on
>> that
>> computer. If you have made a processor inaccessible to all operating system copies on which the
>> SQL
>> Server software is set up to run, you do not need a software license for that processor.
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Pari" <Pari@.discussions.microsoft.com> wrote in message
>> news:627E25D7-42D2-4BBE-9991-C204FA1FD206@.microsoft.com...
>> > In per processor license for Enterprise version of SQL Server 2000, can we
>> > change the affinity mask variable to change the CPU usage and hence restrict
>> > the number of sql server per processor licenses?
>> >
>> > Example: In a 4 CPU server, single OS, if I change the sql server affinity
>> > so that it only uses CPU1 and CPU2, and does not use the 3 & 4 processors,
>> > then I would pay only for 2 per processor licenses for SQL Server 2000?
>> >
>> >
>> >
>>
affinity mask
Hi,
We want to test the setting of affinity mask on out
queries. we have 2 xeon processor machine so it looks like
4 processors....i want to use both the physical
processors and not the logical processor so we are setting
the value of affinity mask to 3. But how can we make sure
that it is using 2 physical processor and not 2 logical
processors of same physical processor...where can we see
this in windows task manager or performance monitor(i
didn't find any option that differentiate between logical
and physical processors)
Thanks
--Harvinderi think you are probably safer disabling HT for now,
some queries may not run well when using two separate
threads on one physical processor, other may run better on
one than two.
i have seen performance problems with index rebuilds with
HT. Until there is a comprehensive analysis of what runs
well in HT and what does not, you are probably better off
not using this feature
>--Original Message--
>Hi,
>We want to test the setting of affinity mask on out
>queries. we have 2 xeon processor machine so it looks
like
>4 processors....i want to use both the physical
>processors and not the logical processor so we are
setting
>the value of affinity mask to 3. But how can we make sure
>that it is using 2 physical processor and not 2 logical
>processors of same physical processor...where can we see
>this in windows task manager or performance monitor(i
>didn't find any option that differentiate between logical
>and physical processors)
>Thanks
>--Harvinder
>.
>|||Assuming the BIOS is written to Intels specifications, it will number the
processors starting with the first logical processor on each physical
processor, so in your case 0,1
Have a look at
http://www.microsoft.com/windows2000/docs/hyperthreading.doc
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"harvinder" <hs@.metratech.com> wrote in message
news:0bd201c3633b$8a754f70$a501280a@.phx.gbl...
Hi,
We want to test the setting of affinity mask on out
queries. we have 2 xeon processor machine so it looks like
4 processors....i want to use both the physical
processors and not the logical processor so we are setting
the value of affinity mask to 3. But how can we make sure
that it is using 2 physical processor and not 2 logical
processors of same physical processor...where can we see
this in windows task manager or performance monitor(i
didn't find any option that differentiate between logical
and physical processors)
Thanks
--Harvinder|||Thanks Jasper..Did the value of 3 looks good to u for
using only both physical processors that are logical 0,1
Thanks
--Harvinder
>--Original Message--
>Assuming the BIOS is written to Intels specifications, it
will number the
>processors starting with the first logical processor on
each physical
>processor, so in your case 0,1
>Have a look at
>http://www.microsoft.com/windows2000/docs/hyperthreading.d
oc
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>"harvinder" <hs@.metratech.com> wrote in message
>news:0bd201c3633b$8a754f70$a501280a@.phx.gbl...
>Hi,
>We want to test the setting of affinity mask on out
>queries. we have 2 xeon processor machine so it looks like
>4 processors....i want to use both the physical
>processors and not the logical processor so we are setting
>the value of affinity mask to 3. But how can we make sure
>that it is using 2 physical processor and not 2 logical
>processors of same physical processor...where can we see
>this in windows task manager or performance monitor(i
>didn't find any option that differentiate between logical
>and physical processors)
>Thanks
>--Harvinder
>
>.
>|||Yeah that's right
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"harvinder" <hs@.metratech.com> wrote in message
news:011801c3635e$7183bb00$a601280a@.phx.gbl...
Thanks Jasper..Did the value of 3 looks good to u for
using only both physical processors that are logical 0,1
Thanks
--Harvinder
>--Original Message--
>Assuming the BIOS is written to Intels specifications, it
will number the
>processors starting with the first logical processor on
each physical
>processor, so in your case 0,1
>Have a look at
>http://www.microsoft.com/windows2000/docs/hyperthreading.d
oc
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>"harvinder" <hs@.metratech.com> wrote in message
>news:0bd201c3633b$8a754f70$a501280a@.phx.gbl...
>Hi,
>We want to test the setting of affinity mask on out
>queries. we have 2 xeon processor machine so it looks like
>4 processors....i want to use both the physical
>processors and not the logical processor so we are setting
>the value of affinity mask to 3. But how can we make sure
>that it is using 2 physical processor and not 2 logical
>processors of same physical processor...where can we see
>this in windows task manager or performance monitor(i
>didn't find any option that differentiate between logical
>and physical processors)
>Thanks
>--Harvinder
>
>.
>
We want to test the setting of affinity mask on out
queries. we have 2 xeon processor machine so it looks like
4 processors....i want to use both the physical
processors and not the logical processor so we are setting
the value of affinity mask to 3. But how can we make sure
that it is using 2 physical processor and not 2 logical
processors of same physical processor...where can we see
this in windows task manager or performance monitor(i
didn't find any option that differentiate between logical
and physical processors)
Thanks
--Harvinderi think you are probably safer disabling HT for now,
some queries may not run well when using two separate
threads on one physical processor, other may run better on
one than two.
i have seen performance problems with index rebuilds with
HT. Until there is a comprehensive analysis of what runs
well in HT and what does not, you are probably better off
not using this feature
>--Original Message--
>Hi,
>We want to test the setting of affinity mask on out
>queries. we have 2 xeon processor machine so it looks
like
>4 processors....i want to use both the physical
>processors and not the logical processor so we are
setting
>the value of affinity mask to 3. But how can we make sure
>that it is using 2 physical processor and not 2 logical
>processors of same physical processor...where can we see
>this in windows task manager or performance monitor(i
>didn't find any option that differentiate between logical
>and physical processors)
>Thanks
>--Harvinder
>.
>|||Assuming the BIOS is written to Intels specifications, it will number the
processors starting with the first logical processor on each physical
processor, so in your case 0,1
Have a look at
http://www.microsoft.com/windows2000/docs/hyperthreading.doc
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"harvinder" <hs@.metratech.com> wrote in message
news:0bd201c3633b$8a754f70$a501280a@.phx.gbl...
Hi,
We want to test the setting of affinity mask on out
queries. we have 2 xeon processor machine so it looks like
4 processors....i want to use both the physical
processors and not the logical processor so we are setting
the value of affinity mask to 3. But how can we make sure
that it is using 2 physical processor and not 2 logical
processors of same physical processor...where can we see
this in windows task manager or performance monitor(i
didn't find any option that differentiate between logical
and physical processors)
Thanks
--Harvinder|||Thanks Jasper..Did the value of 3 looks good to u for
using only both physical processors that are logical 0,1
Thanks
--Harvinder
>--Original Message--
>Assuming the BIOS is written to Intels specifications, it
will number the
>processors starting with the first logical processor on
each physical
>processor, so in your case 0,1
>Have a look at
>http://www.microsoft.com/windows2000/docs/hyperthreading.d
oc
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>"harvinder" <hs@.metratech.com> wrote in message
>news:0bd201c3633b$8a754f70$a501280a@.phx.gbl...
>Hi,
>We want to test the setting of affinity mask on out
>queries. we have 2 xeon processor machine so it looks like
>4 processors....i want to use both the physical
>processors and not the logical processor so we are setting
>the value of affinity mask to 3. But how can we make sure
>that it is using 2 physical processor and not 2 logical
>processors of same physical processor...where can we see
>this in windows task manager or performance monitor(i
>didn't find any option that differentiate between logical
>and physical processors)
>Thanks
>--Harvinder
>
>.
>|||Yeah that's right
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"harvinder" <hs@.metratech.com> wrote in message
news:011801c3635e$7183bb00$a601280a@.phx.gbl...
Thanks Jasper..Did the value of 3 looks good to u for
using only both physical processors that are logical 0,1
Thanks
--Harvinder
>--Original Message--
>Assuming the BIOS is written to Intels specifications, it
will number the
>processors starting with the first logical processor on
each physical
>processor, so in your case 0,1
>Have a look at
>http://www.microsoft.com/windows2000/docs/hyperthreading.d
oc
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>"harvinder" <hs@.metratech.com> wrote in message
>news:0bd201c3633b$8a754f70$a501280a@.phx.gbl...
>Hi,
>We want to test the setting of affinity mask on out
>queries. we have 2 xeon processor machine so it looks like
>4 processors....i want to use both the physical
>processors and not the logical processor so we are setting
>the value of affinity mask to 3. But how can we make sure
>that it is using 2 physical processor and not 2 logical
>processors of same physical processor...where can we see
>this in windows task manager or performance monitor(i
>didn't find any option that differentiate between logical
>and physical processors)
>Thanks
>--Harvinder
>
>.
>
Subscribe to:
Posts (Atom)