From Evaluator Group Labs: How-to Guide on Building SQL Server Always on Availability Group Solutions
Camberley Bates, managing director at Evaluator Group, part of The Futurum Group family of companies, recaps the latest from the Evaluator Group Labs, a step-by-step how-to guide on building SQL Server Always On Availability Group (SQL Server AG) solutions using Intel Optane NVMe.
Cite this
Evaluator Group Labs has run numerous tests and benchmarks on Intel processors and Intel NVMe Optane SSDs. The latest was a series that documented best practices for building high performance SQL Server environments. Russ Fellows did a series of How-To-Videos outlining the team’s experiences and recommendations. Here is a short excerpt from the paper and the link to the videos. Enjoy!
How-to Guide on Building SQL Server Always on Availability Group Solutions
”Beginning with SQL Server 2016, SQL Server Basic Availability Group is available with SQL Server Standard Edition, enabling HA options for users at a significantly lower cost point.
SQL Basic Availability supports only two nodes, and the secondary cannot be used for queries or creating backups. Additionally, each availability group can contain a single database instance. The full featured, SQL Server Advanced AG supports up to 8 copies, with secondary copies available for read-only queries and backup creation, along with enabling an availability group to contain multiple database instances. SQL Server Advanced AG requires a SQL Enterprise license.
Another benefit of using SQL AG is that only a single SQL Server license is required for the primary (active) copy, with all other replicas (up to 8) requiring only Windows Server licensing. This enables highly available SQL Server solutions without incurring additional software licensing fees. No additional license costs are incurred when using SQL AG for highly available SQL Server, with both editions supporting HA failover using either asynchronous or synchronous replication.
In summary, Microsoft SQL Server Always on Availability Groups are a no-cost method of providing database high availability and consistency, that enables SQL Server applications to operate without failures even when individual systems fail. SQL AG relies upon a shared-nothing software architecture for HA, without imposing hardware requirements.”
Subscribe to The Weekly
The week's market signals, one email, no filler. Unsubscribe any time.
More from Camberley Bates
Enhancing Cyber-Resilience: A Multi-Layered Approach to Data Infrastructure, Protection, and Security
In our latest market brief, Enhancing Cyber-Resilience: A Multi-Layered Approach to Data Infrastructure, Protection, and Security , The Futurum Group, in partnership with Lenovo, explores how organizations can design resilient systems that reduce downtime, safeguard critical data, and empower lean…
Can Google Cloud Deliver on AI and EDA Storage Demands with NetApp?
Camberley Bates and Krista Case of The Futurum Group share insights on how NetApp and Google Cloud’s storage updates enable scalable, AI-ready, and compliance-aware cloud infrastructure.
Cloud Repatriation, AI Challenges and the Future of Enterprise Tech – Six Five Webcast – Infrastructure Matters
Camberley Bates, Keith Townsend, and Dion Hinchcliffe delve into cloud repatriation, AI challenges, and the evolving dynamics of enterprise technology, offering valuable insights on the future of the sector.