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.
I'm a SQL Server Consultant (MCTS, MCITP) at Kohera in Belgium, and have been working with SQL Server since 2000. I have a lot of experience with managing large databases in telecom and finance environments. Performance tuning, SQL audits, migrations and training are also part of the job. I have also a profound knowledge in implementing high availability and disaster recovery solutions (Microsoft Failover Clustering, AlwaysOn Availability Groups, Database Mirroring, …). I'm a regular speaker at events in Belgium like SQL Server Days, 12 hours of SQL 2012, Community Day and Microsoft TechNet Live Meetings.
The video is not available to view online.