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 anyone
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 regular stuff to get it as
efficient as possible.
If you need to do some prioritizing, you can opt for several instances on one 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 one
> need to have processing priority over the others. Is it possible? If anyone
> has or knows of somewhere I can read up on this subject it would be
> appreciated
> Thanks,
> Rick
>