October 5, 2013 at 7:41 pm
Hi,
I have an instance with Max Memory configured to 8 GB and Min memory configured to 1 GB
But the instance is only taking 3 GB. But PLE is dropping continuously less than 50 secs but there are no active sessions running.
why sql instance is not taking only 4 GB even though the Max memory is set to 8 GB?
October 5, 2013 at 7:51 pm
Is there free memory for SQL to take?
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
October 5, 2013 at 8:00 pm
We have 12 GB RAM on the node.
8 GB Max Memory
1 GB Min Memory
4 GB left for OS
No other applications are installed other than SQL Server
October 6, 2013 at 12:49 am
Using any third party tools like Quest Litespeed? Any CLR code or Integration services on this server? These are some of the things that can cause PLE drops.
October 6, 2013 at 2:33 am
madhu-686862 (10/5/2013)
We have 12 GB RAM on the node.8 GB Max Memory
1 GB Min Memory
4 GB left for OS
No other applications are installed other than SQL Server
That doesn't answer my question. Is there free memory for SQL Server to take?
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply