SQL Services : Under the Hood

Play SQL Services : Under the Hood
Sign in to queue


Learn how we built SQL Server Data Services to address hard distributed systems and operations challenges. We describe how we solved problems like failure detection, leader election, and automatic failover using a new innovation called Distributed Data Fabric. We go deep and elaborate on the changes we made to the core SQL Server RDBMS to ship this massively scalable data service. We also describe the operational systems we use to provision, monitor, and manage SSDS without interrupting the service. Finally, learn how we manage and run this service in our datacenters.
  • Tony Petrossian
  • Gopal Kakivaya
    Gopal Kakivaya is an architect working on the SQL data services team and is responsible for the distributed algorithms employed by SQL data services to achieve scale, availability, consistency, and self-management. He is passionate about distributed systems and has been a significant contributor to many Microsoft technologies, including COM/DCOM, COM+, CLR, SOAP, Web services, and SQL.



Download this episode

The Discussion

Add Your 2 Cents