--- title: "Data Platform Modernisation: Your Options" description: We’ve seen increasing numbers of customers start data platform modernisation by moving some workloads to the public cloud. Here's our guide to the options available. image: https://blog.coeo.com/hubfs/COEO%20image%2022.jpg --- [![](https://www.coeo.com/wp-content/themes/coeo/images/logo.svg)](https://blog.coeo.com/) +44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) | [Client portal login](https://my.coeo.com) # Data Platform Modernisation: Your Options # The Coeo Blog ![James Boother](https://blog.coeo.com/hubfs/Profile%20photos/JamesBoCircle.jpg) **Updated: November 2020** At Coeo we are seeing increasing numbers of customers take their first steps towards modernising their data platforms by moving workloads to the public cloud. Here is our quick guide to the options available: ## ![Birds migrating](https://blog.coeo.com/hs-fs/hubfs/COEO%20image%2022.jpg?width=600&name=COEO%20image%2022.jpg) ## On-premises modernisation When running on premises, organisations have two options; running SQL Server directly on the hardware or virtualising the environment. Despite some reservations against doing this, most customers we work with have found that the flexibility virtualisation provides far outweighs the small performance penalty they pay (usually in the region of about 1-2% CPU and Memory). Virtualisation allows the customer to create logical separation of the environment. This means that they have more options in terms of running different versions of the platform to support an estate that is going through a modernisation process. It also means that where we may have had a single large cluster while running directly on the hardware, we are now able to virtualise onto more virtual servers. This allows us to create a logical separation between parts of the platform and make the impact of maintenance or unexpected outage less for the users. It is now rare for customers to solely upgrade on-premises, we are seeing our customers take a hybrid approach to modernisation. Whilst the ultimate destination for many of the applications is Software as a Service (SaaS), the applications that differentiate the business tend to go to PaaS in the absence of a suitable SaaS alternative. Therefore, it is common for cloud modernisation to form part of an on-premises modernisation approach.   ## Cloud modernisation The Infrastructure-as-a-Service (IaaS) cloud-based model is based on virtualisation but differs from on-premises virtualisation in that the company has no control over the physical host or the hypervisor on which their virtualised servers run. However, they can still log in, install the software they require and patch it. Customers have a choice to pay for their SQL Server licence on a pay-as-you-go basis where the SQL Server license is incorporated into the cost of the virtual machine. Alternatively, those with Software Assurance can exercise their License Mobility rights and use their Enterprise Core licenses to license the virtual machines. When using Azure SQL Database – Microsoft’s Platform-as-a-Service (PaaS) offering – administrators only have access to the database itself and not the underlying operating system and virtual machine. Typically, it’s cheaper to run than IaaS, which requires more infrastructure setup and fully licenced versions of SQL Server. We believe that Microsoft sees PaaS as the ultimate destination for its customers. Microsoft offers three services within its Azure SQL Database family: ### Single Database This option is particularly suitable for those looking to create and deploy new applications with short time to market constraints. There are two options for deploying a Single Database, the first being DTUs (a measure of performance that blends CPU, Memory, Data I/O and Log I/O). The workload will be throttled if it hits the service tier quota, and the application’s performance may start to suffer. The other option is to purchase based on vCores and Memory, under the vCore purchasing model. This enables storage and compute to be scaled independently whilst also allowing for more advanced purchasing methods. Our blog post “[New vCore purchasing option for Azure SQL Database](https://blog.coeo.com/new-vcore-purchasing-option-for-azure-sql-database)” explains these options in more detail.  ### Elastic Pools Rather than having an individual database with a set amount of DTUs, or vCores, a company may decide to group numerous databases into a pool that share those resources. This is especially useful if the databases have different peaks and troughs in their usage. If they all peak at the same time they run the risk of being throttled as they will run out of the resources within the pool, so it may be more cost-effective to consider a Single Database in this case. ### Managed Instance Microsoft’s newest offering; the customer has an instance of SQL Server they can deploy databases onto and a SQL Server Agent they can use to run scheduled jobs. It has been designed to simplify lift-and-shift migrations while still providing many of the benefits of PaaS. However, unlike a virtual machine, users don’t have access to the underlying operating system, but can make limited instance level configuration changes. Furthermore, Managed Instance is priced by vCores only, rather than DTUs. This option can be expensive and therefore tends to be more cost-effective for companies running large numbers of databases. You can find out more about Managed Instances and the features included on [Coeo’s blog](https://blog.coeo.com/azure-sql-database-managed-instances-will-be-a-game-changer).   ## Find out more You can find out more about data platform modernisation from the [Coeo Conversations podcast,](https://blog.coeo.com/podcast-data-platform-modernisation)our ['Overcoming Modernisation Challenges' webinar](https://info.coeo.com/modernisation-webinar) and our [modernisation whitepaper](https://info.coeo.com/data-platform-modernisation). Coeo offers an [Azure Data Platform Jumpstart](https://www.coeo.com/next-steps/azure-data-platform-jumpstart/), which is designed to help kick off modernisation programmes. [![Get Coeo's advice on Data Platform Modernisation](https://no-cache.hubspot.com/cta/default/3356718/0353808e-60e6-4d89-88be-ce17cf36a2e7.png)](https://cta-redirect.hubspot.com/cta/redirect/3356718/0353808e-60e6-4d89-88be-ce17cf36a2e7) ### Subscribe to Email Updates ## Related posts --- ### [Troubleshooting Ola Hallengren’s Maintenance Solution](https://blog.coeo.com/troubleshooting-ola-hallengrens-maintenance-solution) ### [Microsoft Purview's 14 Key Controls](https://blog.coeo.com/data-governance-with-azure-purview-empowering-your-data-governance-with-microsoft-purview-controls-a-comprehensive-guide) ### [Domain-Independent Windows Failover Cluster for SQL Server AlwaysOn Availability Group](https://blog.coeo.com/domain-independent-windows-failover-cluster-for-sql-server-alwayson-availability-group) ### [Three ways to profile data with Azure Databricks](https://blog.coeo.com/three-ways-to-profile-data-with-azure-databricks) ![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png) +44 (0)20 3051 3595 | info@coeo.com ## Contact Us By clicking submit below, you consent to allow Coeo to store and process the personal information submitted above to provide you the content requested. You may unsubscribe from these communications at any time. For more information on how to unsubscribe and our commitment to your privacy, please review our **[Privacy Policy](https://www.coeo.com/privacy/)**. ## Upcoming Events [See all events](https://www.coeo.com/events/) #### NOW Building, Thames Valley Park Drive, Reading, RG6 1RB [![](https://www.coeo.com/wp-content/themes/coeo/images/social-glass.png)](https://www.glassdoor.co.uk/Overview/Working-at-Coeo-EI_IE959052.11,15.htm)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-in.png)](https://www.linkedin.com/company/coeo-ltd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-twitter.png)](https://twitter.com/CoeoLtd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-fb.png)](https://www.facebook.com/coeoltd/) ![](https://www.coeo.com/wp-content/themes/coeo/images//menu-icon.png) ![](https://www.coeo.com/wp-content/themes/coeo/images//menu-close.png) ![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png) +44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) - [Solutions](https://www.coeo.com/solutions/) - [Next Steps](https://www.coeo.com/next-steps/) - [Dedicated Support](https://www.coeo.com/dedicated-support/) - [Case studies](https://www.coeo.com/case-studies/) - [Technologies](https://www.coeo.com/solutions/technologies/) - [Industries](https://www.coeo.com/industries/) - [Finance](https://www.coeo.com/industries/finance/) - [Retail](https://www.coeo.com/industries/retail/) - [Technology](https://www.coeo.com/industries/technology/) - [The Team](https://www.coeo.com/people/) - [Join Us](https://www.coeo.com/careers/) - [Graduate Programme](https://www.coeo.com/graduate-programme/) - [About Coeo](https://www.coeo.com/about-coeo/) - [The Coeo Blog](https://www.coeo.com/blog/) - [Contact us](https://www.coeo.com/contact-us/) - [Privacy Notice](https://www.coeo.com/privacy/) - [Cookie Policy](https://www.coeo.com/privacy#Cookie_Policy) - [Events](https://www.coeo.com/events) Sign up to our newsletter ![go arrow](https://www.coeo.com/wp-content/themes/coeo/images/newsletter-go.png) Back to top