SQL Server, Buffer Partition Object

The Buffer Partition object provides counters to monitor how SQL Server uses free pages.

This table describes the SQL Server Buffer Partition counters.

SQL Server Buffer Partition counters

Description

Free list empty/sec

Number of times per second a free page was requested and none was available.

Free list requests/sec

Number of times per second a free page was requested.

Free pages

Total number of pages on all free lists.