SQL Server, LogPool FreePool object

Applies to: SQL Server

The SQLServer:LogPool FreePool performance object provides counters for statistics for the free pool inside the Log Pool.

This following table describes the SQL Server LogPool FreePool performance objects.

SQL Server LogPool FreePool counters	Description
Free Buffer Refills/sec	Number of buffers being allocated for refill, per second.
Free List Length	Length of the free list.

There is one instance of the counter for each category of log pool.

Example

You begin to explore the query performance counters in this object using this T-SQL query on the sys.dm_os_performance_counters dynamic management view:

SELECT * FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%LogPool FreePool%';

Related content

• Monitor Resource Usage (Performance Monitor)