SQL Memory Pressure - Free List Stalls/sec

• SQLSACT

  SSC-Insane

  Points: 21838

  More actions

  September 22, 2015 at 9:10 am

  #311684

  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..

• Eirikur Eiriksson

  SSC Guru

  Points: 182901

  More actions

  September 22, 2015 at 9:33 am

  #1828471

  SQLSACT (9/22/2015)

  ---

  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..

  What are the serve's specs and configurations please?

  😎

• SQLSACT

  SSC-Insane

  Points: 21838

  More actions

  September 23, 2015 at 2:21 am

  #1828680

  Eirikur Eiriksson (9/22/2015)

  ---

  SQLSACT (9/22/2015)

  ---

  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..

  What are the serve's specs and configurations please?

  😎

  SQL Server 2012 SP2 64bit on Windows 2008 R2.

  SQL Allocated memory is 25GB.

• Eirikur Eiriksson

  SSC Guru

  Points: 182901

  More actions

  September 23, 2015 at 2:25 am

  #1828681

  SQLSACT (9/23/2015)

  ---

  Eirikur Eiriksson (9/22/2015)

  ---

  SQLSACT (9/22/2015)

  ---

  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..

  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?

  😎

• SQLSACT

  SSC-Insane

  Points: 21838

  More actions

  September 23, 2015 at 3:17 am

  #1828693

  Eirikur Eiriksson (9/23/2015)

  ---

  SQLSACT (9/23/2015)

  ---

  Eirikur Eiriksson (9/22/2015)

  ---

  SQLSACT (9/22/2015)

  ---

  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..

  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