Pythian’s database experts teamed up with Fergus’ in-house team to pinpoint the root cause of the performance issues they were experiencing. Through our Database Health Check, our experts determined the issue causing the slow load speed – it was caused by newly added recommended indexes and query rewrites. Our database experts conducted a full review of Fergus’ databases, covering everything from configuration assessments, slow query enhancements, table archiving suggestions, and implemented performance optimizations.
After testing the proposed solutions in Fergus’ controlled environment, we worked with Fergus’ teams to apply them to the production environment. To empower the customer’s technical teams, Pythian provided insight into our technical recommendations as they were being applied to the test environment. Pythian added comments in Fergus’ task tool with additional explanations and context behind the performance issues and fixes.