database prioritizing

I have a quick question. I have not been able to find any information on
database prioritizing. I have several databases on a single server, but one
need to have processing priority over the others. Is it possible? If anyon
e
has or knows of somewhere I can read up on this subject it would be
appreciated
Thanks,
RickThere's no such feature in SQL Server. Generally, you try to tweak the regul
ar stuff to get it as
efficient as possible.
If you need to do some prioritizing, you can opt for several instances on on
e machine. For an
instance, you can define processor affinity, memory etc.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Rick" <Rick@.discussions.microsoft.com> wrote in message
news:E139B520-FAA9-463F-A99D-10BD95646085@.microsoft.com...
>I have a quick question. I have not been able to find any information on
> database prioritizing. I have several databases on a single server, but o
ne
> need to have processing priority over the others. Is it possible? If any
one
> has or knows of somewhere I can read up on this subject it would be
> appreciated
> Thanks,
> Rick
>