SQL Services : Under the Hood

Download this episode

Download Video


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.



Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.