Basser Seminar Series

Performance Isolation in Multi-Tenant Relational Database-as-a-Service

Speaker: Dr Sudipto Das
Microsoft Research

When: Wednesday 27 May, 2015, 4:00-5:00pm

Where: The University of Sydney, School of IT Building, SIT Lecture Theatre (Room 123), Level 1

Add seminar to my diary

Abstract

Multi-tenancy and resource sharing are essential to make a Relational Database-as-a-Service (DaaS), such as Azure SQL Database, cost-effective. However, one major consequence of resource sharing is that the performance of one tenant's workload can be significantly affected by the resource demands of co-located tenants. In the SQLVM project at Microsoft Research, our approach to performance isolation in a DaaS is to isolate the key resources, such as CPU, I/O and memory, needed by the tenants' workload. The major challenge is in supporting this abstraction within a RDBMS for a wide variety of workloads and demands, without statically allocating resources, while ensuring low overheads and scaling to large numbers of tenants. Mechanisms designed in the SQLVM project are now in production and form an integral part of the Azure SQL Database Service Tiers and Performance Levels made generally available in September 2014.

More information about the project.

Speaker's biography

Sudipto Das is a Researcher in the Data Management, Mining, and Exploration (DMX) group at Microsoft Research (MSR). He received his Ph.D. in Computer Science from University of California Santa Barbara (UCSB). His research interests are in the broad area of scalable, distributed, and multi-tenant DBMSs for cloud platforms. His dissertation work was in the area of building scalable and elastic transactional data stores, for which he received the 2013 ACM SIGMOD Jim Gray Doctoral Dissertation Award and UCSB's 2012 Lancaster Dissertation award. Dr. Das is also the recipent of the CIDR 2011 Best Paper Award and MDM 2011 Best Runner-up Paper Award.