Friday, February 17, 2012

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

No comments:

Post a Comment