Skip to content

Latest commit

 

History

History
130 lines (95 loc) · 12.8 KB

performance-guidelines-best-practices-checklist.md

File metadata and controls

130 lines (95 loc) · 12.8 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic tags
Checklist: Best practices & guidelines
Provides a quick checklist to review your best practices and guidelines to optimize the performance of your SQL Server on Azure Virtual Machines (VM).
bluefooted
pamela
mathoma, randolphwest
03/01/2024
virtual-machines-sql
performance
conceptual
azure-service-management

Checklist: Best practices for SQL Server on Azure VMs

[!INCLUDE appliesto-sqlvm]

This article provides a quick checklist as a series of best practices and guidelines to optimize performance of your SQL Server on Azure Virtual Machines (VMs).

For comprehensive details, see the other articles in this series: VM size, Storage, Security, HADR configuration, Collect baseline.

Enable SQL Assessment for SQL Server on Azure VMs and your SQL Server will be evaluated against known best practices with results on the SQL VM management page of the Azure portal.

For videos about the latest features to optimize SQL Server VM performance and automate management, review the following Data Exposed videos:

Overview

While running SQL Server on Azure Virtual Machines, continue using the same database performance tuning options that are applicable to SQL Server in on-premises server environments. However, the performance of a relational database in a public cloud depends on many factors, such as the size of a virtual machine, and the configuration of the data disks.

There's typically a trade-off between optimizing for costs and optimizing for performance. This performance best practices series is focused on getting the best performance for SQL Server on Azure Virtual Machines. If your workload is less demanding, you might not require every recommended optimization. Consider your performance needs, costs, and workload patterns as you evaluate these recommendations.

VM size

The checklist in this section covers the VM size best practices for SQL Server on Azure VMs.

[!INCLUDE vm size best practices]

Storage

The checklist in this section covers the storage best practices for SQL Server on Azure VMs.

[!INCLUDE storage best practices]

Security

The checklist in this section covers the security best practices for SQL Server on Azure VMs.

[!INCLUDE security best practices]

SQL Server features

The following is a quick checklist of best practices for SQL Server configuration settings when running your SQL Server instances in an Azure virtual machine in production:

Azure features

The following is a quick checklist of best practices for Azure-specific guidance when running your SQL Server on Azure VM:

HADR configuration

The checklist in this section covers the HADR best practices for SQL Server on Azure VMs.

[!INCLUDE HADR best practices]

Performance troubleshooting

The following is a list of resources that help you further troubleshoot SQL Server performance issues.

Related content

Consider enabling SQL Assessment for SQL Server on Azure VMs.

Review other SQL Server Virtual Machine articles at SQL Server on Azure Virtual Machines Overview. If you have questions about SQL Server virtual machines, see the Frequently Asked Questions.