When the database agent is configured to collect metrics from the database and SQL or Oracle PI is not used, Top SQL data is available from the following locations in the topology:
SQL Server
Configuration | Data | Management Server | DBSS_Data_Model | SQL-Server Data Model | Clusters | {Instance Name} | Instances | {Instance Name} | Top SQLs Data | Top Sqls Snapshots | History | SQL Server Top SQL Observed Value
or
Oracle
Configuration | Data | Management Server | DBO_Data_Model | Oracle Data Model | Clusters | {Instance Name} | Instances | {Instance Name} | Top SQLs Data | Top Sqls Snapshots | History | Oracle Top SQL Observed Value
and/or
Configuration | Data | Management Server | DBO_Data_Model | Oracle Data Model | Clusters | {Instance Name} | Instances |
{Instance Name} | Top SQLs Data | Top Sqls Snapshots | Latest | Value