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 15, Using Application Insights to Monitor Your Applications). You can access this functionality by clicking on the Alerts blade:

Here you have two types of alert available:

• Add metric alert...