Monitoring Full-Text Search Activity on a Server Instance

Several dynamic management views and functions are useful monitoring full-text search activity on a server instance.

To view information about the full-text catalogs with in-progress population activity

• sys.dm_fts_active_catalogs (Transact-SQL)

To view current activity of a filter daemon host process

• sys.dm_fts_fdhosts (Transact-SQL)

To view information about in-progress index populations

• sys.dm_fts_index_population (Transact-SQL)

  Note

  In SQL Server 2008, the meanings of the following columns have changed: memory_address, outstanding_batch_count, status, and worker_count.

To view memory buffers in a memory pool that are used as part of a crawl or crawl range.

• sys.dm_fts_memory_buffers (Transact-SQL)

To view the shared memory pools available to the full-text gatherer component for a full-text crawl or a full-text crawl range

• sys.dm_fts_memory_pools (Transact-SQL)

To view information about each full-text indexing batch

• sys.dm_fts_outstanding_batches (Transact-SQL)

  Note

  The full-text gatherer works with the full-text crawl threads. It is responsible for scheduling and driving the population of full-text indexes, and also for monitoring full-text catalogs.

To view information about the specific ranges related to an in-progress population

• sys.dm_fts_population_ranges (Transact-SQL)