---
title: Implementing High Availability and Workload Balancing Using SQL Server AlwaysOn Availability Groups
description: Learn how a software and data services organization implemented high availability and workload balancing using SQL Server AlwaysOn Availability Groups.
image: https://www.teamscs.com/hubfs/Website%20Build%20Images/Case%20Study%20Images/Two%20people%20on%20Computers.jpg
---
[Skip to main content](https://www.teamscs.com/superior-spotlight-blogs/case-studies/ha-always-on#main-content)
- [Power BI Consulting](https://www.teamscs.com/power-bi-enterprise)
- [Request a Quote](https://www.teamscs.com/discovery)
[ ](https://www.teamscs.com/old-homepage)
- Show submenu for Data Services Data Services
- [Data Unification](https://www.teamscs.com/data-unification)
- [Data Modeling](https://www.teamscs.com/data-modeling)
- [Data Visualization](https://www.teamscs.com/reporting-and-analytics)
- [Spatial Analytics](https://www.teamscs.com/gis-spatial-analytics)
- [Business Automation](https://www.teamscs.com/business-automation)
- [AI & Machine Learning](https://www.teamscs.com/ai-machine-learning)
- Show submenu for Technologies Technologies
- [Power BI & Analytics](https://www.teamscs.com/power-bi-enterprise)
- [Microsoft Fabric](https://www.teamscs.com/microsoft-fabric-consulting)
- [Microsoft Azure](https://www.teamscs.com/azure-services)
- [Power Apps & Power Automate](https://www.teamscs.com/power-apps-power-automate)
- Show submenu for Industries Served Industries Served
- [Community Corrections](https://www.teamscs.com/community-corrections)
- [Financial Institutions](https://www.teamscs.com/financial-institutions)
- [Government Contracting](https://www.teamscs.com/government-contracting)
- [HHS Departments](https://www.teamscs.com/county-hss-departments)
- [Insurance Companies](https://www.teamscs.com/insurance-industry)
- [Manufacturing](https://www.teamscs.com/manufacturing)
- [Nonprofits](https://www.teamscs.com/nonprofits)
- [SaaS Companies](https://www.teamscs.com/software-as-a-service)
- [Service Providers](https://www.teamscs.com/service-providers)
- Show submenu for About Us About Us
- [Meet the Team](https://www.teamscs.com/about)
- [The Superior Way](https://www.teamscs.com/superior-way)
- [Case Studies](https://www.teamscs.com/superior-spotlight-blogs/tag/case-studies)
- [Testimonials](https://www.teamscs.com/insights/testimonials)
- Show submenu for Training Training
- [Power BI & Fabric Training](https://www.teamscs.com/custom-training)
- [Online Courses](https://www.teamscs.com/learn-power-bi)
- [User Groups and Events](https://www.teamscs.com/user-groups-and-events)
- Show submenu for Resources Resources
- [Superior Blog](https://www.teamscs.com/superior-spotlight-blogs)
- [Published Books](https://www.teamscs.com/insights/resources)
- [Contact](https://www.teamscs.com/contact)
Open main navigation
Close main navigation
- Show submenu for Data Services Data Services
- Data Services
- [Data Unification](https://www.teamscs.com/data-unification)
- [Data Modeling](https://www.teamscs.com/data-modeling)
- [Data Visualization](https://www.teamscs.com/reporting-and-analytics)
- [Spatial Analytics](https://www.teamscs.com/gis-spatial-analytics)
- [Business Automation](https://www.teamscs.com/business-automation)
- [AI & Machine Learning](https://www.teamscs.com/ai-machine-learning)
- Show submenu for Technologies Technologies
- Technologies
- [Power BI & Analytics](https://www.teamscs.com/power-bi-enterprise)
- [Microsoft Fabric](https://www.teamscs.com/microsoft-fabric-consulting)
- [Microsoft Azure](https://www.teamscs.com/azure-services)
- [Power Apps & Power Automate](https://www.teamscs.com/power-apps-power-automate)
- Show submenu for Industries Served Industries Served
- Industries Served
- [Community Corrections](https://www.teamscs.com/community-corrections)
- [Financial Institutions](https://www.teamscs.com/financial-institutions)
- [Government Contracting](https://www.teamscs.com/government-contracting)
- [HHS Departments](https://www.teamscs.com/county-hss-departments)
- [Insurance Companies](https://www.teamscs.com/insurance-industry)
- [Manufacturing](https://www.teamscs.com/manufacturing)
- [Nonprofits](https://www.teamscs.com/nonprofits)
- [SaaS Companies](https://www.teamscs.com/software-as-a-service)
- [Service Providers](https://www.teamscs.com/service-providers)
- Show submenu for About Us About Us
- About Us
- [Meet the Team](https://www.teamscs.com/about)
- [The Superior Way](https://www.teamscs.com/superior-way)
- [Case Studies](https://www.teamscs.com/superior-spotlight-blogs/tag/case-studies)
- [Testimonials](https://www.teamscs.com/insights/testimonials)
- Show submenu for Training Training
- Training
- [Power BI & Fabric Training](https://www.teamscs.com/custom-training)
- [Online Courses](https://www.teamscs.com/learn-power-bi)
- [User Groups and Events](https://www.teamscs.com/user-groups-and-events)
- Show submenu for Resources Resources
- Resources
- [Superior Blog](https://www.teamscs.com/superior-spotlight-blogs)
- [Published Books](https://www.teamscs.com/insights/resources)
- [Contact](https://www.teamscs.com/contact)
- [Power BI Consulting](https://www.teamscs.com/power-bi-enterprise)
- [Request a Quote](https://www.teamscs.com/discovery)
### Case Study:
# Implementing High Availability and Workload Balancing Using SQL Server AlwaysOn Availability Groups
**Industry: Software and Data Services**
**Project Type: Power BI and Analytics**
**Tools Used: Microsoft’s newest offering in high-availability (HA) AlwaysOn Availability Groups for SQL**
### Easy-To-Use Tools
Collaborate seamlessly across devices from wherever you may be - whether you're in office, on the go, or making last-minute changes before your next meeting.
From start-to-finish, the design and strategy team provide all of the guidance and expertise necessary to build a high-conversion website.
Without rigid templates, you can build the exact type of website necessary to hit your website performance goals.
#### Project Overview
This client was a software and data services organization servicing the automotive recycling industry. They revolutionized the automotive recycling industry 80 years ago, and since then, the company’s innovative yard management, e-commerce, data, and sales and inventory solutions have been powering the industry. With a legacy of innovation, a forward-thinking culture and industry-leading employees, this company creates solutions that help auto recyclers be more productive and profitable.
The client needed to upgrade its core data services platform, EDEN, to more accurately and effectively synchronize data with external entities. This included expanding their parts catalog and providing critical high-availability and load-balancing capabilities for eLink, their custom solution for real-time inventory integration with eBay.
At the time, the process for synchronizing inventory between EDEN and eLink was causing resource consumption spikes and performance issues. While a rewrite of the EDEN API was planned for future release, the performance issues in the data platform required a more immediate resolution.
The upgraded EDEN platform also needed a method for synchronizing data with the existing legacy model, while application dependencies were gradually removed after the initial implementation.
#### Strategy and Solution
SCS designed a new platform, EDEN 3.0, incorporating AlwaysOn Availability Groups as part of the solution. AlwaysOn provides Enterprise-grade high availability and load balancing by creating readable, real-time transaction synchronized secondaries. With EDEN 3.0, the readonly API calls could now be rerouted to the AlwaysOn secondary via the listener service, while the eLink batch process executed against the writeable primary. The read-only API calls would then return data from the snapshot isolation level secondary instance with no locking issues during processing. The only code changes required for this implementation were appending ApplicationIntent = READONLY to the API connection string.
SCS also designed a migration strategy for the existing environment that eliminated the need for bulk migration and EDI and instead leveraged distributed database views. The distributed views allowed for T-SQL statements to be simultaneously executed against the new and legacy platforms with minimal performance impact. Data inserts and transfers were then handled logically in the view definition, rather than using triggers to route changes to the appropriate legacy or EDEN 3.0 model. The query statements issued from the EDEN client, PowerLink, then required no refactoring as a result of this architecture design, with the source views being completely transparent to the calling applications.
#### The Results
The client now has a modern data platform that they can utilize to build out their next generation of SaaS products. The added value of an expanded product catalog, along with 24/7 high availability for customers throughout North America assures their leadership in the marketplace for years to come.
In addition, SCS worked across the entire organization to ensure that the data platform specifications met requirements from the Product team, as well as implementation standards from the Project Management, Enterprise IT Operations, Enterprise Architecture, and Development teams. SCS shared many best practices around SQL Server database administration and multi-tenancy models that were new to the company, but quickly adopted and championed by both the DBAs and Enterprise Architect.
#### **Improve Your Performance and Profitability Today**
SCS uses best-in-class tools to deliver database, reporting and data platform and analytics solutions. We partner with your team to develop custom solutions.
[Get Started](https://www.teamscs.com/contact)
[](https://www.teamscs.com/old-homepage)
350 West Burnsville Parkway, Suite 550
Burnsville, MN 55337
[scs@teamscs.com](mailto:scs@teamscs.com)
[952.890.0606](tel:9528900606)
-
-
-
- [Careers](https://www.teamscs.com/superior-consulting-careers)
- [Power BI Consulting and Support](https://www.teamscs.com/power-bi-enterprise)
- [Fabric Consulting](https://www.teamscs.com/microsoft-fabric-consulting)
- [Azure Services](https://www.teamscs.com/azure-services)
- [Power Apps & Power Automate Services](https://www.teamscs.com/power-apps-power-automate)
- [Data Unification & Modernization](https://www.teamscs.com/data-unification)
- [Data Modeling](https://www.teamscs.com/data-modeling)
- [Reporting & Analytics](https://www.teamscs.com/reporting-and-analytics)
- [GIS & Spatial Analytics](https://www.teamscs.com/gis-spatial-analytics)
- [Business Automation & Workflow](https://www.teamscs.com/business-automation)
- [Government Contracting](https://www.teamscs.com/government-contracting)
- [HHS Departments](https://www.teamscs.com/county-hss-departments)
- [Community Corrections](https://www.teamscs.com/community-corrections)
- [Manufacturing](https://www.teamscs.com/manufacturing)
- [Insurance Companies](https://www.teamscs.com/insurance-industry)
- [Financial Institutions](https://www.teamscs.com/financial-institutions)
- [Nonprofits](https://www.teamscs.com/nonprofits)
- [Service Providers](https://www.teamscs.com/service-providers)
- [SaaS Companies](https://www.teamscs.com/software-as-a-service)
Copyright © 2026 Superior Consulting Services | All Rights Reserved | [Privacy Policy](http://23673295.hs-sites.com/privacy-policy) | [Terms of Use](https://www.teamscs.com/terms-of-use) | Minneapolis Web Design by Bizzyweb
```json
{
"@context" : "https://schema.org",
"@type" : "BlogPosting",
"author" : {
"@type" : "Person",
"name" : "Team SCS",
"url" : "https://www.teamscs.com/superior-spotlight-blogs/author/clearedge"
},
"dateModified" : "2023-07-17T17:16:10.246Z",
"datePublished" : "2023-07-07T18:14:24.000Z",
"headline" : "Implementing High Availability and Workload Balancing Using SQL Server AlwaysOn Availability Groups",
"image" : [ "https://www.teamscs.com/hubfs/Website%20Build%20Images/Case%20Study%20Images/Two%20people%20on%20Computers.jpg" ],
"mainEntityOfPage" : {
"@id" : "https://www.teamscs.com/superior-spotlight-blogs/case-studies/ha-always-on",
"@type" : "WebPage"
},
"publisher" : {
"@type" : "Organization",
"logo" : {
"@type" : "ImageObject",
"url" : "https://www.teamscs.com/hubfs/SCS_2015_LOGO.svg"
},
"name" : "Superior Consulting Services"
}
}
```