Drop the pressure on your production server
A few days ago I heard the song “Drop the pressure” of Mylo on the radio. Sometimes you should be able drop the pressure of a production server, like backups, SSIS packages or reporting, because they are putting a lot of load on the server. Actually, some of those features really don’t belong on a HA production OLTP Server. The AlwaysOn Availability Groups technology in Microsoft SQL Server 2012 includes a feature called readable secondary replicas. It allows you to perform all those actions and so dropping the workload on your production server. But how can you use this in practice?
In this session I will show you how to configure AlwaysOn Availability Groups for offloading reporting workload to a secondary replica. The new backup preferences of the availability groups will be showed in detail. I will also explain the factors that can affect the high availability, latency and the performance of your reporting workload.
Sorry, there are no downloads available for this session.
Pieter Vanhove is a SQL Server MVP and Database Consultant at
Kohera in Belgium and has been working with SQL Server since 2000. Performance
tuning, SQL audits, migrations and training are part of the job. Pieter has
also a profound knowledge in implementing high availability and disaster
recovery solutions and loves the new Azure stuff. Together with the SQLUG in
Belgium, he helps organizing SQL Server Days and is also a regular speaker at
Belgian and international events. Pieter recently won the Speaker Idol Contest at PASS Summit 2014.
The video is not available to view online.