Is there a setting somewhere that tells SQL how many processes to provide to
each database?

What do you mean by processes?

--
Andrew J. Kelly SQL MVP

<msnews.microsoft.com> wrote in message
news:OSc0r0$vHHA.736@TK2MSFTNGP06.phx.gbl...
> Is there a setting somewhere that tells SQL how many processes to provide
> to each database?
>
>

The box has 8 processers and I would like to assigin # of Proc to each DB
can I do that?

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:%23prt4%23$vHHA.4592@TK2MSFTNGP05.phx.gbl...
> What do you mean by processes?
>
> --
> Andrew J. Kelly SQL MVP
>
> <msnews.microsoft.com> wrote in message
> news:OSc0r0$vHHA.736@TK2MSFTNGP06.phx.gbl...
>> Is there a setting somewhere that tells SQL how many processes to provide
>> to each database?
>>
>>
>
>

I don't think you have the ability to explicilty assign how many threads a
CPU runs. And I don't think you need to, SQL server is good at managing the
work load on multiple processors.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005


"msnews.microsoft.com" wrote:

> The box has 8 processers and I would like to assigin # of Proc to each DB
> can I do that?
>
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> news:%23prt4%23$vHHA.4592@TK2MSFTNGP05.phx.gbl...
> > What do you mean by processes?
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> > <msnews.microsoft.com> wrote in message
> > news:OSc0r0$vHHA.736@TK2MSFTNGP06.phx.gbl...
> >> Is there a setting somewhere that tells SQL how many processes to provide
> >> to each database?
> >>
> >>
> >
> >
>
>
>

SQL Server is effectively 1 process running in Windows with n threads inside
the process. I won't go into the what's and why's of threads/processes; this
is already very well documented by others on technet.microsoft.com/sql so do
check out the whitepapers there.

If you have 8 CPUs, SQL Server will use all 8 by default. You can "instruct"
SQL Server to use only specific CPUs by changing the affinity mask setting
but this is rarely required. You can also change the number of threads that
run inside SQL Server to service queries/tasks by changing the max worker
threads setting but again, this is VERY rarely necessary.

Strongly encourage you to not change either of these unless you know exactly
what you're doing and are well aware of the potential repercussions. Don't
pickup random suggestions that you've googled. You may end up crippling your
server's performance.



joe.

<msnews.microsoft.com> wrote in message
news:eNixXIAwHHA.4916@TK2MSFTNGP04.phx.gbl...
> The box has 8 processers and I would like to assigin # of Proc to each DB
> can I do that?
>
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> news:%23prt4%23$vHHA.4592@TK2MSFTNGP05.phx.gbl...
>> What do you mean by processes?
>>
>> --
>> Andrew J. Kelly SQL MVP
>>
>> <msnews.microsoft.com> wrote in message
>> news:OSc0r0$vHHA.736@TK2MSFTNGP06.phx.gbl...
>>> Is there a setting somewhere that tells SQL how many processes to
>>> provide to each database?
>>>
>>>
>>
>>
>
>

If you want to control what processor will be use for a specific database,
you'll have to control this by multiple instances, and then, separete the
databses and processors by instance.


Emanuel


"Joe Yong" wrote:

> SQL Server is effectively 1 process running in Windows with n threads inside
> the process. I won't go into the what's and why's of threads/processes; this
> is already very well documented by others on technet.microsoft.com/sql so do
> check out the whitepapers there.
>
> If you have 8 CPUs, SQL Server will use all 8 by default. You can "instruct"
> SQL Server to use only specific CPUs by changing the affinity mask setting
> but this is rarely required. You can also change the number of threads that
> run inside SQL Server to service queries/tasks by changing the max worker
> threads setting but again, this is VERY rarely necessary.
>
> Strongly encourage you to not change either of these unless you know exactly
> what you're doing and are well aware of the potential repercussions. Don't
> pickup random suggestions that you've googled. You may end up crippling your
> server's performance.
>
>
>
> joe.
>
> <msnews.microsoft.com> wrote in message
> news:eNixXIAwHHA.4916@TK2MSFTNGP04.phx.gbl...
> > The box has 8 processers and I would like to assigin # of Proc to each DB
> > can I do that?
> >
> > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> > news:%23prt4%23$vHHA.4592@TK2MSFTNGP05.phx.gbl...
> >> What do you mean by processes?
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >>
> >> <msnews.microsoft.com> wrote in message
> >> news:OSc0r0$vHHA.736@TK2MSFTNGP06.phx.gbl...
> >>> Is there a setting somewhere that tells SQL how many processes to
> >>> provide to each database?
> >>>
> >>>
> >>
> >>
> >
> >
>
>
>