Requirements
The client approached us as they developed a SaaS product which helps businesses simplify the process of moving goods overseas by streamlining import/export documentation and compliance.
Users were frequently reporting poor system performance, specifically when performing searches. There seemed to be no clear pattern for this. The client’s engineers had noticed occasional spikes in CPI usage without being able to identify the root cause.
Despite significant investment in Azure services, the performance issues have persisted, and the client needed Koderly to provide a Azure SQL Database health check to uncover the root cause of the performance bottlenecks, which would improve user satisfaction and reduce Azure spend.
Solution
We carried out a detailed SQL Server health check on the client’s Azure SQL database environment, and produced a report with recommendations to improve performance, including:
- Index tuning to optimise query performance
- Highlighting inefficient code patterns that were contributing to slow responses
- Identifying a security vulnerability within the database code
- Advising on best practices for query design and resource usage
Results
Following the health check and implementation of recommendations, the client saw:
- Improved performance across the platform, with faster response times and fewer timeouts
- Happier users, thanks to a smoother and more consistent experience
- Reduced cloud spend, with the ability to lower their Azure SQL service tier from four CPU vCores to two
By tuning and maintaining the database more effectively, the client was able to deliver a better product to their customers while making their Azure investment more cost-efficient.
