Sample Header Ad - 728x90

SQL Server: How to track progress of CREATE INDEX command?

69 votes
4 answers
93982 views
SQL Server 2014, Std Ed I have read that percent_complete in dm_exec_requests does not work for CREATE INDEX, and in practice, percent_complete sticks at 0. So that doesn't help. I currently use the method below, which at least shows me movement (that the index creation is not blocked). But I have zero idea if I am %10 through the process or %99. I tried the method described here: https://dba.stackexchange.com/a/102545/6229 but it shows a clearly wrong est completion time (it basically shows 'now' for a 60+ minute process that I am 10 min into) How can I get a clue? SELECT percent_complete, estimated_completion_time, reads, writes, logical_reads, text_size, * FROM sys.dm_exec_requests AS r WHERE r.session_id @@SPID AND r.session_id = 58
Asked by Jonesome Reinstate Monica (3489 rep)
May 22, 2016, 07:25 AM
Last activity: Apr 20, 2025, 07:57 AM