SQL Server 2012 AlwaysOn – Part 12 – Performance Aspects and Performance Monitoring II

[Edit] You can find the summary of the complete series here. Moving to synchronous availability mode One thing we are not measuring in our tests with asynchronous availability mode is the impact of latency to transport the changes over to the secondary replicas. Looking in an earlier blog where we described the principle mechanisms of… Read more

SQL Server 2012 AlwaysOn – Part 11 – Performance Aspects and Performance Monitoring I

[Edit] You can find the summary of the complete series here. In this part of the series we want to look a bit more into performance aspects in deploying AlwaysOn and the way how one can monitor the requirements and also the impact of AlwaysOn. What are potential impacts? Independent on the Availability Mode being… Read more

AlwaysOn Part 10: Switching Scheduled tasks automatically

As we talked about leveraging Log-Shipping together with AlwaysOn in Part #10, it became apparent that one would need to enable or disable scheduled tasks automatically on the primary and secondary replica in order to: · Not flood the history files of the job with error messages telling that a backup can’t be taken from… Read more

AlwaysOn Part 9: AlwaysOn and Logshipping

[Edit] You can find the summary of the complete series here. In this part we want to talk about some scenarios where AlwaysOn and Log-Shipping is getting combined. The two scenarios we want to look into particularly would be: Despite the fact that we are using our 3-node AlwaysOn configuration (one primary and two secondary)… Read more

SQL Server 2012 AlwaysOn – Part 8 – Failover Mechanism with SAP Netweaver

[Edit] You can find the summary of the complete series here. In part 8 of our series we want to look a bit behind the scenes how the SAP reconnect works together with the AlwaysOn. In part #7 we referenced already to failover exercises. We need to distinguish two parts. First is the SAP part… Read more

SQL Server 2012 AlwaysOn – Part 7 – Details behind an AlwaysOn Availability Group

[Edit] You can find the summary of the complete series here. Version 2.0 – Correcting Failure Condition Level explanations After having created our first Availability Group, we now want to go behind the scenes and into the details of what does happen when creating an Availability Group. As we discussed in earlier parts, WSFC plays… Read more

SQL Server 2012 AlwaysOn – Part 6 – Building an AlwaysOn Availability Group

[Edit] You can find the summary of the complete series here. Version 2.0 Added necessary step to change JDBC connection string After having the primary and replica instances prepared for AlwaysOn as described in the former part by having copied, restored and synchronized the databases between the replicas and having synchronized the logins as described… Read more

SQL Server 2012 AlwaysOn – Part 5 – Preparing to build an AlwaysOn Availability Group

[Edit] You can find the summary of the complete series here. Version 3.0 of article: please note additional links under ‘Preconditions for Windows’ pointing to lists of Cluster QFE fixes Version 2.0 of article. Please note the changes around modification in the Stored procedure referenced to earlier and a new Stored Procedure which now is… Read more

SQL Server 2012 AlwaysOn – Part 4 – SAP configuration in Geo-Cluster configuration

[Edit] You can find the summary of the complete series here. In the fourth part of the series, we are looking at a last reference configuration before moving to the actual doing part. In regards to terms and basics it might be very helpful to read the first part of the series here: http://blogs.msdn.com/b/saponsqlserver/archive/2012/02/07/sql-server-2012-alwayson-what-is-it.aspx As… Read more

SQL Server 2012 AlwaysOn – Part 3 – SAP configuration with two Secondary Replicas

[Edit] You can find the summary of the complete series here. After having learned how AlwaysOn handles quorum detection and how a Standard SAP/SQL Server WSFC configuration can be used w/o large changes to the WSFC configuration increase availability of SQL the SAP database(s) by using non-shared disks, we want to look at another typical… Read more