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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2016 Pranab Mazumdar, Sourabh Agarwal, Amit Banerjee
About this chapter
Cite this chapter
Mazumdar, P., Agarwal, S., Banerjee, A. (2016). Azure SQL Database: Performance and Monitoring. In: Pro SQL Server on Microsoft Azure . Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-2083-2_10
Download citation
DOI: https://doi.org/10.1007/978-1-4842-2083-2_10
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-2082-5
Online ISBN: 978-1-4842-2083-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books