Export (0) Print
Expand All

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

SQL Server 2005

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

Community Additions

ADD
Show:
© 2014 Microsoft