Monitoring and tuning
The last item we cover in this chapter will be the monitoring and tuning of Azure SQL. Because databases are often the heart of many applications, it is crucial to have a quick way to diagnose any issues regarding performance or usage, and easily tweak things if needed. Azure SQL uses multiple different features that you can leverage to get insights from your instance.
Monitoring
To monitor your SQL database, you can use alerts, which should be familiar to you (assuming you have read the previous chapter, Chapter 16, Using Application Insights to Monitor Your Applications). You can access this functionality by clicking on the Alerts blade, as illustrated here:
Figure 17.31 – Alerts blade for Azure SQL
You can use Azure SQL alerts to cover the following things:
- Insufficient performance (metric)
- Invalid queries (metric)
- Configuration issues (metric)
- Overall...