Google Cloud Platform (GCP) stepped up support for SQL Server Enterprise this week. They already offer Windows developers and IT administrators popular tools like Visual Studio and PowerShell, and the latest version of Windows Server on Google Compute Engine.
This week they announced pre-configured images for Microsoft SQL Server Enterprise and Windows Server Core on Compute Engine for even better high-availability and disaster recovery. Google Cloud now supports SQL Server AlwaysOn Availability Groups and persistent disk snapshots integrated with Volume Shadow Copy Service (VSS) on Windows Server. All of the Windows Server images are now enabled with Windows Remote Management support, including our Windows Server Core 2016 and 2012 R2 images.
SQL Server Enterprise Edition images on GCE
You can now launch Compute Engine VMs with Microsoft SQL Server Enterprise Edition pre-installed, and pay by the minute for SQL Server Enterprise and Windows Server licenses. Customers can also choose to bring their own licenses for SQL Server Enterprise.
Google Cloud supports pre-configured images for the following versions in Beta:
- SQL Server Enterprise 2016
- SQL Server Enterprise 2014
- SQL Server Enterprise 2012
|Supported SQL Server images available on Compute Engine (click to enlarge)|
SQL Server Enterprise targets mission-critical workloads by supporting more cores, higher memory and important enterprise features, including:
- In-memory tables and indexes
- Row-level security and encryption for data at rest or in motion
- Multiple read-only replicas for integrated HA/DR and read scale-out
- Business intelligence and rich visualizations on all platforms, including mobile
- In-database advanced analytics with R
Combined with Google’s world-class infrastructure, SQL Server instances running on Compute Engine benefit from price-to-performance advantages, highly customizable VM sizes and state-of-the-art networking and security capabilities. With automatic sustained use discounts and the prospect of retiring hardware and associated maintenance on the horizon, customers can achieve total costs lower than those of other cloud providers.
High-availability and disaster recovery for SQL Server VMs
Mission-critical SQL Server workloads require support for high-availability and disaster recovery. To achieve this, GCP supports Windows Server Failover Clustering (WSFC) and SQL Server AlwaysOn Availability Groups. AlwaysOn Availability Groups is SQL Server’s flagship HA/DR solution, allowing you to configure replicas for automatic failover in case of failure. These replicas can be readable, allowing you to offload read workloads and backups.
Compute Engine users can now configure AlwaysOn Availability Groups. This includes configuring replicas on VMs in different isolated zones as described in these instructions.
|A highly available SQL Server reference architecture using Windows Server Failover Clustering and SQL Server AlwaysOn Availability Groups (click to enlarge)|
Better backups with VSS-integrated persistent disk snapshots for Windows VMs
Being able to take snapshots in coordination with Volume Shadow Copy Service ensures that you get application-consistent snapshots for persistent disks attached to an instance running Windows — without having to shut it down. This feature is useful when you want to take a consistent backup for VSS-enabled applications like SQL Server and Exchange Server — without affecting the workload running on the VMs.
To get started with VSS-enabled persistent disk snapshots, select Snapshots under the Cloud Console Compute Engine page. There you’ll see a new check-box on the disk snapshot creation page that allows you to specify whether a snapshot should be VSS-enabled.
|(click to enlarge)|
This feature can also be invoked via the gcloud SDK and API, following these instructions.
Google Cloud’s expanded support for SQL Server images and high availability are the latest efforts to improve Windows support on Compute Engine, and to build a cloud environment for enterprise Windows that leads the industry. Last year the list of pre-configured images included SQL Server Standard, SQL Server Web and Windows Server 2016, and announced comprehensive .NET developer solutions, including a .NET client library for all GCP APIs through NuGet.