Query rewrites enhance performance

CASE STUDY - Preqin

Preqin Logo

Founded in 2003, Preqin empowers alternative assets investors and advisors with data, insight and solutions. Today, it serves more than 90,000 industry professionals worldwide by leveraging insights from a database hosted on the AWS cloud platform.


Industry:

Venture Capital & Private Equity

Organisation Type:

Scale-Up

Service:

Platform Support


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."

Dave Boxall, Head of Information Security at Preqin

About Preqin

Preqin provides in-depth data and research to support their global client base in daily activities including fundraising, investor relations, asset allocation, portfolio management, fund manager selection and business development.

Platform Support

Find out how we can help you to resolve incidents faster and improve your system availability.

Find out more
Download the Preqin case study PDF!
Download PDF

Related success stories