TechNet
Export (0) Print
Expand All

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

 

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

This section contains the following dynamic management views and functions that are related to full-text search and semantic search.

sys.dm_fts_active_catalogs (Transact-SQL)
Returns information on the full-text catalogs that have some population activity in progress on the server.

sys.dm_fts_fdhosts
Returns information on the current activity of the filter daemon host or hosts on the server instance.

sys.dm_fts_index_keywords
Returns information about the content of a full-text index for the specified table.

sys.dm_fts_index_keywords_by_document
Returns information about the document-level content of a full-text index for the specified table. A given keyword can appear in several documents.

sys.dm_fts_index_keywords_by_property
Returns all property-related content in the full-text index of a given table. This includes all data that belongs to any property registered by the search property list associated with that full-text index.

sys.dm_fts_index_keywords_position_by_document
Returns the position of keywords in a document.

sys.dm_fts_index_population
Returns information about the full-text index populations currently in progress.

sys.dm_fts_memory_buffers
Returns information about memory buffers belonging to a specific memory pool that are used as part of a full-text crawl or a full-text crawl range.

sys.dm_fts_memory_pools
Returns information about 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_outstanding_batches
Returns information about each full-text indexing batch.

sys.dm_fts_parser
Returns the final tokenization result after applying a given word breaker, thesaurus, and stoplist combination to a query string input. The output is equivalent to the output if the specified given query string were issued to the Full-Text Engine.

sys.dm_fts_population_ranges
Returns information about the specific ranges related to a full-text index population currently in progress.

sys.dm_fts_semantic_similarity_population (Transact-SQL)
Returns one row of status information about the population of the document similarity index for each similarity index in each table that has an associated semantic index.

Dynamic Management Views and Functions (Transact-SQL)
System Views (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft