The QueryInformation type exposes the following members.

Properties

  NameDescription
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.
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

See Also