February 1, 2012 at 4:36 am
Hi all,
This is a continuation of a topic I posted here: http://www.sqlservercentral.com/Forums/Topic1239127-391-1.aspx
I figured that it would be best to start a new topic as this is a new question (I wasn't sure how to close the previous topic).
I have attached a screenshot which is one symptom of the problem.
Server details:
Windows Server 2008
64-bit
SQL Server 2008 Standard Edition 64-bit
AWE disabled
Total server RAM = 12 GB
Min RAM = 2000 MB
Max RAM = 8000 MB
Free RAM (as per task manager) = around 300 MB
Dedicated to SQL although a backup program runs that eats up around 50 MB RAM.
Problem:
I have been monitoring the SQL server's performance this afternoon and noticed rather erratic Total Memory, Target Memory and Page Life Expectancy counters.
Even though according to SSMS and sp_configure I have set min server memory (MB) to 2000, "Total Server Memory (KB)" appears to drop to 0 at certain points during the day.
At the same time, target server memory also drops to 0, along with PLE and site performance suffers significantly.
Is this possible, or could it be a PerfMon glitch?
If so, what could explain this behaviour?
Thanks in advance,
Ben
February 1, 2012 at 3:05 pm
I've never seen Target Server Memory go to 0. FOr total server memory you should look in the error log to see if there is a message liek this, "A significant part of sql server process memory has been paged out" that could puch the buffer pool down near 0.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 2, 2012 at 10:58 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply