Share via

SPSqlQueryCounter members

  • Article

Represents a monitor that tracks information about the SQL queries that are made during an operation. For each query, this monitor tracks the SqlQueryData text, the call stack, and the duration.

The SPSqlQueryCounter type exposes the following members.

Constructors

  Name Description
Public method SPSqlQueryCounter() Initializes a new instance of the SPSqlQueryCounter class.
Public method SPSqlQueryCounter(Int32) Initializes a new instance of the SPSqlQueryCounter class. This constructor initializes the monitor with a value that is used to increase the value of the ValueIsExcessive property.
Public method SPSqlQueryCounter(Int32, Double)

Top

Properties

  Name Description
Public property Description
Public propertyStatic member FinishedQueries
Public property Name
Public property Namespace
Public property NameValuePairs
Public propertyStatic member QueryCounts
Public propertyStatic member QueryTotalExecutingTime
Public property SqlQueries
Public property TotalDuration
Public property TotalQueryCount
Public property Value
Public property ValueIsExcessive

Top

Methods

  Name Description
Public method Dispose()
Protected method Dispose(Boolean)
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public method RenderValueForWeb Generates the HTML that is used in the Database Queries section of the Developer Dashboard.
Public methodStatic member Reset
Public method ToString (Inherited from Object.)

Top

See also

Reference

SPSqlQueryCounter class

Microsoft.SharePoint.Utilities namespace