We added a new SQL Always-On Cluster (FCI) 2017 and some of the databases needed full text filter service. So we also added that feature to the install. Ever since we did that we have been getting the error that it stopped abnormally every minute filling up our error log. Here is the full error message.
The fulltext filter daemon host (FDHost) process has stopped abnormally. This can occur if an incorrectly configured or malfunctioning linguistic component, such as a wordbreaker, stemmer or filter has caused an irrecoverable error during full-text indexing or query processing. The process will be restarted automatically.
Is there any recommendations to avoid this or any best practices with regard to Full text service running on alwayson clusters?
Best Answer
First, verify the service account, whether it has appropriate permissions on the server.
Then consider Re-configuring Word Breakers as previous version of Word Breakers might not compatible with SQL 2017. For more details