Administering SQL Server
SQL Server: Buffer Partition Object
The Buffer Partition object provides counters to monitor how Microsoft® SQL Server™ uses free pages.
| SQL Server Buffer Partition counters | Description |
|---|---|
| Free list empty/sec | Number of times a free page was requested and none was available. |
| Free list requests/sec | Number of times a free page was requested. |
| Free pages | Total number of pages on all free lists. |