Description

Accumulates while SQL Server is running Full Text queries. If values are very high consider optimizing the Full Text queries

Resolved by

DBAs and Developers

Suggested solutions

1. Restrict the number of columns included in the Full Text index.
2. Reduce the size of the Full Text index by adding words to the stop list.
3. Use Full Text predicates such as CONTAINS, avoid FREETEXT if its functionality is not required.

Additional research

Full-Text Search: Internals and Enhancements

⇐ Back to index