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