Post reply

Is Full Text being used? and How to disable it?

  • February 26, 2008 at 12:34 pm

    #124242

    How do I tell if anyone is using Full Text Search?

    What's the proper method of disabling Full Text Search if it is not needed?

    thanks.

  • February 26, 2008 at 12:54 pm

    #782202

    One way to view if a database is currently using Full Text Search is to open SSMS -> Expand databases --> expand the database --> expand storage --> expand full text catalogs. This is too see which databases have catalogs and delete appropriately.

    You use the configuration manager to stop and disable the service.


    My blog: http://jahaines.blogspot.com

  • February 26, 2008 at 1:01 pm

    #782208

    I don't see any full text catalogs listed for any db's. Is it safe then to disable that service using the area coniguration manager?

    thanks

  • February 27, 2008 at 9:35 am

    #782630

    You can use the dynamic views to find that info using the DMV

    Sys.dm_fts_active_catalogs

    Sys.dm_fts_index_population

    Sys.dm_fts_memory_buffers

    Sys.dm_fts_memory_pools

    Sys.dm_fts_population_ranges

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • February 27, 2008 at 10:25 am

    #782705

    I appreciate the feedback.

    thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply