Tag: load-balancing

Post3 Types of Microsoft High Availability Technologies

Every now and then I get questions about how to implement load balancing with SQL Server databases. Because organizations want to maximize their IT investments, a standby server is almost always a red flag – it’s an idle asset. Hence, the questions about load balancing workloads on SQL Server databases to maximize the resource utilization on […]

PostProviding High Availability to SQL Server Reporting Services

One of the most common question I get asked is, “Can I use Windows Server Failover Clustering (WSFC) for SQL Server Reporting Services?” The primary intent behind this question is high availability. And when high availability is a requirement for a Microsoft product, the first thing that comes to mind is a WSFC. SQL Server Reporting Services […]

PostIntroducing the New SQL Server 2016 Availability Groups Load Balancing of Read-Only Replicas

About four years ago, I did my very first webcast on the Availability Groups feature in SQL Server 2012. The premise of the presentation was how we can provide high availability features to existing SQL Server workloads without making changes to the underlying storage. For my demo, I used an existing database mirroring configuration for high […]

Copyright © 2024 Learn SQL Server High Availability & Disaster Recovery

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close