Redigera

Dela via


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%';