Brent Ozar Unlimited has a couple whitepapers out about working with SQL Server in Google Compute Engine. First, Brent and Tara Kizer create an Availability Group:
In this white paper we built with Google, we’ll show you:
-
How to build your first Availability Group in Google Compute Engine
-
How to test your work with four failure simulations
-
How to tell whether your databases will work well in GCE
Erik Darling also has a whitepaper on performance tuning:
Relax. Have a drink. In this white paper we built with Google, we’ll show you:
-
How to measure your current SQL Server using data you’ve already got
-
How to size a SQL Server in Google Compute Engine to perform similarly
-
After migration to GCE, how to measure your server’s bottleneck
-
How to tweak your SQL Server based on the performance metrics you’re seeing
If you’re looking at GCE as a potential migratory spot, you’ve got some extra reading material.