| title | sys.dm_fts_outstanding_batches (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/29/2017 | ||||
| ms.prod | sql | ||||
| ms.prod_service | database-engine, sql-database | ||||
| ms.technology | system-objects | ||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | c4d697ed-c906-4c28-b137-036a25e13c84 | ||||
| author | pmasl | ||||
| ms.author | pelopes | ||||
| ms.reviewer | mikeray | ||||
| monikerRange | =azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]
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 |
On [!INCLUDEssNoVersion_md], requires VIEW SERVER STATE permission.
On [!INCLUDEssSDS_md] Premium Tiers, requires the VIEW DATABASE STATE permission in the database. On [!INCLUDEssSDS_md] Standard and Basic Tiers, requires the Server admin or an Azure Active Directory admin account.
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