Processor Utilization

Hi
I am running SQL Server 2000 on a 2 processor system (Windows 2003
Standard). I regularily run large queries. When I run the queries the CPU
utilization is consitantly around 11%.
It appears as if something is limiting SQL Server to 11% CPU per
process/query. I have verified that its not I/O bound.
The Processor properties are set as follows:
- All 2 processors are checked in Processor Control
- "Maximum worker threads" is set to 255
- "Boost SQL Server priority on Windows" is not checked
- "Use Windows NT fibres" is checked
- "Use all available processors" is checked
Why is the CPU not fully utilized? What does "Boost SQL Server priority on
Windows" do?
Any assistance would be greatly appreciated
ThanksHi
You may want to check the boost priority option and not use fibres (as
fibres can cause other problems). You could also try using the MAXDOP hint to
only use one processor.
Monitor context switches to see if there is an excessive number before
considering using fibres. Ken Hendersons book The Gurus Guide to SQL Server
Architecture and Internals ISBN 0201700476 has a good section on this.
John
"Macisu" wrote:
> Hi
> I am running SQL Server 2000 on a 2 processor system (Windows 2003
> Standard). I regularily run large queries. When I run the queries the CPU
> utilization is consitantly around 11%.
> It appears as if something is limiting SQL Server to 11% CPU per
> process/query. I have verified that its not I/O bound.
> The Processor properties are set as follows:
> - All 2 processors are checked in Processor Control
> - "Maximum worker threads" is set to 255
> - "Boost SQL Server priority on Windows" is not checked
> - "Use Windows NT fibres" is checked
> - "Use all available processors" is checked
> Why is the CPU not fully utilized? What does "Boost SQL Server priority on
> Windows" do?
> Any assistance would be greatly appreciated
> Thanks

Processor question

Hello Everyone,
When a certain platform let it be standard or enterprise, the processor
limitation on Standard is currently 4. Does that mean 4 physical processors
or if you had 2 physical processors with hyper threading which in Windows
would give you 4? I a bit confused about that.
Thank you
Alex Anderson
Alex Anderson wrote:
> Hello Everyone,
> When a certain platform let it be standard or enterprise, the
> processor limitation on Standard is currently 4. Does that mean 4
> physical processors or if you had 2 physical processors with hyper
> threading which in Windows would give you 4? I a bit confused about
> that.
> Thank you
> Alex Anderson
Physical. In fact, it's my understanding that dual-core processors are
going to be treated as a single processor according to the Microsoft
Licensing. SO you need to license the physical CPUs in the box (for CPU
licensing). As always, check with Microsoft Licensing for any licensing
issues and questions.
David Gugick - SQL Server MVP
Quest Software
|||David is correct. Multi-core and hyperthreaded processors count as a single
processor for licensing and edition processor limits. This makes MS
licensing highly competitive and much simpler than "the other guys".
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:ebZRcptIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> Alex Anderson wrote:
> Physical. In fact, it's my understanding that dual-core processors are
> going to be treated as a single processor according to the Microsoft
> Licensing. SO you need to license the physical CPUs in the box (for CPU
> licensing). As always, check with Microsoft Licensing for any licensing
> issues and questions.
> --
> David Gugick - SQL Server MVP
> Quest Software
>
|||Thank you both for the information. You know Microsoft, you never know when
the wool will be pulled over our eyes.
Thank you
Alex Anderson
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:eJ1sIGuIGHA.1288@.TK2MSFTNGP09.phx.gbl...
> David is correct. Multi-core and hyperthreaded processors count as a
> single processor for licensing and edition processor limits. This makes
> MS licensing highly competitive and much simpler than "the other guys".
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "David Gugick" <david.gugick-nospam@.quest.com> wrote in message
> news:ebZRcptIGHA.1760@.TK2MSFTNGP10.phx.gbl...
>
|||Microsoft is often confusing, but most of the time they avoid active
stupidity. Remember, MS is a very large organization and sometimes it takes
a while for feedback to trickle through. This time, they appear to have
gotten it right.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Alex Anderson" <AAnderson@.Murrieta.org> wrote in message
news:O0Cuq31IGHA.2708@.tk2msftngp13.phx.gbl...
> Thank you both for the information. You know Microsoft, you never know
> when the wool will be pulled over our eyes.
> Thank you
> Alex Anderson
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:eJ1sIGuIGHA.1288@.TK2MSFTNGP09.phx.gbl...
>

