Migrirajte na Innovate Summit:
Saznajte kako migracija i modernizacija na Azure može povećati performanse, otpornost i sigurnost poslovanja, omogućavajući vam da u potpunosti prihvatite umjetnu inteligenciju.Registrirajte se
Ovaj preglednik više nije podržan.
Nadogradite na Microsoft Edge da iskoristite najnovije osobine, sigurnosna ažuriranja i tehničku podršku.
This article provides an overview of SQL Server on Azure Virtual Machines (VMs) on the Windows platform.
If you're new to SQL Server on Azure VMs, check out the SQL Server on Azure VM Overview video from our in-depth Azure SQL video series:
Overview
SQL Server on Azure Virtual Machines enables you to use full versions of SQL Server in the cloud without having to manage any on-premises hardware. SQL Server virtual machines (VMs) also simplify licensing costs when you pay as you go.
Azure virtual machines run in many different geographic regions around the world. They also offer various machine sizes. The virtual machine image gallery allows you to create a SQL Server VM with the right version, edition, and operating system. This makes virtual machines a good option for many different SQL Server workloads.
Feature benefits
When you register your SQL Server on Azure VM with the SQL IaaS Agent extension you unlock a number of feature benefits. Registering with the extension is completely free.
The following table details the benefits unlocked by the extension:
Feature
Description
Azure portal management
Unlocks management in the portal, so that you can view all of your SQL Server VMs in one place, and enable or disable SQL specific features directly from the portal.
Automatically install Windows and SQL Server security updates (including Cumulative Updates for SQL Server) to your virtual machine during a configured maintenance window to avoid updating during peak times for your workload. For more information, see Automatic patching through Azure Update Manager.
You can configure your tempdb directly from the Azure portal, such as specifying the number of files, their initial size, their location, and the autogrowth ratio. Restart your SQL Server service for the changes to take effect.
Automatically receive security updates for your SQL Server on Azure VMs, up to three years after extended SQL Server lifecycle support ends.
Flexible licensing
Save on cost by seamlessly transitioning from the bring-your-own-license (also known as the Azure Hybrid Benefit) to the pay-as-you-go licensing model and back again.
Included with basic registration.
Flexible version / edition
If you decide to change the version or edition of SQL Server, you can update the metadata within the Azure portal without having to redeploy the entire SQL Server VM.
Included with basic registration.
I/O Analysis
View an analysis of your I/O performance in the Azure portal to find issues that result from exceeding virtual machines and data disks limits. This feature is currently in preview.
Enables you to assess the health of your SQL Server VMs by using configuration best practices. For more information, see SQL best practices assessment.
Requires SQL IaaS Agent extension.
View disk utilization in portal
Allows you to view a graphical representation of the disk utilization of your SQL data files in the Azure portal.
Requires SQL IaaS Agent extension.
Getting started
To get started with SQL Server on Azure VMs, review the following resources:
Connect to SQL VM: To connect to your SQL Server on Azure VMs, review the ways to connect.
Unlock feature benefits: Registering your SQL Server VM with the SQL IaaS Agent extension unlocks a number of feature benefits, such as automated backup and patching.
Manage SQL VM from the portal: You can manage SQL Server settings directly from the Azure portal by using the SQL virtual machines resource.
To get started, choose a SQL Server virtual machine image with your required version, edition, and operating system. The following sections provide direct links to the Azure portal for the SQL Server virtual machine gallery images. Change the licensing model of a pay-per-usage SQL Server VM to use your own license. For more information, see How to change the licensing model for a SQL Server VM.
Azure only maintains one virtual machine image for each supported operating system, version, and edition combination. This means that over time images are refreshed, and older images are removed. For more information, see the Images section of the SQL Server VMs FAQ.
It's possible to deploy an older image of SQL Server that isn't available in the Azure portal by using PowerShell. To view all available images by using PowerShell, use the following command:
Older images might be outdated. Remember to apply all SQL Server and Windows updates before using them for production.
Customer experience improvement program (CEIP)
The Customer Experience Improvement Program (CEIP) is enabled by default. This periodically sends reports to Microsoft to help improve SQL Server. There's no management task required with CEIP unless you want to disable it after provisioning. You can customize or disable the CEIP by connecting to the VM with remote desktop. Then run the SQL Server Error and Usage Reporting utility. Follow the instructions to disable reporting. For more information about data collection, see the SQL Server Privacy Statement.
Related products and services
Since SQL Server on Azure VMs is integrated into the Azure platform, review resources from related products and services that interact with the SQL Server on Azure VM ecosystem:
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.