sys.dm_fts_outstanding_batches (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns information about each full-text indexing batch.

Column nameData typeDescription
database_idintID of the database
catalog_idintID of the full-text catalog
table_idintID of the table ID that contains the full-text index
batch_idintBatch ID
memory_addressvarbinary(8)The batch object memory address
crawl_memory_addressvarbinary(8)Crawl object memory address (parent object)
memregion_memory_addressvarbinary(8)Memory region memory address of the outbound share memory of the filter daemon host (fdhost.exe)
hr_batchintMost recent error code for the batch
is_retry_batchbitIndicates whether this is a retry batch:

0 = No

1 = Yes
retry_hintsintType 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_descriptionnvarchar(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_failedbigintNumber of documents that failed in the batch
batch_timestamptimestampThe timestamp value obtained when the batch was created

Requires VIEW SERVER STATE permission on the server.

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  

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

Community Additions

ADD
Show: