Azure Insights: Azure SQL Database Advisor

Starting in Sitecore 8.2, Sitecore now supports Azure SQL, which offers a lot of benefits when it comes to scalability and maintainability of SQL Server in the cloud.   One of the overlooked benefits is the way a cloud application like Azure SQL can monitor and provide real-time feedback on application performance.

After running Azure SQL for a while, I started to receive recommendations from the Azure SQL Database Advisor.

capture

This service from Microsoft is analyzing the queries happening on my Sitecore databases and making recommendations that will improve the performance.  In this particular situation, Azure has discovered that adding an index to my VersionedFields table will have an impact that may be worth looking into.

Now, in talking with Sitecore support, it is worth noting that applying these changes may improve the performance on some queries while negatively impacting them in others.  The product has not been tested in this configuration, but creation of indexes should typically only benefit the application.

Author: Dan Persson

As the VP of Technology, Dan leads the MedTouch Product Team and is responsible for our healthcare modules for Sitecore as well as serving as a technical consultant to key clients. Dan has 15 years of experience with a variety of Content Management Software (CMS) tools and was instrumental in building the MedTouch Healthcare Accelerator Framework. He served as Technical Lead on several MedTouch award-winning sites, including The University of Kansas Hospital (Sitecore Healthcare Site of the Year Winner), Drexel Medicine (Interactive Media Awards, Hospital Best in Class 2012) and Providence Health & Services. Dan is a long-standing Sitecore certified developer and graduated from the University of Massachusetts, Amherst, with a B.S. in Computer Science.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s