The SQL Queries view represents all SQL Queries made by the profiled application. In general this means,
all ADO.NET commands executed by the application. The database type does not matter, as long as an ADO.NET driver is used.
In other words, JustTrace fully supports not only MSSQL, but also Oracle,
Postgre, MySql, SQLite, SQL CE,
SharePoint SQL, VistaDB, Firebird,
iAnywhere and every other database with an ADO.NET driver.
SQL queries can be shown only when the racing profiler is used. Select 'Use tracing profiler' when starting a new session.
Each node of the SQL Queries view contains the following information:
- Query - the query text (excluding blank lines).
- Time To Execute (ms) - the total time needed for executing the command. For certain operation queries
(update, insert), the Time To Execute will also represent the total query execution time. However, for SELECT
queries this will give you only information about the time needed for giving the command, the total query time won't be included.
ADO.NET drivers maintain SQL queries differently.
- Hit Count - number of times this call has been made.
You can see the actual sql statement for each query at the bottom of the SQL Queries view.
The context menu contains the following commands:
- Find in Root Call Tree - activates the Call Tree view and shows
the first occurrence of the method. You can use the buttons of the navigation bar to locate all other calls to this method in the call tree.
- Merge All Calls in New View - opens a new view and merges all calls to the selected function in the entire process.
This is helpful if you want to investigate how much total time it took, which functions it called and how the time spent in it is distributed among
its callees, regardless of a particular call site.
- Show Caller Tree - opens a new Caller Tree view with all callers of
the selected function presented as child nodes - a tree of callers. This can help you find where exactly it has been called.