Accumulates while SQL Server is running Full Text queries. If values are very high consider optimizing the Full Text queries
DBAs and Developers
- Restrict the number of columns included in the Full Text index.
- Reduce the size of the Full Text index by adding words to the stop list.
- Use Full Text predicates such as CONTAINS, avoid FREETEXT if its functionality is not required.