1. Home
  2. Training Library
  3. Amazon Web Services
  4. Courses
  5. Understanding Amazon RDS Performance Insights

Wrap Up & Review

Contents

keyboard_tab
Introduction
1
Course Introduction
PREVIEW3m 18s
Summary

The course is part of these learning paths

Working with AWS Databases
course-steps
11
certification
3
lab-steps
5
play-arrow
Start course
Overview
DifficultyIntermediate
Duration43m
Students112
Ratings
5/5
starstarstarstarstar

Description

This course explores Amazon RDS Performance Insights, a performance monitoring and tuning feature that can quickly assess the load on a database hosted inside Amazon RDS and determine when and where to take action.

In this course, you will learn what the Performance Insights service is, how it provides meaningful information database load, how to use it, and the costs and security features of the service.

If you have any feedback relating to this course, please contact us at support@cloudacademy.com.

Learning Objectives

  • Obtain a foundational understanding of Amazon RDS Performance Insights
  • Learn how Performance Insights measures database load and adds context to AAS (Average Active Sessions)
  • Learn how to use Performance Insights
  • Understand how to control access to Performance Insights
  • Understand the costs associated with using the service

Intended Audience

This course is intended for both new and experienced database administrators that need to assess, understand, and optimize the load that users and applications put on an RDS database.

Prerequisites

To get the most out of this course, you should have a basic understanding of relational databases, have created at least one RDS database instance, and a working knowledge of the AWS cloud platform.

Transcript

I hope you found this course on RDS performance insights interesting, informative, and practical. I especially hope that you're motivated to continue learning about RDS performance monitoring and we'll apply what you've learned to your own particular challenges and needs inside the AWS cloud.

There were a number of topics in this course. Performance insights can help identify performance bottlenecks on an Amazon RDS instance. And if a problem is within the database located source. It's a fully automated feature of Amazon RDS where the impact of database performance limited to 1% of a CPU core. It is a graphical dashboard that has been designed to be easy to use by both novice and expert users.

Storage collection and the dashboard display is done automatically. Load is measured using a metric called average active sessions or AAS. AAS is calculated by sampling memory to determine the state of each active database connection. 

The sample data includes the SQL query, the state of the query, the host that originated the query, and the user running it. Active sessions are sampled once per second to present a seamless picture of a database's load. Performance insights metric data is stored, processed, and managed using AWS resources outside of the RDS instance. Since metric data is stored externally from RDS, analysis has no impact on database performance.

The performance insights dashboard shows as a default view, one hour of activity. It can be adjusted to show other timeframes. It is possible to view single-second data points by interacting with the graph.

When troubleshooting, performance insights can be used to eliminate the database as being a problem. If there's a database issue, performance insights can help identify the source and pinpoint the cause of the problem. The dashboard has four categories that identify contributions to database load, SQL, hosts, users, and waits. The default is to show the top SQL queries. However, it is possible to view the top hosts, top users, or top waits.

Access to performance insights can be granted and restricted using an IAM policy. There is a free tier that includes seven days of performance data and 1 million API calls. Once the free tier has been used, costs are based on consumption. Longterm retention of performance insights data is possible for up to two years.

Costs are calculated based on AWS region, number of CPU cores, and the number of hours the data is retained. When I was a child, my father would often take me to task for leaving lights on after I left a room, or forgetting to close the door when I went outside. His advice then translates to my advice now. Inside the AWS cloud, if you're not using it, turn it off. No sense in paying for something nobody's using. Likewise, if you leave a door open, someone or something will come in uninvited, that's never good and it will not end well.

If you're looking at AWS certification, performance insights might show up on the database specialty exam. You should know what performance insights measures, and how it is different from Amazon CloudWatch and RDS enhanced monitoring. It will also help you to know how to use CloudWatch, enhanced monitoring, and performance insights together to troubleshoot issues with Amazon RDS.

This brings me to the end of this lecture and the end of the course. Thank you for being part of it. If you have any feedback, positive or negative, please contact us at support@cloudacademy.com. It's greatly appreciated. We use your feedback to update existing content and to shape future courses.

Thank you again for watching and good luck with your continued learning of cloud computing.

About the Author
Students204
Courses3
Learning paths1

Stephen is the AWS Certification Specialist at Cloud Academy. His content focuses heavily on topics related to certification on Amazon Web Services technologies. He loves teaching and believes that there are no shortcuts to certification but it is possible to find the right path and course of study.

Stephen has worked in IT for over 25 years in roles ranging from tech support to systems engineering. At one point, he taught computer network technology at a community college in Washington state.

Before coming to Cloud Academy, Stephen worked as a trainer and curriculum developer at AWS and brings a wealth of knowledge and experience in cloud technologies.

In his spare time, Stephen enjoys reading, sudoku, gaming, and modern square dancing.