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,
Rick
There'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
>

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
>

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
>

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(sql server 2000), but one needs 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"rick" <rick@.united-directories.com> wrote in message
news:1107187337.272004.39350@.f14g2000cwb.googlegro ups.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(sql server 2000), but one needs 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

As far as I know, there's no way to do this - if it's important enough to
you, then you'd have to install a second server for the high-priority
database. You could mess about with multiple instances and OS-level
priorities, but it would be messy and unreliable.

Simon