Database Performance

Performance Tuning

Performance Tuning
  • Database Performance Tuning
  • Database Health Check
  • Database Management



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.