The QueryInformation type exposes the following members.

Constructors

  NameDescription
Public methodQueryInformation
default constructor

Methods

  NameDescription
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected methodFinalize
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetParameterizedQuery
Returns the query parameterized and wrapped to use the sp_ExecuteSQL stored procedure.
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodToString
Returns a String that represents the current Object.
(Inherited from Object.)

Properties

  NameDescription
Public propertyActualStatement
The executed query as reported back by SQL Server
Public propertyCompileTime
SQL Server query compile time in milliseconds.
Public propertyCustomData
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.
Public propertyEntryID
Profiler log entry Id uniquely identifying a specific query execution instance.
Public propertyExecutionPlan
SQL Server execution plan (actual or estimated) for the query. Only included if the profiler trace explicitly enabled execution plan extraction.
Public propertyExecutionPlanError
If an error occurs when retrieving the execution plan, this member will contain the error details.
Public propertyExecutionPlanMode
Execution plan mode that was used for retrieving the execution plan.
Public propertyExecutionTime
SQL Server query execution time in milliseconds (excluding parsing and compilation).
Public propertyInfoMessages
Contains any additional information messages generated by SQL Server during query execution.
Public propertyLogSource
Which profiler created the log entry...?
Public propertyQueryContext
Query execution context: who, when, where, how
Public propertyQueryParams
Query parameter descriptions and values
Public propertySeq
Profiler log trace sequence number showing the ordinal position of this entry within the profiler session it was recorded under.
Public propertySQLIOStatistics
Raw SQL Server I/O statistics output
Public propertySQLQuery
The SQL query that was executed
Public propertySQLTimings
Raw SQL Server compile and execution timings for the query.
Public propertyStackTrace
Managed call stack that caused the query to execute.
Public propertyTableReads
SQL Server I/O statistics broken down by table.
Public propertyTotalLOBReads
Total number of large object page reads performed by the query.
Public propertyTotalLOBReadsKilobytes
Total large object reads in kilobytes.
Public propertyTotalReads
Total number of page reads performed by the query. (Excluding LOB reads)
Public propertyTotalReadsKilobytes
Total table reads in kilobytes (excluding LOB reads).
Public propertyTraceID
Profiler log trace ID identifying the profiler session under which this entry was created.
Public propertyVersion
QueryInformation version

See Also