September 22, 2015 at 9:10 am
Hi All
When troubleshooting a memory pressure situation on a SQL Server.
I noticed that PLE was low, Lazy Writes/sec was higher than normal, Buffer Cache Hit Ratio was down.
I also noticed that the Free List Stalls/sec counter was not moving at all.
Why would this counter remain stagnant in a memory pressure situation? I figured this counter would be active in a memory pressure situation because requests would have to wait for a free page.
Any ideas
Thanks..
September 22, 2015 at 9:33 am
SQLSACT (9/22/2015)
Hi AllWhen troubleshooting a memory pressure situation on a SQL Server.
I noticed that PLE was low, Lazy Writes/sec was higher than normal, Buffer Cache Hit Ratio was down.
I also noticed that the Free List Stalls/sec counter was not moving at all.
Why would this counter remain stagnant in a memory pressure situation? I figured this counter would be active in a memory pressure situation because requests would have to wait for a free page.
Any ideas
Thanks..
What are the serve's specs and configurations please?
😎
September 23, 2015 at 2:21 am
Eirikur Eiriksson (9/22/2015)
SQLSACT (9/22/2015)
Hi AllWhen troubleshooting a memory pressure situation on a SQL Server.
I noticed that PLE was low, Lazy Writes/sec was higher than normal, Buffer Cache Hit Ratio was down.
I also noticed that the Free List Stalls/sec counter was not moving at all.
Why would this counter remain stagnant in a memory pressure situation? I figured this counter would be active in a memory pressure situation because requests would have to wait for a free page.
Any ideas
Thanks..
What are the serve's specs and configurations please?
😎
SQL Server 2012 SP2 64bit on Windows 2008 R2.
SQL Allocated memory is 25GB.
September 23, 2015 at 2:25 am
SQLSACT (9/23/2015)
Eirikur Eiriksson (9/22/2015)
SQLSACT (9/22/2015)
Hi AllWhen troubleshooting a memory pressure situation on a SQL Server.
I noticed that PLE was low, Lazy Writes/sec was higher than normal, Buffer Cache Hit Ratio was down.
I also noticed that the Free List Stalls/sec counter was not moving at all.
Why would this counter remain stagnant in a memory pressure situation? I figured this counter would be active in a memory pressure situation because requests would have to wait for a free page.
Any ideas
Thanks..
What are the serve's specs and configurations please?
😎
SQL Server 2012 SP2 64bit on Windows 2008 R2.
SQL Allocated memory is 25GB.
System memory?
😎
September 23, 2015 at 3:17 am
Eirikur Eiriksson (9/23/2015)
SQLSACT (9/23/2015)
Eirikur Eiriksson (9/22/2015)
SQLSACT (9/22/2015)
Hi AllWhen troubleshooting a memory pressure situation on a SQL Server.
I noticed that PLE was low, Lazy Writes/sec was higher than normal, Buffer Cache Hit Ratio was down.
I also noticed that the Free List Stalls/sec counter was not moving at all.
Why would this counter remain stagnant in a memory pressure situation? I figured this counter would be active in a memory pressure situation because requests would have to wait for a free page.
Any ideas
Thanks..
What are the serve's specs and configurations please?
😎
SQL Server 2012 SP2 64bit on Windows 2008 R2.
SQL Allocated memory is 25GB.
System memory?
😎
Total server memory - 48GB
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply