Summary

In this chapter, you learned different ways of monitoring and tuning Azure SQL databases. You learned how to use Performance Metrics and Query Performance Insight to monitor database metrics and queries from the Azure portal. You also learned how to set up alarms on database metrics, and proactively took action as and when alarms were raised. Finally, you learned about important DMVs and set up extended events to monitor an Azure SQL Database.

Following this, you have learned to set up automatic tuning to automatically tune an Azure SQL Database, and you used in-memory OLTP to improve the performance of an OLTP workload.

Performance tuning is a vast topic and this book doesn't cover each and every aspect of the topic; however, it does give you insight into the available options. You can explore these options in detail to optimize your environment.

In this book, we addressed some important aspects of an Azure SQL Database instance such as migration, backup restorations, pricing policies...