Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tools to view the progress
Message
De
24/05/2013 16:46:52
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
24/05/2013 16:06:24
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Indexation
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01574583
Message ID:
01574658
Vues:
43
>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform