I am testing upgrade of a site collection to SharePoint 2013. The size of the content database is 225 GB. It has only one site collection.
This is a double hop upgrade. I have upgraded SP2007 sitecollection to SP2010 first.
On SP 2013 the Upgrade-SPSite is running now for 4 days and only 75% is completed.
The database is already cleaned up for document versions and audit log (clean up done in SP2007). The database is also shrinked (in SP 2007).
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
- Provisioning the Design Gallery in site
Provisioning the Design Gallery in site: << URL of a subsite>>
[SPTree Value=SPSite Url= added to dependency cache by lookup
[SPTree Value=SPSite Url= added to dependency cache by lookup
[SPTree Value=SPSite Url= 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.875806841372Provisioning the Design Gallery in site: <>
[SPTree Value=SPSite Url= added to dependency cache by lookup
[SPTree Value=SPSite Url= added to dependency cache by lookup
[SPTree Value=SPSite Url= 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
- 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.670346370838Provisioning 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