The QueryInformation type exposes the following members.
Properties
Name | Description | |
---|---|---|
ActualStatement |
The executed query as reported back by SQL Server
| |
CompileTime |
SQL Server query compile time in milliseconds.
| |
CustomData |
Custom data attached to the profiler session before the query was executed. This member is reset between each query execution and can be used by the profiled application to provide additional context.
| |
EntryID |
Profiler log entry Id uniquely identifying a specific query execution instance.
| |
ExecutionPlan |
SQL Server execution plan (actual or estimated) for the query. Only included if the profiler trace explicitly enabled execution plan extraction.
| |
ExecutionPlanError |
If an error occurs when retrieving the execution plan, this member will contain the error details.
| |
ExecutionPlanMode |
Execution plan mode that was used for retrieving the execution plan.
| |
ExecutionTime |
SQL Server query execution time in milliseconds (excluding parsing and compilation).
| |
InfoMessages |
Contains any additional information messages generated by SQL Server during query execution.
| |
LogSource |
Which profiler created the log entry...?
| |
QueryContext |
Query execution context: who, when, where, how
| |
QueryParams |
Query parameter descriptions and values
| |
Seq |
Profiler log trace sequence number showing the ordinal position of this entry within the profiler session it was recorded under.
| |
SQLIOStatistics |
Raw SQL Server I/O statistics output
| |
SQLQuery |
The SQL query that was executed
| |
SQLTimings |
Raw SQL Server compile and execution timings for the query.
| |
StackTrace |
Managed call stack that caused the query to execute.
| |
TableReads |
SQL Server I/O statistics broken down by table.
| |
TotalLOBReads |
Total number of large object page reads performed by the query.
| |
TotalLOBReadsKilobytes |
Total large object reads in kilobytes.
| |
TotalReads |
Total number of page reads performed by the query. (Excluding LOB reads)
| |
TotalReadsKilobytes |
Total table reads in kilobytes (excluding LOB reads).
| |
TraceID |
Profiler log trace ID identifying the profiler session under which this entry was created.
| |
Version |
QueryInformation version
|