sys.dm_fts_outstanding_batches (Transact-SQL)

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

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