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
Athugasemdir
https://aka.ms/ContentUserFeedback.
Væntanlegt: Á árinu 2024 munum við hætta með GitHub-mál sem ábendingaleið fyrir efni og skipta því út fyrir nýtt ábendingakerfi. Frekari upplýsingar er að finna hér:Senda inn og skoða endurgjöf fyrir