Optimizing Azure SQL Database with the Well-Architected Framework

Microsoft Azure SQL Database is a fully managed cloud database (PaaS) that handles many database management tasks without user intervention. Tasks such as patching, upgrading, taking backups, and monitoring can be configured to the specific needs of the workload and are performed in the background. Azure SQL Database runs the latest stable version of SQL Server and patched OS with 99.99% availability. The intelligent automated functions built into the database free up the user to focus on other important tasks.

Today I am introducing the Azure Well-Architected Service Guide for Azure SQL Database. Like other service guides, this guide for Azure SQL Database contains design considerations, checklists, and detailed configuration recommendations that can assist cloud architects in deploying optimal Azure SQL workloads in line with the guiding tenets of the Well-Architected Framework: security, reliability, cost management, performance efficiency, and operational excellence.

If you are still in the planning stages, this service guide can provide guidance to ensure your workload is optimal from the start. The design checklists provide clear recommendations to keep in mind as you plan your build. Each recommendation is accompanied by an explanation detailing why it is important. If your workload is already deployed and in use, this service guide can help you quickly identify additional opportunities for improvement.

Both the service guide and the Azure Well-Architected Review assessment can be used to analyze and optimize your specific workload by pillar and by service. The assessment asks a series of questions about your unique workload and configurations and provides guidance broken down by pillar and service as specified.

If you run into an issue where costs are exceeding expectations, or you are having concerns about security and need a quick resolution, it may be beneficial to start with the service guide where suggestions pertaining directly to Azure SQL database can be quickly identified. If you have more time and are looking for a thorough action plan catered to your specific workload, then I recommend taking the assessment. Either way, both self-service tools are invaluable and will help achieve your goals.

To learn more about the Well-Architected initiative, please click here.

About the Author

Jason Bouska is a Senior Software Engineer at Microsoft with over 20 years of industry experience. He is passionate about working with data at scale and has experience as a Database Architect and Administrator.