Home Forums SQL Server 2008 SQL Server 2008 Administration Does the Full-Text Filter Daemon Launcher service need to be running for Full-Text-Search queries to run successfully? RE: Does the Full-Text Filter Daemon Launcher service need to be running for Full-Text-Search queries to run successfully?

  • April 9, 2011 at 9:02 am

    #1309548

    Craig Purnell (4/9/2011)

    The Filter Daemon launches filter processes. Starting in SQL 2008, the Full Text engine is entirely within the SQL engine. See MSDN for more info:

    http://msdn.microsoft.com/en-us/library/ms142541.aspx

    Thank you, so if I understand correctly, this service needs to be running only in this case:

    when processing data contained in a varbinary, varbinary(max), image, or xml data type column

    (http://msdn.microsoft.com/en-us/library/ms142499.aspx)

    So, if my full-text-search application does not deal with these types of columns, the filter-daemon service is not needed and can be stopped.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]