View Single Post

   
  #2 (permalink)  
Old 02-29-2008, 06:53 AM
Simon Hayes
 
Posts: n/a
Default Re: database prioritizing


"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


Reply With Quote