July 10, 2008 at 10:50 am
Hi,
Do you guys have any document or Internet link which can help me in identifying the high virtual memory usage problems on sql server machine?
Please suggest me a way of how we can troubleshoot high virtual memory usage problems on sql server machine.
Any help is highly appreciated.
Manu
July 10, 2008 at 11:13 am
July 10, 2008 at 3:19 pm
Actually we have configured NetIQ to alert in case virtual memory goe over 80 percent threshold. I am getting alerts for one server with VM usgae of 85 percent frequently.
Any information as to what steps needs to be followed for troubleshooting this problem will help me.
Thanks
Manu
July 10, 2008 at 4:08 pm
Well, your virtual memory represents your page file. There are a couple of things you need to know here. First off, most systems use the page file to some extent. What is important to know in your case is what process is using the page file the most. This can be done by setting up a Windows Performance Monitor to watch the paging or by simply using the Task Manager's Processes tab to see the Page Faults (you may have to click on View...Select Columns to see this column in the Processes tab).
If you find SQL Server to be the culprit, you may have a memory bottleneck. You can further prove this by running Windows Performance Monitor and looking at Page Life Expectancy (should not be consistantly < 300), Buffer Cache Hit Ratio (should be as close to 100% as possible), Lazy Writes/sec (should not be consistantly above 20) to see if there are other factors pointing to a memory bottleneck.
July 11, 2008 at 10:00 am
Thanks John.
Manu
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply