Export (0) Print
Expand All

Performing Infrequent Tasks

SQL Server 2000

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.

Show:
© 2014 Microsoft