I have a number of Umbraco sites running in Azure with Azure SQL and occasionally I get an email come through from the Azure SQL Database Advisor with the following suggestion:
Target object: [dbo].[cmsDocument]
Recommended action: CreateIndex
Indexed columns: [published], [nodeId]
Estimated Index Impact: HIGH IMPACT
Is it safe to do this? Would this result in a genuine performance gain?
I'm no DBA, and not very familiar with Umbraco's database design so I'm not sure of the implications. Most importantly I don't want to break the upgrade path.
Any help would be great.
Also, if this is a genuine performance gain then I presume it would make sense to include this in Umbraco itself?
Azure SQL "index recommendation"
I have a number of Umbraco sites running in Azure with Azure SQL and occasionally I get an email come through from the Azure SQL Database Advisor with the following suggestion:
Target object: [dbo].[cmsDocument]
Recommended action: CreateIndex
Indexed columns: [published], [nodeId]
Estimated Index Impact: HIGH IMPACT
Is it safe to do this? Would this result in a genuine performance gain?
I'm no DBA, and not very familiar with Umbraco's database design so I'm not sure of the implications. Most importantly I don't want to break the upgrade path.
Any help would be great.
Also, if this is a genuine performance gain then I presume it would make sense to include this in Umbraco itself?
is working on a reply...