sql server (alternate): database prioritizing -- sql server (alternate)

database prioritizing

rick
1/31/2005 8:02:17 AM

sql server (alternate):

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

Re: database prioritizing

Simon Hayes
1/31/2005 5:47:07 PM

[quoted text, click to view]

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