Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tools to view the progress
Message
De
24/05/2013 15:47:48
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
24/05/2013 15:19:27
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:
01574651
Vues:
43
>>http://technet.microsoft.com/en-us/library/ms177648.aspx
>>
>>sys.dm_exec_requests can be queried to tell you the percent_complete, the estimated_completion_time, total_elapsed_time etc. for each of several commands, including ALTER INDEX.
>>
>>Is that what you mean?
>
>I see that this gives a SQL results of some activities. I see that the number of records, those ones added at the end, seems to be related to an indexing in progress. But, that doesn't give anything in regards to the progress. I am looking for something that will show something like 10% ...20%... etc.
>
>But, this is good to know. Thanks for having shared that info.

I thought percent_complete in the dm_exec_requests table would be the percentage you seek.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform