current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

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?

share|improve this question
    
I don't know if this helps, but are you aware the population process is logged? msdn.microsoft.com/en-us/library/ms142575.aspx#crawl has details for SQL Server 2012 –  Max Vernon Jun 19 at 15:18
    
Thanks, the log files contained start time and end time of population which is what I was looking for. –  Rosen Dimov Jun 20 at 7:18

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.