Execution Details

SOLUTION
Atmosera focused the initial phase of the effort on debugging and optimizing the performance of the application and related databases. Much of the refactoring involved optimizing stored procedures to make the indexing strategy more efficient, as well as implementing changes with Queuing in the application.

For the database migration, the databases were moved from on-premises SQL Servers into Azure SQL. The Database Migration Assistant (DMA) tool was used after an initial earlier attempt using BacPac files showed poor efficiency.  The applications were migrated to Azure App Service as a PaaS solution. The charter from customer management was a basic two-phase effort:

• Application and SQL Performance Diagnostics: Identify the root cause of the performance issues, including a review of the Azure SQL instance, the application configuration, and the related application code. Additionally, recommend and assist in implementing appropriate telemetry and instrumentation to enable current and future discovery of performance issues.
• Azure Optimization: Analyze the cloud architecture, the code used to query the database, the application code, settings and configuration, and the configuration and settings of cloud resources to identify performance optimization areas. Implement and identify performance optimizations. Finally, migrate the remediated application and databases to Azure.

The choice of Azure Functions for a core part of the solution was a key success component. Serverless on Azure proved to scale amazingly well.

USER FLOW
The basic user flow is as follows:

• A franchisee drafts a new menu in the new Menu Manager portal application, accessible from anywhere.
• The administrator clicks Publish, which triggers a series of Azure functions that will validate the menu against inventory, corporate policies, tax information, and more.
• Once validation is successful, the new menu is staged in a set of respective databases.
• Once all databases have reported a successful stage, the current menu version is incremented to the new one. All new order transactions are directed to the new menu.

All of these tasks used to be performed using a monolithic application hosted on Windows servers that did not scale efficiently and could take many hours to process. This processing time has now been reduced to sub-minutes.

Why Atmosera?

The customer needed a partner that was an expert at providing the architectural, debugging, performance optimization, and application/database skills needed to take a mission critical enterprise system and make it flexible and performant, as well as the implementation expertise to deploy the production system to the Azure cloud.

• Atmosera has deep experience in application and SQL Database debugging and performance tuning, as well as in the development of these solutions.
• Atmosera is a Microsoft Gold Cloud Platform, Application Development, Data Platform, DevOps, and Data Analytics partner.
• Atmosera is a recognized leader in software architecture and implementation on the web, mobile, and cloud platforms.
• Atmosera places an emphasis on retail business and customizing solutions for this industry