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.

To find this alert, we’re checking 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.