Media Load Percentage
When media loads, we attempt to communicate an estimate of where in the process it is. We map this to a percentage but it is pretty horrible.
| Percentage | Meaning |
|---|---|
| <48% | Load.exe is currently processing the media.
|
| 48% | Load.exe has completed and only ETLs are now working.
|
| 60% - 69% | Poly files are being expanded in the ETL layer. |
| 70% - 74% | Summarizing ETLs are now executing. |
| 75% - 79% | Alerting ETLs are now executing. |
| 80% - 89% | Reporting ETLs (report generators) are now executing. |
| 90% - 93% | Feeding ETLs are now executing. |
| 94% | Finished.exe is refreshing database materialized views.
|
| 95% | Finished.exe is updating the [NumberOfChildren] column for each record in the [File] table for this media.
|
| 96% | Finished.exe is calculating the full path and updating the [FullPathID] column for each record in the [File] table for this media.
|
| 97% | Finished.exe is updating the file group counts for this media.
|
| 98% | Finished.exe is updating the [Statistics] table for this media.
|
| 99% | Finished.exe is generating the loader log file for this media.
|
| 100% | Everything is done. |
Load Percentages Less Than 48%
Load Percentage = (Number of Bytes Processed / Size of the Media) * .48
The formula for this calculation is 100% of the size of the media divided by the number of bytes processed scaled to 48%. You may see percentages well below 48% when Load.exe has skipped free space.
If you load a 100GB image, Load.exe will use divide the number of bytes processed by 100GB to determine the percent complete of the media.
It will then multiply that percentage by .48 to scale it to a number between 1 and 48.
If the 100GB image only contains 25GB of files and no freespace (75GB) is processed, you will see a media load percentage of 12% when Load.exe exits.
12 = ((25/100) * .48)
