November 22, 2014 at 10:37 pm
Hi,
my vm server having 24 GB of ram and 20 GB allocated to sql server memory.my instance is having 3 databases
so how can i distribute memory to sql server databases?
November 23, 2014 at 12:19 am
You let SQL Server do that for you, meaning you don't necessarily control 8GB goes to db1, and the rest is split between db2 and db3.
SQL Server is going to maintain which databases get a certain amount of memory based on data being queried. You can take note of the amount of dirty and clean pages with a query from John Sansom HERE[/url]. An MSSQLTips.com article by Aaron Betrand provides a query to dig down to an object level per database HERE[/url].
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
November 24, 2014 at 8:16 am
Just make sure you set the maximum memory size within the SQL Server instance and then, as stated, let SQL Server do the memory management for you. For your memory setting, assuming only SQL Server is running on the VM, I'd suggest leaving 4gb for the OS and giving the rest to SQL Server. You can read more about that here[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply