#Thankyou #TeamGeoPITS celebrated 3 years this June 15th. Read more about our journey here ➔

Case Studies

Leading HR Company reduces cloud computation cost by 30%

SQL Server Performance Consulting Reduced operational costs and improved application performance as a result of database audit and performance tuning.

Challenges

Our solution

Their current process did not allow optimal utilization of resources and hence leading to increasing cloud costs every month.
Our in-housing monitoring system was deployed on the DB servers to capture the performance baseline for all the queries, SPs and functions. Our system captures granular details about each configuration, queries and SPs.
Due to inefficient management of resources the client's application was running slow and causing unexpected downtimes due to application traffic.
Based on the recommendations of the audit report, the team started the optimisation process by correcting the required SQL configurations, tuning queries and SPs. Each change was carefully pushed and monitored. Version history of the changes made on the environment was maintained and the impact of each change was captured.
Once optimization process was completed, our DB team continued to monitor and track the SQL Server environment and the queries’ execution time to arrive at the new baselines for all the SPs & queries.

Benefits:

  • Reduced computation cost in cloud by 30%
  • Payslip download time brought down to 3 seconds from 55 seconds
  • Server was made stable and scalable which made it well-equipped to handle 300 more organisations' HR resource data in the consecutive year.

We run all kinds of DBA services that vow your success