Aggregation Processing Use of All Processors Issue

In 2000 when MSAS wanted to create aggs it did a great job without me doing anything of using all available processors pretty darn near or at 100%. In SSAS 2005 I have an 8-processor box (4 dual cores actually) and its only using 1 of the 8. Anyone know how to unlock that? Some property perhaps?

If you split the cube into several partions by using dates, AS2005 will use more than one processor.

Regards

/Thomas

|||

Based on 8 processors I used 8 partitions and it did better, but not much. Then I tried 16 partitions (many programs use 4X threads per processor to maximize parellelization, but if something is well written 1x should be sufficient) and I think it helped - utilization is up to 30 or 40 percent during the cube process part, but the aggregation part is still pretty low - 20-30% overall.

How many procs do you have and what utilization are you seeing during agg processing?

|||

The cubes I work with are small and they run on a four CPU box. By using partitions I was able to reduce the the processing time by 50 percent for one of the cubes.

I have not measured utilization, only processing time.

You will have to consider your I/O system as well and memory setting for SSAS2005. Maybe your low utilization depends on bottlenecks in memory or I/O?

Regards

Thomas

Agents and thread limits from SQL 2005 Distributor machine

Hi DBA's
We have one machime with 4 core processors and 2 GB of RAM. This machine have
3 sql 2005 instances and It's responsable form many replications. More of
them, have pull distribution agent, so we can controll these number over
project growing, but one instance don't.
All distribution agents were configured like "PUSH" and I don't intend to
use "PULL" with these because probably we'll affect subscribers with many
jobs (and thread distribution agents), that the same way, more difficult to
administrate.
How do we see these limits? If so, we can scale to another instance and
controll them!
Plese, if anyone has any article or "better pratical", we appreciate!
Numbers is the focus. We need numbers resgiters like x distrib.exe y logread.
exe and thus for ahead.
Thanks!
Krisnamourt
Message posted via http://www.droptable.com
select logreader=sum(case when program_name like '%logreader%'then 1 else 0
end),distrib=sum(case when program_name like '%'+rtrim(@.@.servername)+'%-%'
then 1 else 0 end) from sys.sysprocesses
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Krisnamourt via droptable.com" <u21487@.uwe> wrote in message
news:7bfea23d5f150@.uwe...
> Hi DBA's
> We have one machime with 4 core processors and 2 GB of RAM. This machine
> have
> 3 sql 2005 instances and It's responsable form many replications. More of
> them, have pull distribution agent, so we can controll these number over
> project growing, but one instance don't.
> All distribution agents were configured like "PUSH" and I don't intend to
> use "PULL" with these because probably we'll affect subscribers with many
> jobs (and thread distribution agents), that the same way, more difficult
> to
> administrate.
> How do we see these limits? If so, we can scale to another instance and
> controll them!
> Plese, if anyone has any article or "better pratical", we appreciate!
> Numbers is the focus. We need numbers resgiters like x distrib.exe y
> logread.
> exe and thus for ahead.
> Thanks!
> Krisnamourt
> --
> Message posted via http://www.droptable.com
>
|||Thanks Hilary,
This article below show us some limitation from sql 2000 about log reader
threads. I did some research and didn't find any limitation about sql 2005.
So, is it true 100 log readers or what is the limitation of this agent?
http://support.microsoft.com/kb/306457/en-us
Hilary Cotter wrote:[vbcol=seagreen]
>select logreader=sum(case when program_name like '%logreader%'then 1 else 0
>end),distrib=sum(case when program_name like '%'+rtrim(@.@.servername)+'%-%'
>then 1 else 0 end) from sys.sysprocesses
>[quoted text clipped - 22 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server-replication/200712/1
|||I am unaware of any such limitation for Standard and Enterprise Editions.
Note that in the SQL 2000 article it refers to the number of simultaneous
agents which could be simultaneously running, its not necessarily a hard
limit as to the number of log reader agents/distribution agents that can be
on your system.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Krisnamourt via droptable.com" <u21487@.uwe> wrote in message
news:7c2e263b3461b@.uwe...
> Thanks Hilary,
> This article below show us some limitation from sql 2000 about log reader
> threads. I did some research and didn't find any limitation about sql
> 2005.
> So, is it true 100 log readers or what is the limitation of this agent?
> http://support.microsoft.com/kb/306457/en-us
> Hilary Cotter wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums.aspx/sql-server-replication/200712/1
>

affinity mask.

SQL 2K Ent SP3a WIN2k Adv SP3.
I'd like to switch off one of the physical processors on a database server,
to
give some resources back to the OS, as the server isn't totally dedicated to
SQL.
The processors are 4 xeons, which Win2k and SQL see as 8 processors. How
can I be sure that I'm stopping sql from using 1 physical processor rather
than two
logical portions.
Hopefully the above makes sense, I effectively only want sql server to use 3
of the
4 physical processors.
TIA.SQL server -> properties -> processor -> In processor control, uncheck on
one of the CPUs.
Richard
"Stressed" <k@.c.co.uk> wrote in message
news:e1aWPEgVDHA.1832@.TK2MSFTNGP09.phx.gbl...
> SQL 2K Ent SP3a WIN2k Adv SP3.
> I'd like to switch off one of the physical processors on a database
server,
> to
> give some resources back to the OS, as the server isn't totally dedicated
to
> SQL.
> The processors are 4 xeons, which Win2k and SQL see as 8 processors. How
> can I be sure that I'm stopping sql from using 1 physical processor rather
> than two
> logical portions.
> Hopefully the above makes sense, I effectively only want sql server to use
3
> of the
> 4 physical processors.
> TIA.
>|||Actually if it is seeing 8 procs due to HT you need to uncheck two of them.
The last 2 might be best.
--
Andrew J. Kelly
SQL Server MVP
"Richard Ding" <dingr@.cleanharbors.com> wrote in message
news:ebhh6JgVDHA.2164@.TK2MSFTNGP09.phx.gbl...
> SQL server -> properties -> processor -> In processor control, uncheck on
> one of the CPUs.
>
> Richard
> "Stressed" <k@.c.co.uk> wrote in message
> news:e1aWPEgVDHA.1832@.TK2MSFTNGP09.phx.gbl...
> > SQL 2K Ent SP3a WIN2k Adv SP3.
> >
> > I'd like to switch off one of the physical processors on a database
> server,
> > to
> > give some resources back to the OS, as the server isn't totally
dedicated
> to
> > SQL.
> >
> > The processors are 4 xeons, which Win2k and SQL see as 8 processors. How
> > can I be sure that I'm stopping sql from using 1 physical processor
rather
> > than two
> > logical portions.
> >
> > Hopefully the above makes sense, I effectively only want sql server to
use
> 3
> > of the
> > 4 physical processors.
> >
> > TIA.
> >
> >
>|||Thanks for taking the time to reply, unfortunately, I'm trying to stop sql
from using a whole processor, not just switching off one part of a logical
one.
"Richard Ding" <dingr@.cleanharbors.com> wrote in message
news:ebhh6JgVDHA.2164@.TK2MSFTNGP09.phx.gbl...
> SQL server -> properties -> processor -> In processor control, uncheck on
> one of the CPUs.
>
> Richard
> "Stressed" <k@.c.co.uk> wrote in message
> news:e1aWPEgVDHA.1832@.TK2MSFTNGP09.phx.gbl...
> > SQL 2K Ent SP3a WIN2k Adv SP3.
> >
> > I'd like to switch off one of the physical processors on a database
> server,
> > to
> > give some resources back to the OS, as the server isn't totally
dedicated
> to
> > SQL.
> >
> > The processors are 4 xeons, which Win2k and SQL see as 8 processors. How
> > can I be sure that I'm stopping sql from using 1 physical processor
rather
> > than two
> > logical portions.
> >
> > Hopefully the above makes sense, I effectively only want sql server to
use
> 3
> > of the
> > 4 physical processors.
> >
> > TIA.
> >
> >
>|||That is why I suggested unchecking two of them<g>. One for the logical and
one for the physical.
--
Andrew J. Kelly
SQL Server MVP
"Stressed" <k@.c.co.uk> wrote in message
news:uePEppgVDHA.1600@.TK2MSFTNGP09.phx.gbl...
> Thanks for taking the time to reply, unfortunately, I'm trying to stop sql
> from using a whole processor, not just switching off one part of a logical
> one.
>
>
> "Richard Ding" <dingr@.cleanharbors.com> wrote in message
> news:ebhh6JgVDHA.2164@.TK2MSFTNGP09.phx.gbl...
> > SQL server -> properties -> processor -> In processor control, uncheck
on
> > one of the CPUs.
> >
> >
> >
> > Richard
> >
> > "Stressed" <k@.c.co.uk> wrote in message
> > news:e1aWPEgVDHA.1832@.TK2MSFTNGP09.phx.gbl...
> > > SQL 2K Ent SP3a WIN2k Adv SP3.
> > >
> > > I'd like to switch off one of the physical processors on a database
> > server,
> > > to
> > > give some resources back to the OS, as the server isn't totally
> dedicated
> > to
> > > SQL.
> > >
> > > The processors are 4 xeons, which Win2k and SQL see as 8 processors.
How
> > > can I be sure that I'm stopping sql from using 1 physical processor
> rather
> > > than two
> > > logical portions.
> > >
> > > Hopefully the above makes sense, I effectively only want sql server to
> use
> > 3
> > > of the
> > > 4 physical processors.
> > >
> > > TIA.
> > >
> > >
> >
> >
>|||Andrew,
are the logical processors belonging to a physical processor always listed
together, i.e., 0,1 are physical processor 1; 2,3 PP 2, etc? I was thinking
it of being this way, but do not know it as a fact.
Quentin
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eZ8ycbhVDHA.2212@.TK2MSFTNGP12.phx.gbl...
> That is why I suggested unchecking two of them<g>. One for the logical
and
> one for the physical.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Stressed" <k@.c.co.uk> wrote in message
> news:uePEppgVDHA.1600@.TK2MSFTNGP09.phx.gbl...
> > Thanks for taking the time to reply, unfortunately, I'm trying to stop
sql
> > from using a whole processor, not just switching off one part of a
logical
> > one.
> >
> >
> >
> >
> > "Richard Ding" <dingr@.cleanharbors.com> wrote in message
> > news:ebhh6JgVDHA.2164@.TK2MSFTNGP09.phx.gbl...
> > > SQL server -> properties -> processor -> In processor control, uncheck
> on
> > > one of the CPUs.
> > >
> > >
> > >
> > > Richard
> > >
> > > "Stressed" <k@.c.co.uk> wrote in message
> > > news:e1aWPEgVDHA.1832@.TK2MSFTNGP09.phx.gbl...
> > > > SQL 2K Ent SP3a WIN2k Adv SP3.
> > > >
> > > > I'd like to switch off one of the physical processors on a database
> > > server,
> > > > to
> > > > give some resources back to the OS, as the server isn't totally
> > dedicated
> > > to
> > > > SQL.
> > > >
> > > > The processors are 4 xeons, which Win2k and SQL see as 8 processors.
> How
> > > > can I be sure that I'm stopping sql from using 1 physical processor
> > rather
> > > > than two
> > > > logical portions.
> > > >
> > > > Hopefully the above makes sense, I effectively only want sql server
to
> > use
> > > 3
> > > > of the
> > > > 4 physical processors.
> > > >
> > > > TIA.
> > > >
> > > >
> > >
> > >
> >
> >
>|||I have yet to see it documented myself but that is how I understand it to
be.
--
Andrew J. Kelly
SQL Server MVP
"Quentin Ran" <ab@.who.com> wrote in message
news:Oah2M1hVDHA.2268@.TK2MSFTNGP11.phx.gbl...
> Andrew,
> are the logical processors belonging to a physical processor always listed
> together, i.e., 0,1 are physical processor 1; 2,3 PP 2, etc? I was
thinking
> it of being this way, but do not know it as a fact.
> Quentin
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:eZ8ycbhVDHA.2212@.TK2MSFTNGP12.phx.gbl...
> > That is why I suggested unchecking two of them<g>. One for the logical
> and
> > one for the physical.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Stressed" <k@.c.co.uk> wrote in message
> > news:uePEppgVDHA.1600@.TK2MSFTNGP09.phx.gbl...
> > > Thanks for taking the time to reply, unfortunately, I'm trying to stop
> sql
> > > from using a whole processor, not just switching off one part of a
> logical
> > > one.
> > >
> > >
> > >
> > >
> > > "Richard Ding" <dingr@.cleanharbors.com> wrote in message
> > > news:ebhh6JgVDHA.2164@.TK2MSFTNGP09.phx.gbl...
> > > > SQL server -> properties -> processor -> In processor control,
uncheck
> > on
> > > > one of the CPUs.
> > > >
> > > >
> > > >
> > > > Richard
> > > >
> > > > "Stressed" <k@.c.co.uk> wrote in message
> > > > news:e1aWPEgVDHA.1832@.TK2MSFTNGP09.phx.gbl...
> > > > > SQL 2K Ent SP3a WIN2k Adv SP3.
> > > > >
> > > > > I'd like to switch off one of the physical processors on a
database
> > > > server,
> > > > > to
> > > > > give some resources back to the OS, as the server isn't totally
> > > dedicated
> > > > to
> > > > > SQL.
> > > > >
> > > > > The processors are 4 xeons, which Win2k and SQL see as 8
processors.
> > How
> > > > > can I be sure that I'm stopping sql from using 1 physical
processor
> > > rather
> > > > > than two
> > > > > logical portions.
> > > > >
> > > > > Hopefully the above makes sense, I effectively only want sql
server
> to
> > > use
> > > > 3
> > > > > of the
> > > > > 4 physical processors.
> > > > >
> > > > > TIA.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Yes I believe 0 is the first physical processor and 1 will be the 1st
Logical processor and they go together. 2 is the second physical processor
etc.
--
Andrew J. Kelly
SQL Server MVP
"Stressed" <k@.c.co.uk> wrote in message
news:uVxhB4mVDHA.3232@.tk2msftngp13.phx.gbl...
> Thanks for all the replies.
> My question, although badly worded was the same point as made
> by Quentin, as to whether 0 & 2 constituted a physical processor
> to windows or whether 0 & 1 constituted a physical processor.
> I stumbled across a web page showing the architecture for this a
> while ago and now I need to reference it, can't find it anywhere.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uvUaI5jVDHA.1280@.tk2msftngp13.phx.gbl...
> > I have yet to see it documented myself but that is how I understand it
to
> > be.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Quentin Ran" <ab@.who.com> wrote in message
> > news:Oah2M1hVDHA.2268@.TK2MSFTNGP11.phx.gbl...
> > > Andrew,
> > >
> > > are the logical processors belonging to a physical processor always
> listed
> > > together, i.e., 0,1 are physical processor 1; 2,3 PP 2, etc? I was
> > thinking
> > > it of being this way, but do not know it as a fact.
> > >
> > > Quentin
> > >
> > >
> > > "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> > > news:eZ8ycbhVDHA.2212@.TK2MSFTNGP12.phx.gbl...
> > > > That is why I suggested unchecking two of them<g>. One for the
> logical
> > > and
> > > > one for the physical.
> > > >
> > > > --
> > > >
> > > > Andrew J. Kelly
> > > > SQL Server MVP
> > > >
> > > >
> > > > "Stressed" <k@.c.co.uk> wrote in message
> > > > news:uePEppgVDHA.1600@.TK2MSFTNGP09.phx.gbl...
> > > > > Thanks for taking the time to reply, unfortunately, I'm trying to
> stop
> > > sql
> > > > > from using a whole processor, not just switching off one part of a
> > > logical
> > > > > one.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > "Richard Ding" <dingr@.cleanharbors.com> wrote in message
> > > > > news:ebhh6JgVDHA.2164@.TK2MSFTNGP09.phx.gbl...
> > > > > > SQL server -> properties -> processor -> In processor control,
> > uncheck
> > > > on
> > > > > > one of the CPUs.
> > > > > >
> > > > > >
> > > > > >
> > > > > > Richard
> > > > > >
> > > > > > "Stressed" <k@.c.co.uk> wrote in message
> > > > > > news:e1aWPEgVDHA.1832@.TK2MSFTNGP09.phx.gbl...
> > > > > > > SQL 2K Ent SP3a WIN2k Adv SP3.
> > > > > > >
> > > > > > > I'd like to switch off one of the physical processors on a
> > database
> > > > > > server,
> > > > > > > to
> > > > > > > give some resources back to the OS, as the server isn't
totally
> > > > > dedicated
> > > > > > to
> > > > > > > SQL.
> > > > > > >
> > > > > > > The processors are 4 xeons, which Win2k and SQL see as 8
> > processors.
> > > > How
> > > > > > > can I be sure that I'm stopping sql from using 1 physical
> > processor
> > > > > rather
> > > > > > > than two
> > > > > > > logical portions.
> > > > > > >
> > > > > > > Hopefully the above makes sense, I effectively only want sql
> > server
> > > to
> > > > > use
> > > > > > 3
> > > > > > > of the
> > > > > > > 4 physical processors.
> > > > > > >
> > > > > > > TIA.
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Our sysadmin told me that it is in the BIOS.
"Stressed" <k@.c.co.uk> wrote in message
news:uVxhB4mVDHA.3232@.tk2msftngp13.phx.gbl...
> Thanks for all the replies.
> My question, although badly worded was the same point as made
> by Quentin, as to whether 0 & 2 constituted a physical processor
> to windows or whether 0 & 1 constituted a physical processor.
> I stumbled across a web page showing the architecture for this a
> while ago and now I need to reference it, can't find it anywhere.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uvUaI5jVDHA.1280@.tk2msftngp13.phx.gbl...
> > I have yet to see it documented myself but that is how I understand it
to
> > be.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Quentin Ran" <ab@.who.com> wrote in message
> > news:Oah2M1hVDHA.2268@.TK2MSFTNGP11.phx.gbl...
> > > Andrew,
> > >
> > > are the logical processors belonging to a physical processor always
> listed
> > > together, i.e., 0,1 are physical processor 1; 2,3 PP 2, etc? I was
> > thinking
> > > it of being this way, but do not know it as a fact.
> > >
> > > Quentin
> > >
> > >
> > > "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> > > news:eZ8ycbhVDHA.2212@.TK2MSFTNGP12.phx.gbl...
> > > > That is why I suggested unchecking two of them<g>. One for the
> logical
> > > and
> > > > one for the physical.
> > > >
> > > > --
> > > >
> > > > Andrew J. Kelly
> > > > SQL Server MVP
> > > >
> > > >
> > > > "Stressed" <k@.c.co.uk> wrote in message
> > > > news:uePEppgVDHA.1600@.TK2MSFTNGP09.phx.gbl...
> > > > > Thanks for taking the time to reply, unfortunately, I'm trying to
> stop
> > > sql
> > > > > from using a whole processor, not just switching off one part of a
> > > logical
> > > > > one.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > "Richard Ding" <dingr@.cleanharbors.com> wrote in message
> > > > > news:ebhh6JgVDHA.2164@.TK2MSFTNGP09.phx.gbl...
> > > > > > SQL server -> properties -> processor -> In processor control,
> > uncheck
> > > > on
> > > > > > one of the CPUs.
> > > > > >
> > > > > >
> > > > > >
> > > > > > Richard
> > > > > >
> > > > > > "Stressed" <k@.c.co.uk> wrote in message
> > > > > > news:e1aWPEgVDHA.1832@.TK2MSFTNGP09.phx.gbl...
> > > > > > > SQL 2K Ent SP3a WIN2k Adv SP3.
> > > > > > >
> > > > > > > I'd like to switch off one of the physical processors on a
> > database
> > > > > > server,
> > > > > > > to
> > > > > > > give some resources back to the OS, as the server isn't
totally
> > > > > dedicated
> > > > > > to
> > > > > > > SQL.
> > > > > > >
> > > > > > > The processors are 4 xeons, which Win2k and SQL see as 8
> > processors.
> > > > How
> > > > > > > can I be sure that I'm stopping sql from using 1 physical
> > processor
> > > > > rather
> > > > > > > than two
> > > > > > > logical portions.
> > > > > > >
> > > > > > > Hopefully the above makes sense, I effectively only want sql
> > server
> > > to
> > > > > use
> > > > > > 3
> > > > > > > of the
> > > > > > > 4 physical processors.
> > > > > > >
> > > > > > > TIA.
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

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