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