| title | SQL Server, LogPool FreePool object | |
|---|---|---|
| description | Learn about the SQLServer:LogPool FreePool performance object, wich provides counters for statistics for the free pool inside the Log Pool. | |
| ms.custom | ||
| ms.date | 07/13/2021 | |
| ms.prod | sql | |
| ms.prod_service | database-engine | |
| ms.reviewer | ||
| ms.technology | performance | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| author | WilliamDAssafMSFT | |
| ms.author | wiassaf |
[!INCLUDE 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.
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%';