Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Infrastructure Monitoring with Amazon CloudWatch

You're reading from   Infrastructure Monitoring with Amazon CloudWatch Effectively optimize resource allocation, detect anomalies, and set automated actions on AWS

Arrow left icon
Product type Paperback
Published in Apr 2021
Publisher Packt
ISBN-13 9781800566057
Length 314 pages
Edition 1st Edition
Arrow right icon
Author (1):
Arrow left icon
Ewere Diagboya Ewere Diagboya
Author Profile Icon Ewere Diagboya
Ewere Diagboya
Arrow right icon
View More author details
Toc

Table of Contents (16) Chapters Close

Preface 1. Section 1: Introduction to Monitoring and Amazon CloudWatch
2. Chapter 1: Introduction to Monitoring FREE CHAPTER 3. Chapter 2: CloudWatch Events and Alarms 4. Chapter 3: CloudWatch Logs, Metrics, and Dashboards 5. Section 2: AWS Services and Amazon CloudWatch
6. Chapter 4: Monitoring AWS Compute Services 7. Chapter 5: Setting Up Container Insights on Amazon CloudWatch 8. Chapter 6: Performance Insights for Database Services 9. Chapter 7: Monitoring Serverless Applications 10. Chapter 8: Using CloudWatch for Maintaining Highly Available Big Data Services 11. Chapter 9: Monitoring Storage Services with Amazon CloudWatch 12. Chapter 10: Monitoring Network Services 13. Chapter 11: Best Practices and Conclusion 14. Assessments 15. Other Books You May Enjoy

Case study on monitoring an RDS database

Johnson, who is the solutions architect of ABC enterprise, has finished a meeting with the engineering manager. That day was Black Friday, and many of the users coming to the website are going there for the first time, so there are going to be a lot of login operations connecting to the RDS database. They are observing a lot of funny things happening in production, including huge memory consumption in the RDS database. You have been able to confirm that there are lots of database connections, but you are not sure why, although the memory consumption from the dashboard also shows that there is a huge use of memory. How can you figure out, from the SQL queries alone, the most used queries and recommend a re-architecture of the application to help improve the reliability of the system?

Solution

To figure out what is wrong, we need to pull up the Performance Insights page of the database. With that, we can view the top SQL queries that are...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime