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