By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,295 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

Database (cache) memory allocation

P: 1
Do you know how to set up a memory allocation for each database only not entirely for all the databases in a server using MS SQL? the plan is to configure a database to consume up to 500 mb (cache) memory only. i've found some links that allows you to change the server memory allocation however all databases inside the same server will be affected as well. There are other application databases existing inside the server which requires huge amount of memory.

Hmmm.... Quite tricky, huh?! Im a programmer not a dba, that's why your juice of intellect is welcome.


Darryl de Jesus

I'm using MS SQL 2005
Dec 22 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.