The previous chapters have given you an understanding of SQL Server, the overall benefits of the various capabilities of SQL Server on Azure VMs, and how to get started with SQL Server on Azure VMs.
In this chapter, we will discuss SQL Server performance best practices and how you can achieve the best performance for your SQL Server workload. This chapter will be divided into three main parts:
- Performance best practices
- How to optimize SQL Server on Azure VMs
- Azure BlobCache
Let's begin by taking a look at the best practices to follow in order to get the most from your SQL Server.
Performance best practices
Performance tuning can be a broad and complex topic; however, migrating to Azure VMs can help simplify the process. ...