Stacking Part 2: Unlocking Your SQL Server Environment’s Instance-Stacking Potential

In my last post I talked about the risks and reservations that prevent SQL Server professionals from taking advantage of the instance stacking that Microsoft allows.

But I never mentioned the technology that has the power to turn the risk factor down and enable safe SQL Server instance stacking.

The answer is SQL Server instance containerization.

DxEnterprise container virtualization and management software has already been utilized for years in production SQL Server environments. The lightweight software allows you to decouple SQL Server instances from the underlying infrastructure to make them highly available and portable. The technology leverages standalone instances and allows you to move workloads between hosts while maintaining a consistent application endpoint.

Think how much easier management would be and how much you could save in licensing dollars if you could stack to the tune of a 8-15x reduction in OSes. Then the logical question becomes, what if there is an issue with one of my SQL Servers or some of my stacked instances don’t “play nice” together? First of all, all of your stacked instances are protected at the instance level by automated HA. Additionally, DxEnterprise QoS controls take automatic action to make sure all application instances are hosted on the machines that can meet their predefined SLAs.

Along with the cost savings and consolidation benefits, this technology also enables:

  • Clusters of 3+ nodes on ANY edition
  • Clusters of mixed OS/SQL versions
  • Ability to manage existing workload
  • Drag-and-drop modernization of infrastructure, OS, and application version

This SQL Server containerization technology is the only way to efficiently enable next-level consolidation and server utilization. It is battle-tested by organizations around the globe and is an easy addition to your technology stack—so schedule a demo to learn more or start your free trial today.

Connor Cox