Tag Archives | AvailabilityGroups

Improving Performance When Querying Multiple DMVs

A couple of days ago I posted a stored procedure (sp_GetAGInformation) which queried multiple DMVs to pull together a bunch of AvailabilityGroup information. If you took a look at the code you would see that it used a couple of CTEs (Common Table Expressions). CTEs are a great way to do recursive work, and they […]

Continue Reading 1

sp_GetAGInformation – Updated

Yesterday I posted sp_GetAGInformation, a stored procedure for gathering information about configuration of Availability Groups. Based on feedback I’ve added an additional column to indicate the health state of the AG.   Download the updated version for this additional information.

Continue Reading 3

Traffic Flow With Read-Intent Routing

One of the big advantages to using SQL Server Availability Groups is the ability to automatically push read traffic over to a secondary server. This is particularly useful for larger queries that would take a few seconds to run and consume large amounts of resources. It’s not something recommended for short, fast queries, just because […]

Continue Reading 1