case study on database optimization - database monitoring and performance program

8/20/2019 Case Study on Database Optimization - database monitoring and performance program

1/3

DATABASEORGANIZATION

A leading provider of local community focused web applications with sites in more than32 countries and over 600 cities. They are one of the fastest growing local community reachsites in the industry. Central to their offering is a housing share service which offers users theability to post, search, and browse available units. The application performs a comparison ofa user’s needs and provides updated category matches which users can view on demand or

through automated emails. These services are delivered through a membership driven webbased application and managed by local site administrators.

ClientProfile

BusinessChal lenges

The core databases for the housing share solution were unstable and becoming moreinconsistent as information and demand continued to increase. As new cities, countries,and application features were being added, the database integrity began to be noticeablyaffected. This also lead to frequent system downtime during critical peak activity periods.The client was losing revenue. The business objective was to engage in a focused databaseanalysis and performance review that would deliver an executable plan to make thedatabases more efficient and reliable while delivering in the fastest time to productionpossible

TheSolut ion

The Digital Group’s database performance experts reviewed the existing databases tocapture a baseline from which to measure stability and performance gains, as well as tocreate an optimization plan that identified top level issues. The engineering team then

executed an iterative process of performance tuning, indexing, and script optimizationwhile tracking measured results at the end of each milestone. After stabilizing the system,the team evaluated and implemented a database replication service that would significantlyimprove system performance while guaranteeing the platform’s stability withoutimpacting operational costs.


2/3

TheSolut ion

Resul t

After completing the performance and stability operation, The Digital Group took responsibility

for ongoing monitoring support and high level issue resolution. This activity was performedon a weekly basis from their Australia facility.

Through the use of the database monitoring and performance program, the client was ableto achieve and deliver a new level of service without having to make a heavy investment inan application re-write. As a result, their product now offers its users an unmatched level of performance and usability which is now helping them secure an even stronger market

position.

Some of the specific benefits achieved include:

DATABASEORGANIZATION

Utilizing high quality / low costoffshore resources

Avoidance of applicationre-write

Operationalcostsavings

Increased performance throughoptimized scripts and queries

Stability through replication

Ongoing system monitoring helpedearly problem identification

Reducederrorrateandincreasedefficiency


3/3

THEDIGITALGROUPINC.

121 Village Boulevard

Princeton Forrestal Village

Princeton NJ 08540 USA

Phone: +1.609.524.2441

Fax: +1.609.228.4844Email: [email protected]

USA|INDIA|AUSTRALIA|FIJI

GlobalPresence

GetSocial

DisclaimerAllinformationcontainedinthisdocumentisanexclusivepropertyofTheDigitalGroupInfotechPvt.Ltd.(T/DG).Theinformationcontainedhereiscorrectanduptodateatthetimeofpublishing.Nomaterialfromheremaybecopied,modified,reproduced,republished,uploaded,transmitted,postedordistributedinanyformwithoutpriorwrittenpermissionfromT/DG.Unauthorizeduseofthecontent/informationmayresultinviolationofcopyright,trademark,andotherapplicablelaws,andcouldresultincriminalorcivilpenalties

ABOUTUS

TheDigitalGroup(T/DG)isatrustedInformationTechnologypartnerforbusinessesacrosstheglobe.OurcomprehensiveITservicesincludeafullspectrumofProductEngineeringandDevelopmentservices,SoftwareandDatasolutionsaswellasEnterpriseInformationManagementsolutionsthathelporganizationsoptimizeproductivity,enhanceoperationalcapabilities,boostrevenues,driveinnovationsandfireuptime-to-marketcyclesinadynamicenvironment.

Withafocusonbuildinglong-termclientrelationships,weprovidearangeofservicesfromConcept-To-CompletespanningProductDevelopment,Maintenance,SupportandOperations.Ourcommitmenttoinnovationcoupledwithdecadesofexperiencedeliveringexcellenceforourcustomers,vitaltechnologypartnershipsandglobaldeliverycentersacrosstheUSandAsiaPacific,makeT/DGanidealchoicefornext-generationinitiatives.

T/DGisaCMMiLevel5ver1.3DevandServiceAppraisedcompanyalongwithcertificationsinISO9001:2008,ISO20000-1:2011,ISO27001:2013,ISO22301:2012andSSAE16,TypeII.Formoreinformation,visitwww.thedigitalgroup.com

P A R T N E R

www.thedigitalgroup.com A CMMi Level 5 Company

case study on database optimization - database monitoring and performance program

Documents