2

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?

Rosen Dimov
  • 1,055
  • 12
  • 32

1 Answers1

3

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
Keith
  • 20,636
  • 11
  • 84
  • 125
  • Thanks, that query is convinient too. I was also suggested to look at the log files created after every population as described here - http://msdn.microsoft.com/en-us/library/ms142575.aspx#crawl. – Rosen Dimov Jun 23 '14 at 11:41