ananda.murugesan (9/10/2012)
Thanks for your valuable reply. I hope, i am going to correct path for fixing memory related issues.
All we have established so far is that your SQL Server eventually uses all the memory you have allowed it to use per the configuration 'max server memory (MB)' which is by design. To which other 'memory related issues' are you referring?
As per memory overivew result in production server as below
PhysicalMemoryGB - 8.00
BufferPoolCommittedMemoryGB - 3.13
BufferPoolTargetMemoryGB - 5.97
MinServerMemoryGB - 0.00
MaxServerMemoryGB - 5.97
Thank you, but you forgot to post the value from the overview I was most interested in: TotalServerMemoryMB. Please post it.
For the Lock page memory enable
---------------------------------
Lock Pages in Memory is a setting that can be set on 64-bit operating systems that essentially tell Windows not to swap out SQL Server memory to disk. By default, this setting is turned off on 64-bit systems,
Yes, that is correct, lpim is off by default but you have it turned on and you still have not told us why you enabled it.
so as per server installed OS x64.
Sorry I did not understand this. What are you meaning to relay here?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato