Kategorie: databases

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 signifi
cant user input, but also fail to provide appropriate recommen
dations. 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
newmigration customers towards one optimal target. Experimental
results over a 9-month period from prospective and existing cus
tomers 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.

p3509-zhu.pdf (vldb.org)

p3509-zhu.pdf (vldb.org)

VLDB Endowment Inc.