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
Last activity: Apr 20, 2025, 07:57 AM