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.

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

Reference

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

Concepts

Full-Text Search (SQL Server)