We have problems deploying Sitecore update packages to our servers. Using Sitecore Update package wizard in a local machine to deploy master update package it takes about 70-90 seconds, but in development server it takes 7 minutes at least, and in production server it could take more than 10 minutes getting a timeout sometimes.
We are concerned about so huge difference of time between our locals machine and our servers, in consequence our deploy times takes more time than desired, and we would like to reduce it.
Our Update package is small, it contains about 2200 items, its size is 5500 kb. We don't have large media items.
Our development/production servers are in Azure as a virtual machine and we use Azure Sql Database. We have been monitoring them while deploying update package and all resources are far from max capacity, CPU of VM is always under 30%, it has a lot of free ram, hard disk i/o are are low, network is low too and database DTU is around 20%. Our current Sitecore Version is 8.0 rev 1 50621
Any idea why is take so much time to deploy the update packages in our servers? Someone using azure as infrasctructure have faster update packages than us?
We've been done several tests in azure, with different service tiers. We have tested With S2, S3, and P4 Azure Sql database and there is not difference of time between them.
Our DB Team have checked Database all it seems Ok, monitoring it they have seen that sitecores opens two connections to Database and most of the time while Sitecore is doing deployment they are in awaiting command. As I said the VM is not out of resources. We have calculated that for our update package deploy Sitecore performs about 200.000 operations to Database (insert, deletes, updates,..).
We are starting to think about network latency problems, doing so many operations to database if latency is not very low could take sometime.