大规模排查数据库性能问题.pdf

《大规模排查数据库性能问题.pdf》由会员分享，可在线阅读，更多相关《大规模排查数据库性能问题.pdf（29页珍藏版）》请在三个皮匠报告上搜索。

1、 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.C O P 3 3 1Troubleshooting database performance issues at scaleJoe Alioto(he/him)Sr Specialist Solutions Architect,CloudOpsAWS 2025,Amazon Web Services,Inc.or its af

2、filiates.All rights reserved.AgendaCustomer challengesFleet-wide and Instance ObservabilityEnd-to-end transaction analysis with APMCommon troubleshooting workflowActions and resources 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Meet Alex!Name:Alex SmithRole:SRE Lead at Ocktank

3、Background:Experienced with supporting applications,infrastructure,and operations including databases.Hes an operational super hero!Nice to meet you!2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Challenges in managing databasesA wide variety of database instancesMultiple databas

4、e instances across development and products lead to observability complexityLarge volumes of tools and console could lead to more time managing data than actually analyzing itEver-growing set of tools and consoles Need for specialized talents and expertise may result in higher costs and steeper lear

5、ning curveDeep database expertise requiredInability to correlate database and application performance issues lead to longer mean time to resolution(MTTR)Lack of Application Context 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Help me Alex!Sales Team:“Our retail service is slow!

6、Whats happening?”Let me take a look!2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Fleet-wide monitoring Unified Database Visibility across accounts and regions Heat Map with DB load and Alarms Top 10 instances by load or specific metrics Recent Database EventsC L O U D W A T C H