availability groups – Jess Pomfret

Collating index usage stats across Availability Group replicas

November 16, 2021November 15, 2021jpomfretLeave a comment

One of the benefits available to us when using SQL Server Availability Groups is that we can offload read activity to a secondary replica. This can be useful if we need to run reports against our OLTP databases. Instead of this taking up valuable resources on the primary instance we can make use of the…

Testing Availability Group Read-Only Routing with dbatools

September 7, 2018jpomfretLeave a comment

I recently set up an Availability Group with the intent of using the secondary as a read only replica for reporting. We have a few AG’s in our environment already but currently none are using this feature. I’m not going to step through setting up the AG or configuring the readable secondary as there are…