sys.dm_hadr_db_threads (Transact-SQL)
The HADR thread telemetry DMVs (sys.dm_hadr_db_threads and sys.dm_hadr_ag_threads) allow users to quickly gain insight into thread usage by Availability Group and by high availability database. Understanding this thread usage is an important benchmark for tuning availability groups.
This DMV reports on thread usage at the availability group database level.
Column name | Data type | Description |
---|---|---|
group_id | uniqueidentifier | Identifier of the availability group to which the database belongs. |
ag_db_id | uniqueidentifier | Identifier of the database within the availability group. This identifier is identical on every replica to which this database is joined. |
name | nvarchar(128) | Name of the database. |
num_capture_threads | int | Number of log capture threads for this database. |
num_redo_threads | int | Number of redo threads for this database. |
num_parallel_redo_threads | int | Number of parallel redo threads for this database. |
Permissions
Requires VIEW SERVER STATE permission on the server.
Permissions for SQL Server 2022 and later
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
See also
Always On Availability Groups Dynamic Management Views and Functions (Transact-SQL)
Always On Availability Groups Catalog Views (Transact-SQL)
Monitor Availability Groups (Transact-SQL)
Always On Availability Groups (SQL Server)
Pripomienky
https://aka.ms/ContentUserFeedback.
Pripravujeme: V priebehu roka 2024 postupne zrušíme službu Problémy v službe GitHub ako mechanizmus pripomienok týkajúcich sa obsahu a nahradíme ju novým systémom pripomienok. Ďalšie informácie nájdete na stránke:Odoslať a zobraziť pripomienky pre