ANTS Performance Profiler 7.4 Professional automatically profiles the calls your application makes to any Microsoft SQL server or Oracle database instance. From ANTS Performance Profiler 7.3, this includes applications running in Amazon RDS and SQL Services (SQL Azure). 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.

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.

1. On the results toolbar, select Call tree view, and Wall-clock time.
    
2. Drag to select the portion of the timeline that you are interested in.
3. 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.
4. 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.

Troubleshooting

See Troubleshooting SQL and HTTP call profiling.