Automatic scaling of Azure SQL Databases
Enable hosts most of its DealTrack clients in Microsoft Azure, taking advantage of the wide range of resources it offers, including Azure SQL Databases. In general, each DealTrack client will have their own SQL database within Azure containing their own data, varying wildly in usage patterns and performance needs. Unfortunately, this can make it difficult to decide on the appropriate performance tiers, often resulting in the over-provisioning of resources based on peak usage and over paying. Azure attempts resolve this issue by allowing these databases to be placed in an elastic pool, where all databases in said pool share resources, allowing performance to stay high while keeping costs low.
Enable has taken this one step further by taking advantage of these elastic pools, coupled with the fact that the performance tier of the elastic pools can be scaled dynamically without any down time for the system. We have implemented a solution capable of providing high performance as and when the system requires it, while scaling down the performance tier during periods of low activity.
This results in Enable being able to offer its clients a solution with a solid user experience and strong computational performance, while truly minimising the associated running costs.