DATE: Thursday, May 7, 2015
TIME: 12:00 pm - 1:00 pm
PLACE: RMCIC 4th Floor Panther Hollow Room

SPEAKER: Sudipto Das, Microsoft Research

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

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 tenant's 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 can be found at: http://research.microsoft.com/en-us/projects/sqlvm/.

BIO:
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.

VISITOR HOST: Andy Pavlo

SDI / ISTC SEMINAR QUESTIONS?
Karen Lindenfelser, 86716, or visit www.pdl.cmu.edu/SDI/

*partially funded by

A joint seminar with MCDS.