When you’re working through some vague performance issues (e.g., “SQL Server seems slow today”), one of the common things to do is to collect some performance counters. If you are collecting performance counters for the first time on the server, you don’t have anything to compare them against. This usually leads to searching the web…
Month: August 2014
Rolling Upgrades With Availability Groups – A Warning
One of the great options provided by Availability Groups, in SQL Server 2012 Enterprise Edition and newer, is the ability to perform rolling upgrades to new Service Packs or Cumulative Updates. The basic idea is that you apply the update to one of the AG secondary servers and then perform a failover of SQL to…