{"id":967224,"date":"2023-11-08T14:29:56","date_gmt":"2023-11-08T22:29:56","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/research\/?post_type=msr-project&#038;p=967224"},"modified":"2023-11-08T14:29:58","modified_gmt":"2023-11-08T22:29:58","slug":"fra-flexible-resource-allocation-in-multi-tenant-relational-database-as-a-service","status":"publish","type":"msr-project","link":"https:\/\/www.microsoft.com\/en-us\/research\/project\/fra-flexible-resource-allocation-in-multi-tenant-relational-database-as-a-service\/","title":{"rendered":"FRA: Flexible Resource Allocation in Multi-Tenant Relational Database-as-a-Service"},"content":{"rendered":"<section class=\"mb-3 moray-highlight\">\n\t<div class=\"card-img-overlay mx-lg-0\">\n\t\t<div class=\"card-background bg-gray-200 has-background- card-background--full-bleed\">\n\t\t\t\t\t<\/div>\n\t\t<!-- Foreground -->\n\t\t<div class=\"card-foreground d-flex mt-md-n5 my-lg-5 px-g px-lg-0\">\n\t\t\t<!-- Container -->\n\t\t\t<div class=\"container d-flex mt-md-n5 my-lg-5 \">\n\t\t\t\t<!-- Card wrapper -->\n\t\t\t\t<div class=\"w-100 w-lg-col-5\">\n\t\t\t\t\t<!-- Card -->\n\t\t\t\t\t<div class=\"card material-md-card py-5 px-md-5\">\n\t\t\t\t\t\t<div class=\"card-body \">\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\n\n<h1 class=\"wp-block-heading\" id=\"fra-flexible-resource-allocation-in-multi-tenant-relational-database-as-a-service\">FRA: Flexible Resource Allocation in Multi-Tenant Relational Database-as-a-Service<\/h1>\n\n\n\n<p><\/p>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/section>\n\n\n\n\n\n<p>Oversubscription is an essential cost management strategy in multi-tenant, cloud Database-as-a-Service (DBaaS), and its importance is magnified by the emergence of serverless databases. In the FRA project, we have developed novel resource management techniques that enables cloud DBaaS providers to oversubscribe resources in DBaaS clusters while controlling the impact on performance and availability. The controls are realized at different levels in the cluster infrastructure: across cores within a single node, across nodes within a cluster, and across clusters within a data center.<\/p>\n\n\n\n<p>The concrete techniques proposed in this context were developed and validated in the context of a commercial service: Microsoft\u2019s Azure SQL Database. The project is a collaboration between Microsoft Research, the Azure SQL DB team, and has benefited from the contributions of multiple interns. A paper providing an overview of the project and key flexible resource allocation mechanisms and policies <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" href=\"https:\/\/nam06.safelinks.protection.outlook.com\/?url=https%3A%2F%2Fwww.vldb.org%2Fpvldb%2Fvol16%2Fp4202-narasayya.pdf&data=05%7C01%7Cviveknar%40microsoft.com%7C49ebe462cd5547bf373d08dbe0a7dd6e%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C638350783799374777%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=2bMWXZzwaVOkkM4xjCO5327rNkcKbsnp72SJpGydzOk%3D&reserved=0\" target=\"_blank\" rel=\"noopener noreferrer\">appears in VLDB 2024 (opens in new tab)<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>. Additional publications covering specific aspects of the projects can be found in the Publications tab.<\/p>\n\n\n\n<p><\/p>\n\n\n","protected":false},"excerpt":{"rendered":"<p>Oversubscription is an essential cost management strategy in multi-tenant, cloud Database-as-a-Service (DBaaS), and its importance is magnified by the emergence of serverless databases. In the FRA project, we have developed novel resource management techniques that enables cloud DBaaS providers to oversubscribe resources in DBaaS clusters while controlling the impact on performance and availability. The controls [&hellip;]<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"msr-url-field":"","msr-podcast-episode":"","msrModifiedDate":"","msrModifiedDateEnabled":false,"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"research-area":[13563],"msr-locale":[268875],"msr-impact-theme":[],"msr-pillar":[],"class_list":["post-967224","msr-project","type-msr-project","status-publish","hentry","msr-research-area-data-platform-analytics","msr-locale-en_us","msr-archive-status-active"],"msr_project_start":"","related-publications":[876645,965859,980217],"related-downloads":[],"related-videos":[],"related-groups":[957177],"related-events":[],"related-opportunities":[],"related-posts":[],"related-articles":[],"tab-content":[],"slides":[],"related-researchers":[{"type":"user_nicename","display_name":"Surajit Chaudhuri","user_id":33764,"people_section":"Related people","alias":"surajitc"},{"type":"user_nicename","display_name":"Arnd Christian K\u00f6nig","user_id":31427,"people_section":"Related people","alias":"chrisko"},{"type":"user_nicename","display_name":"Lukas Maas","user_id":38076,"people_section":"Related people","alias":"lumaas"},{"type":"user_nicename","display_name":"Luke Marshall","user_id":37386,"people_section":"Related people","alias":"lumarsha"},{"type":"user_nicename","display_name":"Ishai Menache","user_id":32116,"people_section":"Related people","alias":"ishai"},{"type":"user_nicename","display_name":"Vivek Narasayya","user_id":34602,"people_section":"Related people","alias":"viveknar"},{"type":"user_nicename","display_name":"Yi Shan","user_id":37980,"people_section":"Related people","alias":"shayi"},{"type":"user_nicename","display_name":"Manoj Syamala","user_id":32792,"people_section":"Related people","alias":"manojsy"},{"type":"user_nicename","display_name":"Vasileios Zois","user_id":38841,"people_section":"Related people","alias":"vazois"}],"msr_research_lab":[],"msr_impact_theme":[],"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/967224","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/types\/msr-project"}],"version-history":[{"count":8,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/967224\/revisions"}],"predecessor-version":[{"id":982932,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/967224\/revisions\/982932"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/media?parent=967224"}],"wp:term":[{"taxonomy":"msr-research-area","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/research-area?post=967224"},{"taxonomy":"msr-locale","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-locale?post=967224"},{"taxonomy":"msr-impact-theme","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-impact-theme?post=967224"},{"taxonomy":"msr-pillar","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-pillar?post=967224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}