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.

See Also

Other Resources

Monitoring Resource Usage (System Monitor)
sys.dm_os_performance_counters

Help and Information

Getting SQL Server 2005 Assistance