processor delegation

Hi,
I know it's possible in SQL Server 2K to delegate which
processors for the engine to use, but is it possible to
delegate which databases or even which tables can use
which processor in a multi-processor server?
Thanks,
BrentOnly if you use multiple instances and use the processor affinity to
delegate certain cpu's for each instance. You could place each db in it's
own instance and then use the affinity as such. But unless you have more
than 8 procs I wouldn't recommend doing this without a really good reason.
It is usually better to let sql server decide how to use the resources.
--
Andrew J. Kelly
SQL Server MVP
"Brent" <brent.sodtke@.nucomm.net> wrote in message
news:0e3e01c34627$da6b4d80$a301280a@.phx.gbl...
> Hi,
> I know it's possible in SQL Server 2K to delegate which
> processors for the engine to use, but is it possible to
> delegate which databases or even which tables can use
> which processor in a multi-processor server?
> Thanks,
> Brent|||Brent,
Nope. If you really want it and have a good case for it, then send your
reasoning to sqlwish@.microsoft.com
> I know it's possible in SQL Server 2K to delegate which
> processors for the engine to use, but is it possible to
> delegate which databases or even which tables can use
> which processor in a multi-processor server?
> Thanks,
> Brent
>
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faqsql