Paper Info
Title
A demonstration of SQLVM: performance isolation in multi-tenant relational database-as-a-service
Abstract
Sharing resources of a single database server among multiple tenants is common in multi-tenant Database-as-a-Service providers, such as Microsoft SQL Azure. Multi-tenancy enables cost reduction for the cloud service provider which it can pass on as savings to the tenants. However, resource sharing can adversely affect a tenant's performance due to other tenants' workloads contending for shared resources. Service providers today do not provide any assurances to a tenant in terms of isolating its performance from other co-located tenants. SQLVM, a project at Microsoft Research, is an abstraction for performance isolation which is built on a promise of reserving key database server resources, such as CPU, I/O and memory, for each tenant. The key challenge is in supporting this abstraction within a RDBMS without statically allocating resources to tenants, while ensuring low overheads and scaling to large numbers of tenants. This demonstration will show how SQLVM can effectively isolate a tenant's performance from other tenant workloads co-located at the same database server. Our demonstration will use various scripted scenarios and a data collection and visualization framework to illustrate performance isolation using SQLVM.
Year
DOI
Venue
2013
10.1145/2463676.2463686
SIGMOD Conference
Keywords
Field
DocType
microsoft research,key challenge,microsoft sql azure,co-located tenant,cloud service provider,key database server resource,database server,multi-tenant relational database-as-a-service,single database server,performance isolation,multiple tenant,cloud computing,multitenancy
SQL,Data mining,Relational database,Temporal isolation among virtual machines,Computer science,Multitenancy,Service provider,Relational database management system,Database server,Database,Cloud computing
Conference
Citations 
PageRank 
References 
8
0.47
5
Authors
6
Name
Order
Citations
PageRank
Vivek Narasayya11642173.24
Sudipto Das2109951.98
Manoj Syamala321811.94
Surajit Chaudhuri499711373.71
Feng Li52278.62
Hyunjung Park632013.71