Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Does the Full-Text Filter Daemon Launcher service need to be running for Full-Text-Search queries to...


Does the Full-Text Filter Daemon Launcher service need to be running for Full-Text-Search queries to run successfully?

Author
Message
Marios Philippopoulos
Marios Philippopoulos
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1958 Visits: 3741
I don't understand the role of this service in SQL 2008 full-text search: Full-Text Filter Daemon Launcher.

Does this service need to be running for full-text-search queries to be running successfully?

A query like the one below runs fine even when the service is down:


SELECT * from Document
WHERE CONTAINS(DocCol, 'price');



What type of queries would break when the Daemon Launcher service is down?

__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables
Persisting SQL Server Index-Usage Statistics with MERGE
Turbocharge Your Database Maintenance With Service Broker: Part 2
Craig Purnell
Craig Purnell
SSC Veteran
SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)

Group: General Forum Members
Points: 218 Visits: 526
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



Marios Philippopoulos
Marios Philippopoulos
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1958 Visits: 3741
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
Persisting SQL Server Index-Usage Statistics with MERGE
Turbocharge Your Database Maintenance With Service Broker: Part 2
Marios Philippopoulos
Marios Philippopoulos
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1958 Visits: 3741
Marios Philippopoulos (4/9/2011)
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.


Can someone please confirm if my assumption above is valid?
(ie. that the filter-daemon service is not needed if FTS is used only on VARCHAR-type columns.)

__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables
Persisting SQL Server Index-Usage Statistics with MERGE
Turbocharge Your Database Maintenance With Service Broker: Part 2
Craig Purnell
Craig Purnell
SSC Veteran
SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)

Group: General Forum Members
Points: 218 Visits: 526
I think that's right.



Marios Philippopoulos
Marios Philippopoulos
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1958 Visits: 3741
Craig Purnell (4/11/2011)
I think that's right.


Thank you, we are developing some new FTS functionality and will test with the service down to see what happens.

__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables
Persisting SQL Server Index-Usage Statistics with MERGE
Turbocharge Your Database Maintenance With Service Broker: Part 2
Marios Philippopoulos
Marios Philippopoulos
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1958 Visits: 3741
Marios Philippopoulos (4/11/2011)
Craig Purnell (4/11/2011)
I think that's right.


Thank you, we are developing some new FTS functionality and will test with the service down to see what happens.


The query below actually fails, when the filter daemon service is down; now I'm confused:


select col2 from tbl1
where freetext(col1, 'abcd')



Msg 30046, Level 16, State 1, Procedure sp_fulltext_service, Line 163
SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.

__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables
Persisting SQL Server Index-Usage Statistics with MERGE
Turbocharge Your Database Maintenance With Service Broker: Part 2
freewaresucks
freewaresucks
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 33
Maybe this link might help it says the full text can be utilized into applications and can be used that way and the such. http://www.sql-server-performance.com/2010/full-text-search-2008/
C. Westra
C. Westra
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 57
The description of Full-text Search for Sql Server 2008 R2 says about the Filter Daemon Host Process:
"The filter daemon host is a process that is started by the Full-Text Engine. It runs the following full-text search components, which are responsible for accessing, filtering, and word breaking data from tables, as well as for word breaking and stemming the query input."
http://technet.microsoft.com/en-us/library/ms142541(v=sql.105).aspx

It is the same for Sql Server 2008 and 2012.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search