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?