ezt logoEasyTerritory is the leading map-based application for territory mapping, sales and service productivity and spatial business intelligence for Microsoft Dynamics 365 and Excel.

EasyTerritory has customers in Europe as well as North America, many of which are Fortune 100 companies.  Their customers, across a broad range of industries, use their product to manage sales territories, orchestrate logistical challenges, and perform other geospatial visualization and analysis functions.

PROBLEM

EasyTerritory is hosted in Microsoft Azure.  The application architecture employs a common approach to managing multi-tenant data by isolating each customer’s data within a separate database.  With a database for each of their customers, Azure SQL Database costs were climbing dramatically as they grew their customer base.  A few of their larger and most active customers had complained of slow performance, which was determined to be due to the resources available to their databases.

SOLUTION

As part of our regular monthly service, Cloud Navigator was able to see these problems using a combination of tools including the Azure Management Portal and Microsoft Operations Management Suite. We reviewed their billing and saw that Azure SQL Database expenses were growing disproportionately to other expenses.  We saw that they had dozens of databases on a single server instance, which seemed a perfect scenario for elastic database pools.

In our monthly report to Easy Territory, we suggested that they consider using elastic database pools and explained how they work.  You can easily scale out Azure SQL databases using the Elastic Database tools. These tools and features let you use the virtually unlimited database resources of Azure SQL Database to create solutions for transactional workloads, and especially Software as a Service (SaaS) applications.

SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single Azure SQL Database server and share a set number of resources at a set price. Elastic pools in Azure SQL Database enable SaaS developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database.

RESULTS

EasyTerritory saw thousands of dollars of month in savings following their adoption of elastic database pools.

Just as importantly, a few of their larger most active customers saw performance problems eliminated.

RELATED INFORMATION

Introduction to elastic scaling in Azure SQL Database

Elastic Database Transaction Units (eDTUs)