sp_Blitz Result: Full Text Indexes Not Populating

SQL Server’s full text indexes are not like regular indexes – they don’t necessarily keep fully up-to-date with the rest of the table.

This part of our SQL Server sp_Blitz script checks sys.fulltext_indexes looking for indexes that are enabled, but where the crawl last finished more than a week ago.

To Fix the Problem

Look at the database in question, and check the full text indexes using this query from Mark Freeman:

The schedules may be turned off. Consider enabling them during your next maintenance window.

Return to sp_Blitz or Ask Us Questions