I analyzed the site upgrade log file to find the elapsed time for various activities.
The process is trying to upgrade 5688 sub sites in the site collection.
For the initial sub sites, the elapsed time is ~20 to 30 seconds. However as the upgrade is progressing the elapsed time is increasing for each subsite to 2 to 3 minutes.
The biggest difference in execution time is for following steps
1. Provisioning the Design Gallery in site
Provisioning the Design Gallery in site:
<< URL of a subsite>>
[SPTree Value=SPSite Url=https://teststaff.nmit.vic.edu.au] added to dependency cache by lookup
[SPTree Value=SPSite Url=https://teststaff.nmit.vic.edu.au] added to dependency cache by lookup
[SPTree Value=SPSite Url=https://teststaff.nmit.vic.edu.au] added to dependency cache by lookup
End Upgrade()
Begin Commit()
End Commit()
Begin Dispose()
End Dispose()
SQL Query Count=48
SPRequest Objects=19
Execution Time=678.875806841372
Provisioning the Design Gallery in site: <<Url of a subsite>>
[SPTree Value=SPSite Url=https://teststaff.nmit.vic.edu.au] added to dependency cache by lookup
[SPTree Value=SPSite Url=https://teststaff.nmit.vic.edu.au] added to dependency cache by lookup
[SPTree Value=SPSite Url=https://teststaff.nmit.vic.edu.au] added to dependency cache by lookup
End Upgrade()
Begin Commit()
End Commit()
Begin Dispose()
End Dispose()
SQL Query Count=58
SPRequest Objects=1348
Execution Time=26429.550543435
2. Provisioning oslo.preview file in site
Provisioning oslo.preview file in site: nontoxic Site Url:
<< url of the subsite>>
Successfully provisioned oslo preview master page into the master page gallery.
End Upgrade()
Begin Commit()
End Commit()
Begin Dispose()
End Dispose()
SQL Query Count=6
SPRequest Objects=0
Execution Time=177.670346370838
Provisioning oslo.preview file in site: hortprac Site Url:
<< Url of the subsite>>
Successfully provisioned oslo preview master page into the master page gallery.
End Upgrade()
Begin Commit()
End Commit()
Begin Dispose()
End Dispose()
SQL Query Count=15
SPRequest Objects=1330
Execution Time=33145.8395550272
-
Edited by
Trupti G
Tuesday, October 29, 2013 2:07 AM