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...
