Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tools to view the progress
Message
From
24/05/2013 16:46:52
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
24/05/2013 16:06:24
General information
Forum:
Microsoft SQL Server
Category:
Indexing
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01574583
Message ID:
01574658
Views:
44
>>I thought percent_complete in the dm_exec_requests table would be the percentage you seek.
>
>Well, at first, I didn't see that field. So, I ran the test again. This time, I could see that there is a Percent_Complete field. However, this one remains at 0 for all records, despite the fact that I have a big index in progress for 5 minutes.

The percent complete field did not change on subsequent queries of the dm_exec_requests table while the index ran for the 5 minutes? The docs in the link I sent you say it should update for ALTER INDEX REBUILD.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform