Those 2 options are the ones I typically would use and recommend. Is there anything missing on those?
An alternative, depending on the data source you are using, is to look at the queries directly on the data source. For example, if you are using SQL Server, you can check what queries are running using the SQL Server Profiler (How to Identify Slow Running Queries with SQL Profiler - Simple Talk ) or checking directly on the system tables (https://blog.sqlauthority.com/2009/01/07/sql-server-find-currently-running-query-t-sql/). Other products would have similar tools to diagnose.