I have two SQL2005 databases on the same (Win2003 64-bit) server.
One of them is seldom used, but has a large data set. Every time I query from it, SQL decides to dedicate a few gigs of RAM to the database, and it seems to stay that way from then on until rebooted, cannibalizing RAM from the other more important database.
Is there some way to set a RAM limit per-database?
I don't mind if there is some swapping to disk when I query from the large, seldom-used database. The important thing is that the RAM is reserved for the more important one.