Are you planning to move your Microsoft SQL Server to a cloud?

Rodney Landrum, DBA/BI Consultant for Hosting/Ntirety and Tony Tomarchio, Director, Field Engineering SIOS Technology recently presented insights they have gained from helping hundreds of companies deploy SQL in cloud environments in their webcast Deploying SQL in the Cloud: 5 Things You Need to Know.

Here are five key tips that can save you money and ensure you get the most value from your cloud deployment.

  1. Measure your Existing Capacity

Gather your server metrics. Get a baseline for every server you plan on moving to the cloud.

  • Server Performance Metrics
  • Database Utilization
  • Server/Process Dependencies
  • Estimate you Cloud Tier

It is not always feasible to “Lift and Shift” your entire database application infrastructure.

Consider a consolidation strategy for non mission-critical applications first.

Invest in application redesign where possible to take advantage of Cloud scalability offerings. 

  1. Start Small

Consider starting with a small, low risk environment that allows the team to become familiar with the services and processes of the new Cloud environment.

Build an automated solution for spinning these down when not in use.

Continue to measure using Cloud-based performance analytics.

  1. Read Everything

Each Cloud provider has their own billing rates and cycles. Read all of the fine print.

  • Bring your own licenses or pay additional licensing fees
  • Know the cost of pulling data from the cloud
  • Know who is responsible for each service offering
  1. Remember you are still part of a Team

You will still need:

  • Network Admins
  • Storage Admins
  • DBAs
  • Developers
  • Help Desk
  1. Be the Master of your own Recoverability Option

Business Continuity options vary in the Cloud and like tier levels for servers, you will pay more for higher RTO and RPO.

Hybrid (On Premises and Cloud)

  • AlwaysOn Availability Groups (Enterprise Edition)
  • Database Mirroring (will be deprecated)
  • Log Shipping (limited and high administration overhead)
  • Backup and Restore (time consuming and requires manual intervention)

What about Failover Cluster Instances?

SIOS SANLess software is an easy, cost-efficient way to build clusters for cloud environments to protect your business critical applications from downtime and disasters. It lets you run your business critical applications such as SQL Server, SAP, and Oracle in a cloud, hybrid cloud, or mixed configuration and get high availability protection where shared storage is not possible.  SIOS SANLess clusters let you take full advantage of the flexibility and cost savings possible in these environments without sacrificing performance, availability or disaster protection.


Click here to view the full webcast.


Tony Tomarchio is the Director of Field Engineering for SIOS Technology. Tony is responsible for defining and delivering technical pre-sales services, support and best practices to SIOS customers, prospects and partners.

Rodney Landrum of Ntirety is a Microsoft MVP and holds MCSE1 and MCPS certifications and author of several technical guides for SQL Server administrators, including: SQL Server Tacklebox, Pro SQL Server 2012 Reporting Services, Pro SQL Server 2012, and Pro SQL Server 2008 Encryption.