Database Performance

Performance Tuning

Performance Tuning
Services
  • Database Performance Tuning
  • Database Health Check
  • Database Management
Year

2019

Visit

Client: Renewable innovator, OnGen Ltd


The client’s needs: To perform millions of calculations in real-time for their award-winning renewables calculation tool


The challenges: Understanding big data, complex SQL, and changing usage patterns to ensure accuracy

The solution: To really take performance to the next level for OnGen, our team performed an extensive analysis of the database usage to firstly find initial quick wins for the client. From here, we were able to push the boundaries further by implementing the use of Column Store Indexes, Covering Indexes, and Filtered Indexes.