Azure SQL Database: Performance and Monitoring
In the previous chapters, we talked about deploying the SQL Server instance in various combinations on an Azure Virtual Machine (Azure VM). We had touched upon a few of the best practices that would allow you to get an optimal configuration from the get-go. However, there might be scenarios where you would need to run health checks on your environment to ensure that is configured for optimal performance. Additionally, you might feel the need to run an impromptu health check while troubleshooting performance problems for a SQL Server instance running on an Azure VM. In this chapter, we will discuss the similarities and the differences that you would need to keep in mind while optimizing for performance for a SQL Server environment hosted on an Azure VM.