February 12, 2013 at 3:01 am
I have Windows 2008 R2 with SQL 2008r2,RAM 16 GB
If I am Setting SQL MIN & MAX memory to 13 GB, Lock pages in memory is required ?
SQL won't release memory to OS , since I set MIN to 13 GB ?
February 12, 2013 at 3:16 am
Do not set the min and max to the same value, it disables some of SQL's memory management and means that SQL won't reduce memory usage if the OS is under memory pressure. If that happens and locked pages is not enabled, the OS will page SQL's memory out. If that happens and locked pages is enabled, the OS could become unstable, throw out of memory errors and stuff may crash.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 12, 2013 at 4:58 am
Thanks alot
I got it
February 12, 2013 at 5:00 am
Is there any specific reason to keep Memory settings to EVEN numbers ?
February 12, 2013 at 5:37 am
Not really.... it's just about getting SQL Server and the OS to work without one starving the other out of memory.
What numbers you choose depend on how much RAM you have and the actvitiy on the server.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply