This article aims to demonstrate the lesser-known impact of Always On Readable secondaries. In this article, we will not be going into how readable secondaries are configured and how read-only connections are directed to readable secondaries. Instead, we will take a peek under the hood and see what is happening when it is already configured. It is important to note that readable secondaries uses snapshot isolation and that comes at a price.
SQL Server Always On Availability Groups offers us an opportunity to offload read-only workloads onto readable secondaries. This is a great idea as we can now offload Reporting