MSSEARCH

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

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index