Getting the information about top queries which are being used in a given time

[SAPSupport]

Hi Team,

Please help us is getting the information of how we can get the top query currently running and their usage.

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Dear Customer,

There are few resources that you can use to find out the top running queries and other useful information to check database services:

1. The Top Long Running Queries tab consists of three subtabs:

• Completed Queries
• Total Wait Time
• Current Running Queries

2. 3059664 - How to Analyze Database Performance and SQL Queries on Commerce Cloud Using Dynatrace

Regards