Financial tech company gains SQL Server performance and scalability on Linux
The dv01 financial reporting and analytics platform offers institutional investors transparency and insight into consumer lending markets. Based initially on PostgreSQL and Redshift data warehouse, the dv01 applications began to run slower as complexity increased. After exploring multiple solutions, dv01 eventually moved to Microsoft SQL Server 2016 running on Azure Virtual Machines. This move provided the scalability it needed to handle rapid growth, reduce query response time from 30 seconds to 1–2 seconds, and cut management time by 90 percent. Because the firm runs all its other workloads on Linux, it is in the process of moving its databases to SQL Server 2017 to gain the benefit of the latest features and to avoid having to manage an environment with two operating systems.