Advertisement

Azure SQL Database: Performance and Monitoring

  • Pranab Mazumdar
  • Sourabh Agarwal
  • Amit Banerjee
Chapter

Abstract

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.

Keywords

Performance Level Logical Server Query Execution Extended Event Database Node 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Pranab Mazumdar, Sourabh Agarwal, Amit Banerjee 2016

Authors and Affiliations

  • Pranab Mazumdar
    • 1
  • Sourabh Agarwal
    • 1
  • Amit Banerjee
    • 1
  1. 1.BangaloreIndia

Personalised recommendations