Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

Manage and Monitor Semantic Search

SQL Server 2012

Describes the process of semantic indexing and the tasks related to managing and monitoring the indexes.

Is the first phase of semantic indexing complete?

Query the dynamic management view, sys.dm_fts_index_population (Transact-SQL), and check the status and status_description columns.

The first phase of indexing includes the population of the full-text keyword index and the semantic key phrase index, as well as the extraction of document similarity data.


              USE database_name
GO

SELECT * FROM sys.dm_fts_index_population WHERE table_id = OBJECT_ID('table_name')
GO
            
Is the second phase of semantic indexing complete?

Query the dynamic management view, sys.dm_fts_semantic_similarity_population (Transact-SQL), and check the status and status_description columns..

The second phase of indexing includes the population of the semantic document similarity index.


              USE database_name
GO

SELECT * FROM sys.dm_fts_semantic_similarity_population WHERE table_id = OBJECT_ID('table_name')
GO
            

[TOP]

What is the logical size of a semantic key phrase index or a semantic document similarity index?

Query the dynamic management view, sys.dm_db_fts_index_physical_stats (Transact-SQL).

The logical size is displayed in number of index pages.


              USE database_name
GO

SELECT * FROM sys.dm_db_fts_index_physical_stats WHERE object_id = OBJECT_ID('table_name')
GO
            
What is the total size of the full-text and semantic indexes for a full-text catalog?

Query the IndexSize property of the FULLTEXTCATALOGPROPERTY (Transact-SQL) metadata function.


              SELECT FULLTEXTCATALOGPROPERTY('catalog_name', 'IndexSize')
GO
            
How many items are indexed in the full-text and semantic indexes for a full-text catalog?

Query the ItemCount property of the FULLTEXTCATALOGPROPERTY (Transact-SQL) metadata function.


              SELECT FULLTEXTCATALOGPROPERTY('catalog_name', 'ItemCount')
GO
            

[TOP]

You can force the population of full-text and semantic indexes by using the START/STOP/PAUSE or RESUME POPULATION clause with the same syntax and behavior that is described for full-text indexes. For more information, see ALTER FULLTEXT INDEX (Transact-SQL) and Populate Full-Text Indexes.

Since semantic indexing is dependent on full-text indexing, semantic indexes are only populated when the associated full-text indexes are populated.

Example: Start a full population of full-text and semantic indexes

The following example starts full population of both full-text and semantic indexes by altering an existing full-text index on the Production.Document table in the AdventureWorks2012 sample database.

USE AdventureWorks2012
GO

ALTER FULLTEXT INDEX ON Production.Document
    START FULL POPULATION
GO

[TOP]

You can enable or disable full-text or semantic indexing by using the ENABLE/DISABLE clause with the same syntax and behavior that is described for full-text indexes. For more information, see ALTER FULLTEXT INDEX (Transact-SQL).

When semantic indexing is disabled and suspended, queries over semantic data continue to work successfully and to return previously indexed data. This behavior is not consistent with the behavior of Full-Text Search.


          -- To disable semantic indexing on a table
USE database_name
GO

ALTER FULLTEXT INDEX ON table_name DISABLE
GO

-- To re-enable semantic indexing on a table
USE database_name
GO

ALTER FULLTEXT INDEX ON table_name ENABLE
GO
        

[TOP]

Semantic Search indexes two kinds of data for each column on which it is enabled:

  1. Key phrases

  2. Document similarity

Semantic indexing occurs in two phases, in conjunction with full-text indexing:

  1. Phase 1. The full-text keyword index and the semantic key phrase index are populated in parallel at the same time. The data required to index document similarity is also extracted at this time.

  2. Phase 2. The semantic document similarity index is then populated. This index depends on both indexes that were populated in the preceding phase.

[TOP]

Are the associated full-text indexes populated?

Since semantic indexing is dependent on full-text indexing, semantic indexes are only populated when the associated full-text indexes are populated.

Are full-text search and semantic search properly installed and configured?

For more information, see Install and Configure Semantic Search.

Is the FDHOST service not available, or is there another condition that would cause full-text indexing to fail?

For more information, see Troubleshoot Full-Text Indexing.

[TOP]

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.