I believe progress tracking does not exist for validation. answered 11 Feb '19, 14:49 John Smirnios Replies hidden
2
Let's say I looked at the code the code and couldn't find any progress updates. I also don't remember adding progress support when I rewrote validation a long time. So, let's say there's no support for progress tracking but I want weasel words just in case I'm proven wrong :)
(11 Feb '19, 18:00)
John Smirnios
|
As John has pointed out, there are liekly no progress messages available during the validation of one single database object, say one huge table. However, if you do validate several objects in one go, say via the sa_validate() procedure, and you want to get progress messages telling which object is currently validated, and how long that takes, you can have a look at the "maintenance plans" created for validation with SQL Central: They contain SQL code that combines the validation of each according object with according MESSAGE statements and results in console output like: ... I. 13.02 03:04:59. Validation started on 2019-02-13 at 03:04:59.993 I. 13.02 03:04:59. Validating database pages I. 13.02 03:05:46. Validating table: "dbo"."EXCLUDEOBJECT" I. 13.02 03:05:46. Validating table: "dbo"."ix_consultant_affected_columns" ... I. 13.02 xx:xx:xx. Validating table: "SYS"."ISYSWEBSERVICE" I. 13.02 xx:xx:xx. Validation finished on 2019-02-13 at xx:xx:xx.yyy I. 13.02 xx:xx:xx. Re-enabling new connections started on 2019-02-13 at xx:xx:xx.yyy As stated, if a single message per object is sufficient, e.g. to find out what table make take particularly long, I guess that is a good starting point for your own code... answered 14 Feb '19, 07:09 Volker Barth |
What do you ask for:
the second use Case, getting Messages during a long running validation