CRM Reporting and SQL 2012 AlwaysOn Availability Groups – Better Together

The Problem A common issue that I have come across in CRM deployments, particularly for Enterprise customers, is deadlocking on the SQL server resulting in a degraded performance of our CRM environment. I’ve experienced severe impact of this deadlocking to the degree that other CRM SQL processes are aborted resulting in errors being presented to the…


Adam Caulkett

Hi Everyone! In September 2011, I joined Microsoft as a Consultant within the Microsoft Consulting Services Dynamics CRM UK team. My primary focus is the design and implementation of Dynamics CRM Infrastructure supporting primarily Enterprise customers. My roles since 2000 have ranged from a system engineer to consultant and support analyst roles across the Microsoft…