Scenario C: Performing Infrequent Tasks

The examples in this scenario demonstrate the full-text indexing tasks that are typically required less often 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 has been made.

1. After starting the server, execute this statement:

   SELECT FulltextServiceProperty ( 'IsFullTextInstalled' )

     

   This returns 1 if the service has been installed, and 0 if it has not.

2. Determine the level of resource usage that has been assigned to the full-text service by executing this statement:

   SELECT FulltextServiceProperty ( 'ResourceUsage' )

     

   This returns a value from 1 (background) through 5 (dedicated).

3. You may want to determine how long the full-text service has to wait to initialize after a request has come in from Microsoft® SQL Server™ to populate a full-text index. Execute this statement:

   SELECT FulltextServiceProperty ( 'ConnectTimeout' )

     

   This returns the current time-out value.

4. Because this installation of SQL Server 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

     

Inquiring About the Full-text Key Column

Determine if the regular SQL 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' )

     

   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'))