"Free List Stalls" vs "Free List Empty"

  • 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?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply