BT

SQL Server is the New Hunting Ground in the Cloud

| by Elton Stoneman Follow 2 Followers on Aug 23, 2016. Estimated reading time: 2 minutes |

You can now run Microsoft SQL Server on Google's Cloud Platform, with a new service in beta. SQL Server has seen a recent focus from the major cloud providers. Amazon added native backups for SQL Server on AWS, and Microsoft built Stretch Database into SQL Server 2016, integrating on-premise databases seamlessly with Azure.

Google's new offering is at the IaaS level, with official public images running SQL Server on Windows Server that you can spin up as VMs on Google Compute Engine. Currently only Web and Standard versions of SQL are supported, although you can choose from SQL Server 2012, 2014 or 2016, and if you have Software Assurance from Microsoft you can bring your own license.

Users have to manage the database and the underlying Windows OS themselves, but Google focused on the performance levels available with their compute offering:

We're increasing the maximum read and write IOPS for SSD-backed Persistent Disk volumes from 15,000 to 25,000.

On Amazon's Relational Database Service (RDS), customers can run SQL Server as a managed, PaaS database, but storage performance is a maximum of 20,000 IOPS. (Microsoft doesn't publish IOPS values for Azure SQL Database, preferring their Database Transaction Unit, "DTU", metric which approximates real-world usage).

Google is positioning the new SQL Server capability as a straight migration path for enterprises currently running their own servers, as Dominic Preuss, Lead Product Manager says in his blog post:

We want enterprises with databases of all sizes and types to experience the best price-performance with the least amount of friction.

But the feature set at the IaaS level is lacking compared to the PaaS competition. Most significantly, to resize a database server on Google Cloud Platform, the VM needs to be taken offline. On Amazon RDS, users can resize a SQL Server database instance on the fly. On Azure SQL Database users can resize on the fly, and can also group multiple databases in an elastic pool to share compute resources.

The Google cloud is ramping up services to compete with the more established suites from Amazon and Microsoft. The existing PaaS database, Google Cloud SQL, is a managed relational database built on MySQL. Adding SQL Server expands Google's database offering. The current IaaS implementation from Google lacks the value-added features of the rival PaaS platforms, but it could be a welcome increase in choice for Microsoft users moving to the cloud.

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Educational Content

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT