Skip to Main Content
SQL Server on Azure Virtual Machines
book

SQL Server on Azure Virtual Machines

by Joey D'Antoni, Louis Davidson, Allan Hirt, John Martin, Anthony Nocentino, Tim Radney, Randolph West
June 2020
Intermediate to advanced content levelIntermediate to advanced
200 pages
4h 4m
English
Packt Publishing
Content preview from SQL Server on Azure Virtual Machines

5. Performance

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. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Pro SQL Server on Microsoft Azure

Pro SQL Server on Microsoft Azure

Pranab Mazumdar, Sourabh Agarwal, Amit Banerjee

Publisher Resources

ISBN: 9781800204591