Changing SQL server 2000's CPU Utilization for each databases

Hi ,
Know that SQL server 2000 will be able to utilise mutiple CPUs if there are
but is it possible for me to change the settings such that each databases
will be serviced by certain CPUs ?
could anyone show me how ? and will this improve performance instead of
letting SQL server manages its own CPUS utilization
tks & rdgsThere is no way to effectively do that unless you place each db in it's own
instance and affinitize the cpus to each instance. It's almost never worth
doing something like that.
--
Andrew J. Kelly SQL MVP
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:1481E81C-D33C-4C20-9448-3EF3D1216285@.microsoft.com...
> Hi ,
> Know that SQL server 2000 will be able to utilise mutiple CPUs if there
> are
> but is it possible for me to change the settings such that each databases
> will be serviced by certain CPUs ?
> could anyone show me how ? and will this improve performance instead of
> letting SQL server manages its own CPUS utilization
> tks & rdgs|||Hi Andrew ,
assuming that i have multiple instances(e.g instance A , instance B) and i
have 5 CPUS. how do i get instance A to be serviced by 3 CPUS and instance B
serviced by 2 CPUS ?
actually , from my vendor , i knew that they have changed the cpu
utilization but no difference performance-wise , i am just curious how they
did it
rdgs
"Andrew J. Kelly" wrote:
> There is no way to effectively do that unless you place each db in it's own
> instance and affinitize the cpus to each instance. It's almost never worth
> doing something like that.
> --
> Andrew J. Kelly SQL MVP
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:1481E81C-D33C-4C20-9448-3EF3D1216285@.microsoft.com...
> > Hi ,
> >
> > Know that SQL server 2000 will be able to utilise mutiple CPUs if there
> > are
> > but is it possible for me to change the settings such that each databases
> > will be serviced by certain CPUs ?
> >
> > could anyone show me how ? and will this improve performance instead of
> > letting SQL server manages its own CPUS utilization
> >
> > tks & rdgs
>
>|||maxzsim wrote:
> Hi Andrew ,
> assuming that i have multiple instances(e.g instance A , instance B)
> and i have 5 CPUS. how do i get instance A to be serviced by 3 CPUS
> and instance B serviced by 2 CPUS ?
> actually , from my vendor , i knew that they have changed the cpu
> utilization but no difference performance-wise , i am just curious
> how they did it
>
You can just check off the processors you want to use on the Processor
tab in SQL EM. Or you can use sp_configure.
--
David Gugick
Imceda Software
www.imceda.com|||tks , i found it at SQL EM
"David Gugick" wrote:
> maxzsim wrote:
> > Hi Andrew ,
> >
> > assuming that i have multiple instances(e.g instance A , instance B)
> > and i have 5 CPUS. how do i get instance A to be serviced by 3 CPUS
> > and instance B serviced by 2 CPUS ?
> >
> > actually , from my vendor , i knew that they have changed the cpu
> > utilization but no difference performance-wise , i am just curious
> > how they did it
> >
> You can just check off the processors you want to use on the Processor
> tab in SQL EM. Or you can use sp_configure.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>