Determining the Amount of Resources Used for Full-Text Indexing and Searching

  • Article

To determine the level of resource usage that has been assigned to the full-text service you need to follow these steps:

  1. Determine whether the full-text component is installed. After starting the server, execute this statement:

    SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled');
GO

    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. To do this, execute this statement:

    SELECT FULLTEXTSERVICEPROPERTY ('ResourceUsage');
GO

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

See Also

Other Resources

FULLTEXTSERVICEPROPERTY (Transact-SQL)
sp_configure (Transact-SQL)
OBJECTPROPERTYEX (Transact-SQL)
sp_fulltext_service (Transact-SQL)
INDEXPROPERTY (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance