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