IndexOptimize elapsed time in ssms different from "sum" in CommandLog #459
Answered
by
olahallengren
pasqualeceglie
asked this question in
Questions & Answers
-
|
Hi Ola, I've executed IndexOptimize on my db in a new blank query in SSMS. There is a consistent difference between the execution time in the query window and the sum of elapsed time (difference between the Endtime and StartTime column for every row). Thanks, |
Beta Was this translation helpful? Give feedback.
Answered by
olahallengren
Nov 29, 2020
Replies: 1 comment
-
|
It is only the ALTER INDEX and UPDATE STATISTICS commands, that are logged to the CommandLog table. The checks that are performed before these commands (e.g. querying sys.dm_db_index_physical_stats), are not included. |
Beta Was this translation helpful? Give feedback.
0 replies
Answer selected by
pasqualeceglie
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
It is only the ALTER INDEX and UPDATE STATISTICS commands, that are logged to the CommandLog table.
The checks that are performed before these commands (e.g. querying sys.dm_db_index_physical_stats), are not included.