The QueryInformation type exposes the following members.

Constructors

  NameDescription
QueryInformation
default constructor

Methods

  NameDescription
Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Finalize
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.)
GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
GetParameterizedQuery
Returns the query parameterized and wrapped to use the sp_ExecuteSQL stored procedure.
GetType
Gets the Type of the current instance.
(Inherited from Object.)
MemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
ToString
Returns a String that represents the current Object.
(Inherited from Object.)

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