Query rewrites enhance performance

Too many timeouts

Following rapid growth and high demand, Preqin’s systems were under extreme pressure. The quantity of data on its central RDS MSSQL database coupled with a surge in users was compromising performance. Lengthy page loads and report timeouts were causing problems for users.

Traffic analysis reveals problem queries

DevOpsGroup’s efforts to mitigate these issues began with web traffic analysis. We used Solarwinds DPA to monitor traffic and identify which query types ran most frequently and heavily against the database. Then we used Dynamic Management Views within the SQL server to ascertain where the issues lay.

Streamlining reduces page load times

To cut wait times and reduce strain on Preqin’s system, our engineers focused on making better use of Amazon RDS. This optimisation work has enabled internal and external applications using the database to operate more smoothly and reliably, providing a better customer experience.

Alongside the database optimisation, DevOpsGroup is providing Preqin with platform support whereby engineers tackle technical issues before they escalate. When an incident arises that can’t be dealt with in-house, it’s quickly passed on to our team for remediation. Our certified cloud engineers offer fast resolution of incidents, reducing mean-time-to-recover (MTTR) which improves system availability and reduces the risk of user disruption.

"DevOpsGroup quickly identified the root cause of the performance issues we were experiencing, then put effective measures in place to get us back on track."