Processor question

Hello Everyone,
When a certain platform let it be standard or enterprise, the processor
limitation on Standard is currently 4. Does that mean 4 physical processors
or if you had 2 physical processors with hyper threading which in Windows
would give you 4? I a bit confused about that.
Thank you
Alex AndersonAlex Anderson wrote:
> Hello Everyone,
> When a certain platform let it be standard or enterprise, the
> processor limitation on Standard is currently 4. Does that mean 4
> physical processors or if you had 2 physical processors with hyper
> threading which in Windows would give you 4? I a bit confused about
> that.
> Thank you
> Alex Anderson
Physical. In fact, it's my understanding that dual-core processors are
going to be treated as a single processor according to the Microsoft
Licensing. SO you need to license the physical CPUs in the box (for CPU
licensing). As always, check with Microsoft Licensing for any licensing
issues and questions.
--
David Gugick - SQL Server MVP
Quest Software|||David is correct. Multi-core and hyperthreaded processors count as a single
processor for licensing and edition processor limits. This makes MS
licensing highly competitive and much simpler than "the other guys".
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:ebZRcptIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> Alex Anderson wrote:
>> Hello Everyone,
>> When a certain platform let it be standard or enterprise, the
>> processor limitation on Standard is currently 4. Does that mean 4
>> physical processors or if you had 2 physical processors with hyper
>> threading which in Windows would give you 4? I a bit confused about
>> that.
>> Thank you
>> Alex Anderson
> Physical. In fact, it's my understanding that dual-core processors are
> going to be treated as a single processor according to the Microsoft
> Licensing. SO you need to license the physical CPUs in the box (for CPU
> licensing). As always, check with Microsoft Licensing for any licensing
> issues and questions.
> --
> David Gugick - SQL Server MVP
> Quest Software
>|||Thank you both for the information. You know Microsoft, you never know when
the wool will be pulled over our eyes.
Thank you
Alex Anderson
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:eJ1sIGuIGHA.1288@.TK2MSFTNGP09.phx.gbl...
> David is correct. Multi-core and hyperthreaded processors count as a
> single processor for licensing and edition processor limits. This makes
> MS licensing highly competitive and much simpler than "the other guys".
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "David Gugick" <david.gugick-nospam@.quest.com> wrote in message
> news:ebZRcptIGHA.1760@.TK2MSFTNGP10.phx.gbl...
>> Alex Anderson wrote:
>> Hello Everyone,
>> When a certain platform let it be standard or enterprise, the
>> processor limitation on Standard is currently 4. Does that mean 4
>> physical processors or if you had 2 physical processors with hyper
>> threading which in Windows would give you 4? I a bit confused about
>> that.
>> Thank you
>> Alex Anderson
>> Physical. In fact, it's my understanding that dual-core processors are
>> going to be treated as a single processor according to the Microsoft
>> Licensing. SO you need to license the physical CPUs in the box (for CPU
>> licensing). As always, check with Microsoft Licensing for any licensing
>> issues and questions.
>> --
>> David Gugick - SQL Server MVP
>> Quest Software
>|||Microsoft is often confusing, but most of the time they avoid active
stupidity. Remember, MS is a very large organization and sometimes it takes
a while for feedback to trickle through. This time, they appear to have
gotten it right.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Alex Anderson" <AAnderson@.Murrieta.org> wrote in message
news:O0Cuq31IGHA.2708@.tk2msftngp13.phx.gbl...
> Thank you both for the information. You know Microsoft, you never know
> when the wool will be pulled over our eyes.
> Thank you
> Alex Anderson
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:eJ1sIGuIGHA.1288@.TK2MSFTNGP09.phx.gbl...
>> David is correct. Multi-core and hyperthreaded processors count as a
>> single processor for licensing and edition processor limits. This makes
>> MS licensing highly competitive and much simpler than "the other guys".
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>>
>> "David Gugick" <david.gugick-nospam@.quest.com> wrote in message
>> news:ebZRcptIGHA.1760@.TK2MSFTNGP10.phx.gbl...
>> Alex Anderson wrote:
>> Hello Everyone,
>> When a certain platform let it be standard or enterprise, the
>> processor limitation on Standard is currently 4. Does that mean 4
>> physical processors or if you had 2 physical processors with hyper
>> threading which in Windows would give you 4? I a bit confused about
>> that.
>> Thank you
>> Alex Anderson
>> Physical. In fact, it's my understanding that dual-core processors are
>> going to be treated as a single processor according to the Microsoft
>> Licensing. SO you need to license the physical CPUs in the box (for CPU
>> licensing). As always, check with Microsoft Licensing for any licensing
>> issues and questions.
>> --
>> David Gugick - SQL Server MVP
>> Quest Software
>>
>

