Database Optimization For Performance and Stability Operation Case Study

1. The Digital Group » Database Optimization Case Study Database Optimization Client Profile A leading provider of local community focused web applications with sites in more than 32 countries and over 600 cities. They are one of the fastest growing local community reach sites in the industry. Central to their offering is a housing share service which offers users the ability to post, search, and browse available units. The application performs a comparison of profile needs and provides updated category matches which users can view on demand or through automated emails. These services are delivered through a membership driven web based application and managed by local site administrators. Problem The core databases for the housing share solution were unstable and becoming more inconsistent as information and demand continued to increase. As new cities, countries, and application features were being added, the database integrity began to be noticeably affected and even resulted in frequent system downtime during critical peak activity periods. The client was losing revenue. The business objective was to engage in a focused database analysis and performance review that would deliver an executable plan to make the databases more efficient and reliable while delivering in the fastest time to production possible. Solution The Digital Group’s database performance experts reviewed the existing databases to capture a baseline from which to measure stability and performance gains, as well as to create an optimization plan that identified top level issues. The engineering team then executed an iterative process of performance tuning, indexing, and script optimization while tracking measured results at the end of each milestone. After stabilizing the system the team evaluated and implemented a database replication service that would signifi- cantly improve system performance while guaranteeing the platform’s stability without significantly impacting operational costs. After completing the performance and stability operation, The Digital Group took responsibility for ongoing moni- toring support and high level issue resolution. This activity is performed on a weekly basis from their Australia facility. Result Through the use of the database monitoring and performance program, the client was able to achieve and deliver a new level of service without having to make a heavy investment in an application re-write. As a result, their product now offers its users an unmatched level of performance and usability which is now helping them to secure an even stronger market position. INFORMATION TECHNOLOGY SOLUTIONS | SERVICES | CONSULTING

2. Some of the specific benefits achieved include: Operational cost savings » Utilizing high quality / low cost offshore resources » Avoidance of application re-write Reduced error rate and increased efficiency » Increased performance through optimized scripts & queries » Stability through replication » Ongoing system monitoring identifies problems early About us The Digital Group Inc. 121 Village Boulevard Princeton Forrestal Village, Princeton, NJ 08540 USA Headquartered in Princeton, New Jersey, The Digital Group was incorporated in 1999. Today The Digital Group (T/DG) is the leading provider of a broad range of Information Technology services. With offices in US, India, Australia, Fiji and Sri Lanka T/DG provide support from the conceptualization phase, leading to development and operations. The team have been consistently delivering industry leading solutions to its valued customers for over a decade. Phone: +1.609.524.2441 Fax: +1.609.228.4844 Email: info@thedigitalgroup.com The Digital Group is a certified SEI-CMMi Level 5 for Development (DEV) and CMMi Level 3 for Services (SVC) version 1.3 along with certifications in ISO 9001:2008, ISO 20000-1:2011, ISO 27001:2013 and SSAE 16, Type II. Copyright © T/DG 2015. All rights reserved www.thedigitalgroup.com SOLUTIONS | SERVICES | OUTSOURCING