This chapter teaches you different techniques to monitor and tune an Azure SQL database. You will learn to monitor an Azure SQL Database using the Azure portal, Dynamic Management Views ( DMVs), and Extended Events.
You will also learn how to tune an Azure SQL Database using Automatic tuning and Query performance insight.
You will learn to implement in-memory features to improve workload performance.
By the end of this chapter, you will be able to:
Monitor and tune an Azure SQL Database from the Azure portal
Monitor an Azure SQL Database using Dynamic Management Views
Monitor an Azure SQL Database using Extended Events
Implement in-memory technologies to improve database performance