Redigera

Dela via


sys.dm_fts_outstanding_batches (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

Returns information about each full-text indexing batch.

Column name Data type Description
database_id int ID of the database
catalog_id int ID of the full-text catalog
table_id int ID of the table ID that contains the full-text index
batch_id int Batch ID
memory_address varbinary(8) The batch object memory address
crawl_memory_address varbinary(8) Crawl object memory address (parent object)
memregion_memory_address varbinary(8) Memory region memory address of the outbound share memory of the filter daemon host (fdhost.exe)
hr_batch int Most recent error code for the batch
is_retry_batch bit Indicates whether this is a retry batch:

0 = No

1 = Yes
retry_hints int Type of retry needed for the batch:

0 = No retry

1 = Multi thread retry

2 = Single thread retry

3 = Single and multi thread retry

5 = Multi thread final retry

6 = Single thread final retry

7 = Single and multi thread final retry
retry_hints_description nvarchar(120) Description for the type of retry needed:

NO RETRY

MULTI THREAD RETRY

SINGLE THREAD RETRY

SINGLE AND MULTI THREAD RETRY

MULTI THREAD FINAL RETRY

SINGLE THREAD FINAL RETRY

SINGLE AND MULTI THREAD FINAL RETRY
doc_failed bigint Number of documents that failed in the batch
batch_timestamp timestamp The timestamp value obtained when the batch was created

Permissions

On SQL Server and SQL Managed Instance, requires VIEW SERVER STATE permission.

On SQL Database Basic, S0, and S1 service objectives, and for databases in elastic pools, the server admin account, the Microsoft Entra admin account, or membership in the ##MS_ServerStateReader## server role is required. On all other SQL Database service objectives, either the VIEW DATABASE STATE permission on the database, or membership in the ##MS_ServerStateReader## server role is required.

Permissions for SQL Server 2022 and later

Requires VIEW SERVER PERFORMANCE STATE permission on the server.

Examples

The following example finds out how many batches are currently being processed for each table in the server instance.

SELECT database_id, table_id, COUNT(*) AS batch_count FROM sys.dm_fts_outstanding_batches GROUP BY database_id, table_id ;  
GO  

See Also

Full-Text Search and Semantic Search Dynamic Management Views and Functions (Transact-SQL)
Full-Text Search