{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,8]],"date-time":"2026-04-08T09:01:22Z","timestamp":1775638882600,"version":"3.50.1"},"reference-count":52,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2022,8]]},"abstract":"<jats:p>Selecting the optimal cloud target to migrate SQL estates from on-premises to the cloud remains a challenge. Current solutions are not only time-consuming and error-prone, requiring significant user input, but also fail to provide appropriate recommendations. We present Doppler, a scalable recommendation engine that provides right-sized Azure SQL Platform-as-a-Service (PaaS) recommendations without requiring access to sensitive customer data and queries. Doppler introduces a novel price-performance methodology that allows customers to get a personalized rank of relevant cloud targets solely based on low-level resource statistics, such as latency and memory usage. Doppler supplements this rank with internal knowledge of Azure customer behavior to help guide new migration customers towards one optimal target. Experimental results over a 9-month period from prospective and existing customers indicate that Doppler can identify optimal targets and adapt to changes in customer workloads. It has also found cost-saving opportunities among over-provisioned cloud customers, without compromising on capacity or other requirements. Doppler has been integrated and released in the Azure Data Migration Assistant v5.5, which receives hundreds of assessment requests daily.<\/jats:p>","DOI":"10.14778\/3554821.3554840","type":"journal-article","created":{"date-parts":[[2022,9,29]],"date-time":"2022-09-29T22:28:39Z","timestamp":1664490519000},"page":"3509-3521","source":"Crossref","is-referenced-by-count":8,"title":["Doppler"],"prefix":"10.14778","volume":"15","author":[{"given":"Joyce","family":"Cahoon","sequence":"first","affiliation":[{"name":"Microsoft"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Wenjing","family":"Wang","sequence":"additional","affiliation":[{"name":"Microsoft"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Yiwen","family":"Zhu","sequence":"additional","affiliation":[{"name":"Microsoft"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Katherine","family":"Lin","sequence":"additional","affiliation":[{"name":"Microsoft"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Sean","family":"Liu","sequence":"additional","affiliation":[{"name":"Microsoft"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Raymond","family":"Truong","sequence":"additional","affiliation":[{"name":"Microsoft"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Neetu","family":"Singh","sequence":"additional","affiliation":[{"name":"Microsoft"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Chengcheng","family":"Wan","sequence":"additional","affiliation":[{"name":"University of Chicago"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Alexandra","family":"Ciortea","sequence":"additional","affiliation":[{"name":"Microsoft"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Sreraman","family":"Narasimhan","sequence":"additional","affiliation":[{"name":"Microsoft"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Subru","family":"Krishnan","sequence":"additional","affiliation":[{"name":"Microsoft"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2022,9,29]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1504\/IJBIS.2017.080948"},{"key":"e_1_2_1_2_1","unstructured":"Amazon.com Inc. 2022. Amazon Web Service. Retrieved Jan 4 2022 from https:\/\/aws.amazon.com\/  Amazon.com Inc. 2022. Amazon Web Service. Retrieved Jan 4 2022 from https:\/\/aws.amazon.com\/"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1109\/CLOUD.2014.98"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1109\/CLOUD.2013.128"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1109\/MESOCA.2012.6392602"},{"key":"e_1_2_1_6_1","first-page":"3","article-title":"STL: A seasonal-trend decomposition","volume":"6","author":"Cleveland Robert B","year":"1990","unstructured":"Robert B Cleveland , William S Cleveland , Jean E McRae , and Irma Terpenning . 1990 . STL: A seasonal-trend decomposition . J. Off. Stat 6 , 1 (1990), 3 -- 73 . Robert B Cleveland, William S Cleveland, Jean E McRae, and Irma Terpenning. 1990. STL: A seasonal-trend decomposition. J. Off. Stat 6, 1 (1990), 3--73.","journal-title":"J. Off. Stat"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/1807128.1807152"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/3471485.3471492"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376732"},{"key":"e_1_2_1_10_1","unstructured":"Gartner. 2019. Gartner Says the Future of the Database Market Is the Cloud. https:\/\/www.gartner.com\/en\/newsroom\/press-releases\/2019-07-01-gartner-says-the-future-of-the-database-market-is-the. Accessed: 2022-02-28.  Gartner. 2019. Gartner Says the Future of the Database Market Is the Cloud. https:\/\/www.gartner.com\/en\/newsroom\/press-releases\/2019-07-01-gartner-says-the-future-of-the-database-market-is-the. Accessed: 2022-02-28."},{"key":"e_1_2_1_11_1","volume-title":"Market Share Database Management Systems Worldwide","year":"2020","unstructured":"Gartner. 2020. Market Share Database Management Systems Worldwide 2020 . https:\/\/www.gartner.com\/en\/documents\/4001330\/market-share-database-management-systems-worldwide-2020. Accessed: 2022-02-28. Gartner. 2020. Market Share Database Management Systems Worldwide 2020. https:\/\/www.gartner.com\/en\/documents\/4001330\/market-share-database-management-systems-worldwide-2020. Accessed: 2022-02-28."},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.jss.2016.06.068"},{"key":"e_1_2_1_13_1","first-page":"507","article-title":"Survey on service migration to cloud architecture","volume":"5","author":"Girish LS","year":"2014","unstructured":"LS Girish and HS Guruprasad . 2014 . Survey on service migration to cloud architecture . International Journal of Computer Science & Engineering Technology 5 (2014), 507 -- 510 . LS Girish and HS Guruprasad. 2014. Survey on service migration to cloud architecture. International Journal of Computer Science & Engineering Technology 5 (2014), 507--510.","journal-title":"International Journal of Computer Science & Engineering Technology"},{"key":"e_1_2_1_14_1","unstructured":"Google. [n.d.]. Google Cloud Platform. https:\/\/cloud.google.com. Accessed: 2022-01-25.  Google. [n.d.]. Google Cloud Platform. https:\/\/cloud.google.com. Accessed: 2022-01-25."},{"key":"e_1_2_1_15_1","unstructured":"The PostgreSQL Global Development Group. 2021. PostgreSQL. https:\/\/www.postgresql.org\/. Accessed: 2021-11-03.  The PostgreSQL Global Development Group. 2021. PostgreSQL. https:\/\/www.postgresql.org\/. Accessed: 2021-11-03."},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.2307\/2346830"},{"key":"e_1_2_1_17_1","volume-title":"Cloud migration research: a systematic review","author":"Jamshidi Pooyan","year":"2013","unstructured":"Pooyan Jamshidi , Aakash Ahmad , and Claus Pahl . 2013. Cloud migration research: a systematic review . IEEE transactions on cloud computing 1, 2 ( 2013 ), 142--157. Pooyan Jamshidi, Aakash Ahmad, and Claus Pahl. 2013. Cloud migration research: a systematic review. IEEE transactions on cloud computing 1, 2 (2013), 142--157."},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1007\/BF02289588"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1109\/APSCC.2010.44"},{"key":"e_1_2_1_20_1","volume-title":"Legacy to SOA evolution: a systematic literature review. Migrating Legacy Applications: Challenges in Service Oriented Architecture and Cloud Computing Environments","author":"Khadka Ravi","year":"2013","unstructured":"Ravi Khadka , Amir Saeidi , Andrei Idu , Jurriaan Hage , and Slinger Jansen . 2013. Legacy to SOA evolution: a systematic literature review. Migrating Legacy Applications: Challenges in Service Oriented Architecture and Cloud Computing Environments ( 2013 ), 40--70. Ravi Khadka, Amir Saeidi, Andrei Idu, Jurriaan Hage, and Slinger Jansen. 2013. Legacy to SOA evolution: a systematic literature review. Migrating Legacy Applications: Challenges in Service Oriented Architecture and Cloud Computing Environments (2013), 40--70."},{"key":"e_1_2_1_21_1","volume-title":"Workshop on E-Business. Springer, 110--123","author":"Klems Markus","year":"2008","unstructured":"Markus Klems , Jens Nimis , and Stefan Tai . 2008 . Do clouds compute? a framework for estimating the value of cloud computing . In Workshop on E-Business. Springer, 110--123 . Markus Klems, Jens Nimis, and Stefan Tai. 2008. Do clouds compute? a framework for estimating the value of cloud computing. In Workshop on E-Business. Springer, 110--123."},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.procs.2015.09.226"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.infsof.2010.12.005"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.14778\/3461535.3461549"},{"key":"e_1_2_1_25_1","unstructured":"Microsoft. 2021. Azure Data Factory. https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/introduction.  Microsoft. 2021. Azure Data Factory. https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/introduction."},{"key":"e_1_2_1_26_1","unstructured":"Microsoft. 2021. Azure Data Migration Assistant. https:\/\/docs.microsoft.com\/en-us\/sql\/dma\/dma-overview?view=sql-server-ver15.  Microsoft. 2021. Azure Data Migration Assistant. https:\/\/docs.microsoft.com\/en-us\/sql\/dma\/dma-overview?view=sql-server-ver15."},{"key":"e_1_2_1_27_1","unstructured":"Microsoft. 2021. Azure SQL Database. https:\/\/azure.microsoft.com\/en-us\/products\/azure-sql\/database\/.  Microsoft. 2021. Azure SQL Database. https:\/\/azure.microsoft.com\/en-us\/products\/azure-sql\/database\/."},{"key":"e_1_2_1_28_1","unstructured":"Microsoft. 2021. Azure SQL Database hyperscale. https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/service-tier-hyperscale.  Microsoft. 2021. Azure SQL Database hyperscale. https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/service-tier-hyperscale."},{"key":"e_1_2_1_29_1","unstructured":"Microsoft. 2021. Azure SQL Database Serverless. https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/serverless-tier-overview.  Microsoft. 2021. Azure SQL Database Serverless. https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/serverless-tier-overview."},{"key":"e_1_2_1_30_1","unstructured":"Microsoft. 2021. Azure SQL DB Resource Limits. https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/resource-limits-vcore-single-databases\/.  Microsoft. 2021. Azure SQL DB Resource Limits. https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/resource-limits-vcore-single-databases\/."},{"key":"e_1_2_1_31_1","unstructured":"Microsoft. 2021. Azure SQL Managed Instance. https:\/\/azure.microsoft.com\/en-us\/products\/azure-sql\/managed-instance\/.  Microsoft. 2021. Azure SQL Managed Instance. https:\/\/azure.microsoft.com\/en-us\/products\/azure-sql\/managed-instance\/."},{"key":"e_1_2_1_32_1","unstructured":"Microsoft. 2021. Azure SQL MI Resource Limits. https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/managed-instance\/resource-limits\/.  Microsoft. 2021. Azure SQL MI Resource Limits. https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/managed-instance\/resource-limits\/."},{"key":"e_1_2_1_33_1","unstructured":"Microsoft. 2021. Azure SQL Migration Guides. https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/migration-guides\/database\/sql-server-to-sql-database-overview.  Microsoft. 2021. Azure SQL Migration Guides. https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/migration-guides\/database\/sql-server-to-sql-database-overview."},{"key":"e_1_2_1_34_1","volume-title":"Azure SQL","year":"2021","unstructured":"Microsoft. 2021. Azure SQL October 2021 New Updates . https:\/\/www.youtube.com\/watch?v=dKgIqe0x6Bc&t=1542s. Microsoft. 2021. Azure SQL October 2021 New Updates. https:\/\/www.youtube.com\/watch?v=dKgIqe0x6Bc&t=1542s."},{"key":"e_1_2_1_35_1","unstructured":"Microsoft. 2021. SQL Server on Azure VM. https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/virtual-machines\/.  Microsoft. 2021. SQL Server on Azure VM. https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/virtual-machines\/."},{"key":"e_1_2_1_36_1","unstructured":"Microsoft. 2021. VCore Purchasing Model Overview. https:\/\/docs.microsoft.com\/en-Us\/azure\/azure-sql\/database\/service-tiers-sql-database-vcore. Accessed: 2021-10-25.  Microsoft. 2021. VCore Purchasing Model Overview. https:\/\/docs.microsoft.com\/en-Us\/azure\/azure-sql\/database\/service-tiers-sql-database-vcore. Accessed: 2021-10-25."},{"key":"e_1_2_1_37_1","unstructured":"Microsoft. 2022. Azure SQL Database pricing. https:\/\/azure.microsoft.com\/en-us\/pricing\/details\/azure-sql-database\/single\/\/.  Microsoft. 2022. Azure SQL Database pricing. https:\/\/azure.microsoft.com\/en-us\/pricing\/details\/azure-sql-database\/single\/\/."},{"key":"e_1_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.jmva.2016.07.003"},{"key":"e_1_2_1_39_1","volume-title":"Retrieved","author":"State of California Dept of Justice.","year":"2022","unstructured":"State of California Dept of Justice. 2022 . California Consumer Privacy Act . Retrieved Feb 23, 2022 from https:\/\/oag.ca.gov\/privacy\/ccpa. State of California Dept of Justice. 2022. California Consumer Privacy Act. Retrieved Feb 23, 2022 from https:\/\/oag.ca.gov\/privacy\/ccpa."},{"key":"e_1_2_1_40_1","unstructured":"Oracle. 2021. Oracle Database. https:\/\/www.oracle.com\/database\/. Accessed: 2021-11-03.  Oracle. 2021. Oracle Database. https:\/\/www.oracle.com\/database\/. Accessed: 2021-11-03."},{"key":"e_1_2_1_41_1","doi-asserted-by":"publisher","DOI":"10.1002\/smr.1712"},{"key":"e_1_2_1_42_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-24755-2_32"},{"key":"e_1_2_1_43_1","doi-asserted-by":"crossref","unstructured":"Santiago G\u00f3mez S\u00e1ez Vasilios Andrikopoulos Michael Hahn Dimka Karastoyanova Frank Leymann Marigianna Skouradaki and Karolina Vukojevic-Haupt. 2015. Performance and Cost Evaluation for the Migration of a Scientific Workflow Infrastructure to the Cloud.. In CLOSER. 352--361.  Santiago G\u00f3mez S\u00e1ez Vasilios Andrikopoulos Michael Hahn Dimka Karastoyanova Frank Leymann Marigianna Skouradaki and Karolina Vukojevic-Haupt. 2015. Performance and Cost Evaluation for the Migration of a Scientific Workflow Infrastructure to the Cloud.. In CLOSER. 352--361.","DOI":"10.5220\/0005458403520361"},{"key":"e_1_2_1_44_1","doi-asserted-by":"publisher","DOI":"10.14778\/3476311.3476362"},{"key":"e_1_2_1_45_1","volume-title":"Density estimation for statistics and data analysis","author":"Silverman Bernard W","unstructured":"Bernard W Silverman . 2018. Density estimation for statistics and data analysis . Routledge . Bernard W Silverman. 2018. Density estimation for statistics and data analysis. Routledge."},{"key":"e_1_2_1_46_1","volume-title":"Retrieved","author":"Benchmarks TPC","year":"2021","unstructured":"TPC Benchmarks . 2021 . TPC-C . Retrieved Aug 19, 2021 from http:\/\/tpc.org\/tpcc. TPC Benchmarks. 2021. TPC-C. Retrieved Aug 19, 2021 from http:\/\/tpc.org\/tpcc."},{"key":"e_1_2_1_47_1","volume-title":"Retrieved","author":"Benchmarks TPC","year":"2021","unstructured":"TPC Benchmarks . 2021 . TPC-DS . Retrieved Aug 19, 2021 from http:\/\/tpc.org\/tpcds. TPC Benchmarks. 2021. TPC-DS. Retrieved Aug 19, 2021 from http:\/\/tpc.org\/tpcds."},{"key":"e_1_2_1_48_1","volume-title":"Retrieved","author":"Benchmarks TPC","year":"2021","unstructured":"TPC Benchmarks . 2021 . TPC-H . Retrieved Aug 19, 2021 from http:\/\/tpc.org\/tpch. TPC Benchmarks. 2021. TPC-H. Retrieved Aug 19, 2021 from http:\/\/tpc.org\/tpch."},{"key":"e_1_2_1_49_1","volume-title":"Retrieved","author":"Union European","year":"2022","unstructured":"European Union . 2022 . General Data Protection Regulation . Retrieved Feb 23, 2022 from https:\/\/eur-lex.europa.eu\/legal-content\/EN\/ALL\/?uri=celex. European Union. 2022. General Data Protection Regulation. Retrieved Feb 23, 2022 from https:\/\/eur-lex.europa.eu\/legal-content\/EN\/ALL\/?uri=celex."},{"key":"e_1_2_1_50_1","doi-asserted-by":"publisher","DOI":"10.1109\/MIC.2010.147"},{"key":"e_1_2_1_51_1","first-page":"51","article-title":"Oracle's SQL Performance Analyzer","volume":"31","author":"Yagoub Khaled","year":"2008","unstructured":"Khaled Yagoub , Peter Belknap , Benoit Dageville , Karl Dias , Shantanu Joshi , and Hailing Yu . 2008 . Oracle's SQL Performance Analyzer . IEEE Data Eng. Bull. 31 , 1 (2008), 51 -- 58 . Khaled Yagoub, Peter Belknap, Benoit Dageville, Karl Dias, Shantanu Joshi, and Hailing Yu. 2008. Oracle's SQL Performance Analyzer. IEEE Data Eng. Bull. 31, 1 (2008), 51--58.","journal-title":"IEEE Data Eng. Bull."},{"key":"e_1_2_1_52_1","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3457569"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3554821.3554840","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T11:28:15Z","timestamp":1672226895000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3554821.3554840"}},"subtitle":["automated SKU recommendation in migrating SQL workloads to the cloud"],"short-title":[],"issued":{"date-parts":[[2022,8]]},"references-count":52,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2022,8]]}},"alternative-id":["10.14778\/3554821.3554840"],"URL":"https:\/\/doi.org\/10.14778\/3554821.3554840","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2022,8]]}}}