Full-text population index stuck in SQL 2012 launch

I have a sql server 2012 block that hosts hundreds of databases. All databases use full-text indexing. Indexing has stopped working.

execution of this request:

SELECT  status_description
FROM    sys.dm_fts_index_population

returns status_descriptionequal Startingfor all databases where recent activity has been active.

I created a new database and created a full text index. This problem has the same problem, the population is not ending.

What could be the reason? Can I somehow reset to serve the full text index without serving the SQL Server service itself?

+5
source share

All Articles