InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 04:05:10 GMT20http://www.sqlservercentral.com/Forums/Topic1353791-391-1.aspxI'm trying to understand the relationship (if any) between the SQL DMV counters:[b]SQLServer:Buffer Manager\Free list stalls/sec[/b] and[b]SQLServer:Buffer Partition\Free list empty/sec[/b]I can find little (if any) documentation about the significance of Free List Empty/secOur 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 [i]some[/i] 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?Tue, 04 Sep 2012 04:00:24 GMTPhilip Yale-193937