January 19, 2011 at 2:06 pm
I have gone through most of the postings/articles on this forum regarding Locked Pages in memory setting. I want to gather some data so that i decide if changing the setting helped or not. Total physical memory on the box is 48GB and sql min and max is 0 and 42 GB respectively. Mentioned below are the perfmon counters i have used to monitor but i am not able to correlate.I would request to provide some feedback on this. I have used the following counters:
i)Process/sqlserevr - Pagefile - because i want to see if sqlser.exe is using any pagefile
ii)process/sqlserver - private bytes
iii)Process/sqlserver - workingset
iv)SQLServer:Memory Manager\Target Server Memory (GB)
v)SQLServer:Memory Manager\Total Server Memory (GB)
I am trying to findout how is each of them related . I cannot add or remove any more counters since trace is started. I am attaching the sample file if someone wants to look. Thanks in advance.
January 19, 2011 at 7:08 pm
We have noticed difference even without these counters, using Windows Task Manager only. Before "lock pages in memory" setting SQL Server process (sqlservr.exe) took almost all available memory (29Gb out of 32GB). After changes it takes now only 2,5GB.
January 19, 2011 at 8:59 pm
oh..i see your point.I didnt really make a note before i changed the setting but now i can see that sql is using only 32 mb of 43 gb. However in task manager i see physical memory around 50gb and committed memory 56 gb? What does this mean?
January 20, 2011 at 6:42 am
The Commit Charge as indicated by the Task Manager in Windows is the amount of virtual memory usage by the system.
I would pay attention to the Physical memory - Total and Available. If the available memory amount is low, external memory pressure may be present.
You can read more about memory troubleshooting here: http://technet.microsoft.com/en-us/library/cc966540.aspx. This articale has explanation for some counters that you used as well.
This article http://msdn.microsoft.com/en-ca/library/aa366527.aspx explains why would you need to grant "Lock Pages in Memory" permissions.
January 24, 2011 at 9:25 am
There is another great article from Microsoft: http://support.microsoft.com/kb/918483
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply