Performing Infrequent Tasks
The examples in this scenario demonstrate the full-text indexing tasks typically required less frequently than other administrative tasks.
Changing the Amount of Resources Used for Full-Text Indexing and Searching
Determine if the level of resource usage has been assigned to the full-text service and how long the full-text service has to wait after a request for population.
- After starting the server, execute this statement:
SELECT FulltextServiceProperty ( 'IsFullTextInstalled' )
For more information, see FULLTEXTSERVICEPROPERTY.
This returns 1 if the service has been installed, and 0 if it has not.
- Determine the level of resource usage assigned to the full-text service by executing this statement:
SELECT FulltextServiceProperty ( 'ResourceUsage' )
This returns a value from 1 (background) through 5 (dedicated).
- To determine how long the full-text service has to wait to initialize after a request to populate a full-text index, execute this statement:
SELECT FulltextServiceProperty ( 'ConnectTimeout' )
This returns the current time-out value.
- Because this installation of Microsoft® SQL Server™ 2000 is heavily loaded, you may decide to increase the initialization time-out from the default of 20 seconds to 90 seconds by executing this stored procedure:
sp_fulltext_service 'ConnectTimeout', 90
For more information, see sp_fulltext_service.
Inquiring About the Full-Text Key Column
Determine whether the regular SQL Server mag_id_index index on the magazines table in the pubs database is used to enforce the uniqueness of the full-text key column.
- Execute this statement:
SELECT IndexProperty ( Object_Id('magazines'), 'mag_id_index', 'IsFulltextKey' )
For more information, see INDEXPROPERTY.
This returns a value of 1 if the index is used to enforce uniqueness of the full-text key column, and 0 if it does not.
- Find the name of the full-text key column in the books table by executing this statement:
SELECT ObjectProperty(Object_Id('books'), 'TableFulltextKeyColumn')
For more information, see OBJECTPROPERTY.