Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Does the Full-Text Filter Daemon Launcher service need to be running for Full-Text-Search queries to run successfully? Expand / Collapse
Author
Message
Posted Friday, April 8, 2011 2:51 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Saturday, September 13, 2014 11:32 PM
Points: 1,862, Visits: 3,606
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?


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1090944
Posted Saturday, April 9, 2011 8:41 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:21 PM
Points: 201, Visits: 501
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




Post #1091090
Posted Saturday, April 9, 2011 9:02 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Saturday, September 13, 2014 11:32 PM
Points: 1,862, Visits: 3,606
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.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1091093
Posted Monday, April 11, 2011 11:59 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Saturday, September 13, 2014 11:32 PM
Points: 1,862, Visits: 3,606
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.)


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1091637
Posted Monday, April 11, 2011 12:02 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:21 PM
Points: 201, Visits: 501
I think that's right.


Post #1091639
Posted Monday, April 11, 2011 12:06 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Saturday, September 13, 2014 11:32 PM
Points: 1,862, Visits: 3,606
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.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1091643
Posted Wednesday, April 13, 2011 8:39 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Saturday, September 13, 2014 11:32 PM
Points: 1,862, Visits: 3,606
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.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1092877
Posted Wednesday, November 2, 2011 1:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, December 22, 2013 9:20 PM
Points: 7, 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/
Post #1199613
Posted Saturday, August 3, 2013 4:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 4, 2013 9:29 AM
Points: 5, 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.
Post #1480736
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse