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.
Presented by Pieter Vanhove at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Pieter_Vanhove.png

    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.

    http://pietervanhove.azurewebsites.net
  • Video
    The video is not available to view online.