Word breaking timed out for the full-text query string

Recently I encountered this error while working on Microsoft Sql Server 2008. The error description as below:

"Word breaking timed out for the full-text query string. This can happen if the wordbreaker took a long time to process the full-text query string, or if a large number of queries are running on the server. Try running the query again under a lighter load."

I found common workarounds for the issue.

Solution 01

You can increase the ISM size by using the sp_fulltext_service stored procedure as follows. Please note that you need to restart the SQL Server service for this change to take effect.



--To show the current value:
sp_fulltext_service 'ism_size' 

---To change the value to 16:
exec sp_fulltext_service 'ism_size',@value=16

Solution 02

Set the VerifySignature to 0

SELECT FULLTEXTSERVICEPROPERTY('VerifySignature');

GO
-- if 1, then turn off verify_signature
EXEC sp_fulltext_service 'verify_signature', 0;
GO

If you want to read more on this issue refer:

• https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1e7d15d3-818f-4db3-b760-b897b91973ae/sql-2008-word-breaking-timed-out-for-the-fulltext-query-string?forum=sqlsearch

• https://social.msdn.microsoft.com/Forums/sqlserver/en-US/699221f0-a850-4f1d-b1db-a067a172f866/sql-server-timeout-is-by-design-when-using-fulltext?forum=sqlsecurity

• https://social.technet.microsoft.com/Forums/en-US/a0718411-d0ec-49a8-bfff-d5cb9e04208b/full-text-timed-out-exception?forum=transactsql