Profiling SQL queries - ANTS Performance Profiler

ANTS Performance Profiler 7.2 Professional automatically profiles the calls your application makes to any Microsoft SQL server (except SQL Server Compact), Amazon RDS, or Oracle database instance. Database call profiling works with calls to both local and remote databases, and for any version of SQL server.

This feature is available only in ANTS Performance Profiler Professional edition. To upgrade from Standard edition, see Upgrading your software.

Timing data for SQL calls is captured in all profiling modes except for sampling mode.

Viewing SQL profiling results

Database calls appear in the call tree as children of the .NET methods that generate them.

On the results toolbar, select Call tree view, and Wall-clock time.
Drag to select the portion of the timeline that you are interested in.
In the call tree, calls to your database during the selected time period are identified with the icon.
The call tree shows the first line of the database query (excluding any initial blank lines), the time the query took to return its first result, and the query's hit count.
To view the full text of the query, click the icon to switch to Database Calls view.
For more details on using Database Calls view to see all the queries your application made during the selected time period, see Working with Database Calls view.