Name: Database Monitoring in Dynatrace for SAP Commerce Cloud
Uploaded: 2023-5-8
Duration: 216 s
Description: This video demonstrates the Databases workspace in Dynatrace for SAP Commerce Cloud, and provides useful information on how to monitor it.

Share feedback

<p>We are aware of intermittent issues in accessing the learning content</p>

We are aware of intermittent issues in accessing the learning content

Personalize your learning.

Why create an SAP account?

Enhance your learning experience

SAP Learning

Choose your subscription

Manage your subscription

Live Sessions

Hands-on Practice

Certification

My Learning

Ready to start learning?

Please try again later

Sorry, we encountered an error

Try again or reset results to continue browsing

We didn’t find what you’re looking for

To continue, please log in

Your session has timed out

Validate your skills and learning by completing the certification exam and gain a highly recognised accreditation.

Book your certification exam

Complete the assessment to validate your SAP PartnerEdge competency qualifications.

Ready to take your assessment?

Learn about the key features and essentials in the latest release to help you prepare for the Stay Certified assessment.

Prepare for assessment

Learn new skills you need at your own pace with our bite-sized lessons.

Prepare for certification

In your My Learning account you can view your certification and learn how to take your Stay Certified assessment.

Ready to take your Stay Certified assessment?

Explore {title} at SAP Learning. Find out more!

Assessment

Course Completion

Knowledge Badge

Certification Exam

Theoretical Exam

Schedule

External Course

Practical Exercise

Practical Test

External Hands-On

External Resource

Learning Journey

Learning Journey Assessment

Lesson

Live Session

Practice System

Quiz

Scenario Based Assessment

Course Assessment

Course

Stay Certified

Subscription

System Based Assessment

Test Out

Unit

Video

Video Playlist

Week

<div><div><div>This video demonstrates the Databases workspace in Dynatrace for SAP Commerce Cloud, and provides useful information on how to monitor it.</div></div></div>

Database Monitoring in Dynatrace for SAP Commerce Cloud

Hello! Let’s take a look into, the Databases workspace in Dynatrace.  There is no special setup or configuration required, to monitor the database activities in SAP Commerce Cloud.  Database calls are monitored automatically.  By monitoring such calls,  Dynatrace provides insight into various, aspects of database performance, and is even able to deliver automatic, root-cause analysis for performance problems.  Select Databases under Applications & Microservices, to open the Databases page, and see all database instances, that were active within the selected timeframe.  Dynatrace monitors the response time,  failure rate,  throughput,  and every database statement, executed by the Commerce cloud applications.  Select any of the database instances, to see the database service overview page.  The infographics on the database service overview page, provide insight into various aspects of database performance,  including SQL queries or procedures,  SQL modifications,  SQL transactions,  any detected problems or availability issues, hotspots, and more.  The exact list of included tiles depends, on the database technology you're monitoring.  Each tile contains Response time,  Failure rate, and Throughput metrics.  To analyze the individual statements, select View database statements.  All database statements executed during the selected, timeframe are listed in the # database statements section, at the bottom of the Details page.  By default, database statements are, sorted based on median response time.  The list can be sorted by total time,  response time, or slowest 10%,  and you can filter it on statement, database name, vendor, process, or hostname.  Select any statement to view the full details of that statement.  For each statement, Dynatrace shows the number of Executions per minute,  Total executions, Total time, Response time median, and slowest 10% of executions, and Failure rate.   The Backtrace page provides details on the clicks, that triggered the selected execution of the SQL statement,  and it allows you to see which chain of services, and which code leads to a particular SQL statement.  To understand the response time distribution of the SQL command,  select Analyze outliers on the Details page.  The Response time distribution page shows, the number of requests that fell within various response time ranges.  Select any column in the chart to analyze the specific requests,  that fell within that specific response time range.  This enables you to see if certain SQL statements are called frequently, and contribute relatively much more to the response time.  On the database service overview page,  the Current hotspots section offers a quick view of the problem,  highlighting the SQL statement with the highest failure rate.  By selecting a statement in this section,  you can directly view the failures tab on its Details page.   From the Analyze menu Drill icon,  select Outliers to understand the spread of response times.  Statement details to understand the evolution of each, individual SQL statement that undergoes, over time along with the average Rows returned count.  Click on Analyze backtrace to see which user, clicks led to the slowest executions of this SQL statement.  That’s it for Databases.  Thank you for watching!