Search code examples
sqlsql-serversql-server-2012full-text-searchfull-text-indexing

Manual Fulltext index population time in SQL Server 2012

I would like to know if there is a way to see how much time did it take SQL Server 2012 to index all the data in a table?

In my example I create the table, create the index and set the population to be manual. Then I execute

ALTER FULLTEXT INDEX ON table_name START UPDATE POPULATION;

The query executes immediately but as I know, the population process is actually performed in the background. How can I find out what's the total time it took to index the whole table?

Solution

  • The sys.fulltext_indexes system table contains the start/end time of the current or last population (crawl).

    SELECT crawl_start_date, crawl_end_date
FROM sys.fulltext_indexes