Processor question

Hello Everyone,
When a certain platform let it be standard or enterprise, the processor
limitation on Standard is currently 4. Does that mean 4 physical processors
or if you had 2 physical processors with hyper threading which in Windows
would give you 4? I a bit confused about that.
Thank you
Alex AndersonAlex Anderson wrote:
> Hello Everyone,
> When a certain platform let it be standard or enterprise, the
> processor limitation on Standard is currently 4. Does that mean 4
> physical processors or if you had 2 physical processors with hyper
> threading which in Windows would give you 4? I a bit confused about
> that.
> Thank you
> Alex Anderson
Physical. In fact, it's my understanding that dual-core processors are
going to be treated as a single processor according to the Microsoft
Licensing. SO you need to license the physical CPUs in the box (for CPU
licensing). As always, check with Microsoft Licensing for any licensing
issues and questions.
David Gugick - SQL Server MVP
Quest Software|||David is correct. Multi-core and hyperthreaded processors count as a single
processor for licensing and edition processor limits. This makes MS
licensing highly competitive and much simpler than "the other guys".
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:ebZRcptIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> Alex Anderson wrote:
> Physical. In fact, it's my understanding that dual-core processors are
> going to be treated as a single processor according to the Microsoft
> Licensing. SO you need to license the physical CPUs in the box (for CPU
> licensing). As always, check with Microsoft Licensing for any licensing
> issues and questions.
> --
> David Gugick - SQL Server MVP
> Quest Software
>|||Thank you both for the information. You know Microsoft, you never know when
the wool will be pulled over our eyes.
Thank you
Alex Anderson
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:eJ1sIGuIGHA.1288@.TK2MSFTNGP09.phx.gbl...
> David is correct. Multi-core and hyperthreaded processors count as a
> single processor for licensing and edition processor limits. This makes
> MS licensing highly competitive and much simpler than "the other guys".
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "David Gugick" <david.gugick-nospam@.quest.com> wrote in message
> news:ebZRcptIGHA.1760@.TK2MSFTNGP10.phx.gbl...
>|||Microsoft is often confusing, but most of the time they avoid active
stupidity. Remember, MS is a very large organization and sometimes it takes
a while for feedback to trickle through. This time, they appear to have
gotten it right.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Alex Anderson" <AAnderson@.Murrieta.org> wrote in message
news:O0Cuq31IGHA.2708@.tk2msftngp13.phx.gbl...
> Thank you both for the information. You know Microsoft, you never know
> when the wool will be pulled over our eyes.
> Thank you
> Alex Anderson
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:eJ1sIGuIGHA.1288@.TK2MSFTNGP09.phx.gbl...
>

processor license

hello
i've got an sql 2005 standard server with a processor license. where can i
set, change or configure this license typ in sql 2005?
thanks
michael> i've got an sql 2005 standard server with a processor license. where can i
> set, change or configure this license typ in sql 2005?
You don't need to configure licensing. The license is a legal agreement
that you are obligated to follow as described in the EULA.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Michael Gloor" <michael.gloor@.bluecare.ch> wrote in message
news:%23kt6W3FWIHA.3940@.TK2MSFTNGP05.phx.gbl...
> hello
> i've got an sql 2005 standard server with a processor license. where can i
> set, change or configure this license typ in sql 2005?
> thanks
> michael
>
>