Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

"Free List Stalls" vs "Free List Empty" Expand / Collapse
Posted Tuesday, September 4, 2012 4:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 23, 2013 6:40 PM
Points: 241, Visits: 253
I'm trying to understand the relationship (if any) between the SQL DMV counters:
SQLServer:Buffer Manager\Free list stalls/sec and
SQLServer:Buffer Partition\Free list empty/sec

I can find little (if any) documentation about the significance of Free List Empty/sec

Our Free List Stalls/sec counter is pretty consistently 0 (which is good)
However, our Free List Empty/sec counter is consistently in the high 1000s per sec, often tens of thousands.

Intuitively, I would have imagined that thousands of "Free List Empty" scenarios would have led to at least some Free List Stalls, but apparently not.

My question is, therefore, can anyone shed any more light on what the significance/usefulness (or otherwise!) is of the Free List Empty counter?
Post #1353791
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse