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.

1. 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.

2. 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).

3. 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.

4. 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.

1. 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.

2. 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.