How to configure SQL server to use multiple processor

08/02/2007, 21h46

hi,

We have a system with two processors. What settings should we do in sql
server 2000 standard edition to use both the processors. Can anyone suggest?

Thanks
Prem

09/02/2007, 03h25

It will have the potential to use them both by default, you don't need to do
anything.

--
Andrew J. Kelly SQL MVP

"Prem" <Prem_a20@hotmail.com> wrote in message
news:eJxknp8SHHA.1180@TK2MSFTNGP05.phx.gbl...
> hi,
>
> We have a system with two processors. What settings should we do in sql
> server 2000 standard edition to use both the processors. Can anyone
> suggest?
>
> Thanks
> Prem
>
>

09/02/2007, 17h36

Hi,

SQL server in the properties window shows the Parallelism property in which
it is asking to specify the number of processor for use in parallel
execution of queries. What should be the values to be provided for this
setting. Also what should be the Minimum query plan threshold value in
this case.

Hoping some more details on this.

Regards
Prem

"Prem" <Prem_a20@hotmail.com> wrote in message
news:eJxknp8SHHA.1180@TK2MSFTNGP05.phx.gbl...
> hi,
>
> We have a system with two processors. What settings should we do in sql
> server 2000 standard edition to use both the processors. Can anyone
suggest?
>
> Thanks
> Prem
>
>

10/02/2007, 01h06

Change the setting back to "Use all Processors" and leave all other settings
at the defaults. Don't change any settings in SQL Server unless you have a
good reason to and know what it will do.

--
Andrew J. Kelly SQL MVP

"Prem" <Prem_a20@hotmail.com> wrote in message
news:%23o$YbCHTHHA.4076@TK2MSFTNGP05.phx.gbl...
> Hi,
>
> SQL server in the properties window shows the Parallelism property in
> which
> it is asking to specify the number of processor for use in parallel
> execution of queries. What should be the values to be provided for this
> setting. Also what should be the Minimum query plan threshold value in
> this case.
>
> Hoping some more details on this.
>
> Regards
> Prem
>
> "Prem" <Prem_a20@hotmail.com> wrote in message
> news:eJxknp8SHHA.1180@TK2MSFTNGP05.phx.gbl...
>> hi,
>>
>> We have a system with two processors. What settings should we do in sql
>> server 2000 standard edition to use both the processors. Can anyone
> suggest?
>>
>> Thanks
>> Prem
>>
>>
>
>
>

08/02/2007, 21h46	#1
Prem Messages: n/a Hébergeur:	How to configure SQL server to use multiple processor hi, We have a system with two processors. What settings should we do in sql server 2000 standard edition to use both the processors. Can anyone suggest? Thanks Prem

09/02/2007, 03h25	#2
Andrew J. Kelly Messages: n/a Hébergeur:	Re: How to configure SQL server to use multiple processor It will have the potential to use them both by default, you don't need to do anything. -- Andrew J. Kelly SQL MVP "Prem" <Prem_a20@hotmail.com> wrote in message news:eJxknp8SHHA.1180@TK2MSFTNGP05.phx.gbl... > hi, > > We have a system with two processors. What settings should we do in sql > server 2000 standard edition to use both the processors. Can anyone > suggest? > > Thanks > Prem > >

09/02/2007, 17h36	#3
Prem Messages: n/a Hébergeur:	Re: How to configure SQL server to use multiple processor Hi, SQL server in the properties window shows the Parallelism property in which it is asking to specify the number of processor for use in parallel execution of queries. What should be the values to be provided for this setting. Also what should be the Minimum query plan threshold value in this case. Hoping some more details on this. Regards Prem "Prem" <Prem_a20@hotmail.com> wrote in message news:eJxknp8SHHA.1180@TK2MSFTNGP05.phx.gbl... > hi, > > We have a system with two processors. What settings should we do in sql > server 2000 standard edition to use both the processors. Can anyone suggest? > > Thanks > Prem > >

10/02/2007, 01h06	#4
Andrew J. Kelly Messages: n/a Hébergeur:	Re: How to configure SQL server to use multiple processor Change the setting back to "Use all Processors" and leave all other settings at the defaults. Don't change any settings in SQL Server unless you have a good reason to and know what it will do. -- Andrew J. Kelly SQL MVP "Prem" <Prem_a20@hotmail.com> wrote in message news:%23o$YbCHTHHA.4076@TK2MSFTNGP05.phx.gbl... > Hi, > > SQL server in the properties window shows the Parallelism property in > which > it is asking to specify the number of processor for use in parallel > execution of queries. What should be the values to be provided for this > setting. Also what should be the Minimum query plan threshold value in > this case. > > Hoping some more details on this. > > Regards > Prem > > "Prem" <Prem_a20@hotmail.com> wrote in message > news:eJxknp8SHHA.1180@TK2MSFTNGP05.phx.gbl... >> hi, >> >> We have a system with two processors. What settings should we do in sql >> server 2000 standard edition to use both the processors. Can anyone > suggest? >> >> Thanks >> Prem >> >> > > >

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email