Share via


SPDiagnosticsBlockingQueryProvider members

Looks for and records SQL Queries that are blocking other SQL queries in all databases in the system.

The SPDiagnosticsBlockingQueryProvider type exposes the following members.

Constructors

  Name Description
Public method SPDiagnosticsBlockingQueryProvider() Initializes a new instance of the SPDiagnosticsBlockingQueryProvider class.
Public method SPDiagnosticsBlockingQueryProvider(SPService) Initializes a new instance of the SPDiagnosticsBlockingQueryProvider class with a specified farm-wide service.

Top

Properties

  Name Description
Public property CanRenameOnRestore Gets a Boolean value that indicates whether this object can be renamed at restore time. (Inherited from SPJobDefinition.)
Public property CanSelectForBackup Gets and sets a Boolean value that indicates whether this object can be selected for backup. (Inherited from SPJobDefinition.)
Public property CanSelectForRestore Gets and sets a Boolean value that indicates whether this object can be selected for backup. (Inherited from SPJobDefinition.)
Public property Columns This method is called to get a 2-dimensional string array representing the column name and data type of the table schema. (Overrides SPDiagnosticsProvider.Columns.)
Public property DeploymentLocked (Inherited from SPPersistedObject.)
Public property Description Gets a localized description of the job definition. (Overrides SPJobDefinition.Description.)
Public property DiskSizeRequired Gets the disk sized required for backup. (Inherited from SPJobDefinition.)
Public property DisplayName Gets the localized name of the job definition. (Inherited from SPJobDefinition.)
Public property EnableBackup Gets a Boolean value that indicates whether the job can be involved in the backup/restore process. (Inherited from SPJobDefinition.)
Public property Farm Gets the server farm where the object resides. (Inherited from SPPersistedObject.)
Public property HistoryEntries Enumerate the job history entries for this job definition. (Inherited from SPJobDefinition.)
Public property Id Gets or sets the GUID that is associated with the object. (Inherited from SPPersistedObject.)
Public property IsDisabled Gets or sets whether the job definition should be disabled. (Inherited from SPJobDefinition.)
Public property IsServiceJob (Inherited from SPJobDefinition.)
Public property LastRunTime Gets the last run time of the job definition. (Inherited from SPJobDefinition.)
Public property LockType Gets the lock type for the job definition. (Inherited from SPJobDefinition.)
Public property MaxTotalSizeInBytes (Inherited from SPDiagnosticsProvider.)
Public property Name Gets or sets a name that is used to uniquely identify two objects that have the same parent and class. (Inherited from SPPersistedObject.)
Public property Parent Gets the parent in the logical hierarchy of the configuration object tree. (Inherited from SPPersistedObject.)
Public property PerDatabaseInstanceAzureSql (Inherited from SPDiagnosticsSqlProvider.)
Public property PerDatabaseInstanceLocalSql (Inherited from SPDiagnosticsSqlProvider.)
Public property Properties Gets metadata for the persisted object. (Inherited from SPPersistedObject.)
Protected property Query This query that is executed to collect data. (Overrides SPDiagnosticsSqlProvider.Query.)
Public property RetentionPeriod This property is called to get the retention period (in days) of the provider. (Inherited from SPDiagnosticsProvider.)
Public property Retry Gets or sets whether the job definition should be retried if it ends abnormally. (Inherited from SPJobDefinition.)
Public property RunOnAzureSql (Overrides SPDiagnosticsSqlProvider.RunOnAzureSql.)
Public property RunOnLocalSQL (Inherited from SPDiagnosticsSqlProvider.)
Public property Schedule Gets or sets the schedule of the job definition. (Inherited from SPJobDefinition.)
Public property Server Gets the server of the job definition. (Inherited from SPJobDefinition.)
Public property Service Gets the service for this job definition. (Inherited from SPJobDefinition.)
Public property Status Gets or sets the status of the object that the class represents. (Inherited from SPPersistedObject.)
Public property TableName Gets the name of the table containing the blocking queries. (Overrides SPDiagnosticsProvider.TableName.)
Public property Title Gets or sets the title of the job definition. (Inherited from SPJobDefinition.)
Public property TypeName Gets the display name that describes the object type in the administrative user interface. (Inherited from SPPersistedObject.)
Public property UpgradedPersistedProperties Gets the collection of field names and values for fields that were deleted or changed. (Inherited from SPAutoSerializingObject.)
Public property VerboseTracingEnabled Gets and sets a Boolean value that indicates whether verbose tracing is enabled. (Inherited from SPJobDefinition.)
Public property Version Gets a value that is incremented each time the object is updated. (Inherited from SPPersistedObject.)
Public property WaitTimeThreshold The amount of time that a query must block, in milliseconds, before it is logged.
Protected property WasCreated Gets a Boolean value that indicates whether the object is initialized and can be found in the database. (Inherited from SPPersistedObject.)
Public property WebApplication Gets the web application for this job definition. (Inherited from SPJobDefinition.)

Top

Methods

  Name Description
Public method AddBackupObjects Adds this SPJobDefinition object to the backup/restore operation. (Inherited from SPJobDefinition.)
Public method Clone Returns a clone of the object that does not come from the in-memory cache, which enables calling code to help ensure thread safety. (Inherited from SPPersistedObject.)
Protected method CreateHelperTable Creates the helper table in the logging database. (Inherited from SPDiagnosticsProvider.)
Protected method CreateStoredProcedure Creates or alters the specified stored procedure object. (Inherited from SPDiagnosticsProvider.)
Public method CreateTable Creates a table in the logging store. (Inherited from SPDiagnosticsProvider.)
Public method Delete When the timer job is deleted, the data associated with that job will be deleted as well. (Inherited from SPDiagnosticsProvider.)
Protected method DropHelperTable Deletes the helper table from the database. (Inherited from SPDiagnosticsProvider.)
Protected method DropStoredProcedure Deletes the helper stored procedure from the database. (Inherited from SPDiagnosticsProvider.)
Public method DropTable Drop the tables in the logging store (Inherited from SPDiagnosticsProvider.)
Protected method Ensure Makes sure that the backing data structures are in place. (Inherited from SPDiagnosticsProvider.)
Public method Equals Determines whether the current persisted object equals the specified object. (Inherited from SPPersistedObject.)
Public method Execute Called by the timer job at scheduled intervals to execute data collection activities associated with this provider. (Inherited from SPDiagnosticsProvider.)
Public method ExecuteNonQuery Executes a Transact-SQL query that does not return any rows. (Inherited from SPDiagnosticsProvider.)
Public method ExecuteReader Executes a Transact-SQL query that returns a rowset. (Inherited from SPDiagnosticsProvider.)
Protected method Finalize (Inherited from Object.)
Public method GetChild<T>() Returns the child of the persisted object based on the specified type. (Inherited from SPPersistedObject.)
Public method GetChild<T>(String) Returns the child object of the persisted object based on the specified name. (Inherited from SPPersistedObject.)
Public method GetHashCode Serves as a hash function for the persisted object. (Inherited from SPPersistedObject.)
Public method GetLastSyncUtc(String) The DateTime of the most recent data written to Usage database in UTC format. (Inherited from SPDiagnosticsProvider.)
Public method GetLastSyncUtc(String, String) The DateTime of the most recent data written to Usage database in UTC format. (Inherited from SPDiagnosticsProvider.)
Public method GetObjectData Gets the serialized state of the object. (Inherited from SPAutoSerializingObject.)
Public method GetType (Inherited from Object.)
Protected method HasAdditionalUpdateAccess Override this method to allow more users to update the object. (Inherited from SPPersistedObject.)
Public method LegacyUpdate (Inherited from SPPersistedObject.)
Protected method MemberwiseClone (Inherited from Object.)
Public method OnAbort Called when a user cancels the operation. (Inherited from SPJobDefinition.)
Public method OnBackup Called when the system is being backed up. (Inherited from SPJobDefinition.)
Public method OnBackupComplete Called when a backup operation is complete. (Inherited from SPJobDefinition.)
Protected method OnDeserialization Called immediately after the base class deserializes itself to do additional work. (Inherited from SPPersistedObject.)
Protected method OnPostCreate (Inherited from SPPersistedObject.)
Public method OnPostRestore Called when the system is done restoring a backup. (Inherited from SPJobDefinition.)
Protected method OnPreCreate (Inherited from SPJobDefinition.)
Public method OnPrepareBackup Called when the system is preparing for a backup operation. (Inherited from SPJobDefinition.)
Public method OnPreRestore Called when the system is preparing to restore a backup. (Inherited from SPJobDefinition.)
Public method OnProvisioning This method is called to allow providers to perform any kind of initialization of SQL database, such as creation of tables and/or stored procedures. (Inherited from SPDiagnosticsProvider.)
Public method OnRestore Called when the system is being restored. (Inherited from SPJobDefinition.)
Public method OnUnprovisioning This method is called to allow providers to perform any kind of initialization of SQL database, such as creation of tables and/or stored procedures. (Inherited from SPDiagnosticsProvider.)
Public method Provision Makes the changes to the local server that are needed before the object can be used. (Inherited from SPPersistedObject.)
Public method RunNow Schedules the job for immediate execution. (Inherited from SPJobDefinition.)
Public method RunWithConcurrencyRetries (Inherited from SPPersistedObject.)
Public method Sync Copies new data from the data source to the data warehouse. (Inherited from SPDiagnosticsSqlProvider.)
Public method ToString Returns the type and name of an object and of all its ancestors (parent, grandparent, and so on). (Inherited from SPPersistedObject.)
Public method Uncache Frees the memory cache that is used by the object. (Inherited from SPPersistedObject.)
Public method Unprovision This method is called to delete all database objects associated with the provider. (Inherited from SPDiagnosticsProvider.)
Public method Update() Causes this SPDiagnosticsProvider to save its state. (Inherited from SPDiagnosticsProvider.)
Public method Update(Boolean) Causes the object to save its state and propagate changes to all the computers in the server farm, optionally throwing an exception if the object already exists in the configuration store. (Inherited from SPPersistedObject.)
Protected method UpdateParent Causes the containing SPPersistedObject, if one exists, to update its state. (Inherited from SPAutoSerializingObject.)
Public method UpdateProgress Updates the percentage of the running job that is completed for the job definition running on the current server. (Inherited from SPJobDefinition.)
Public method UpdateWithNoObjectCallbackCheck (Inherited from SPPersistedObject.)
Protected method Validate Validates query last execution date/time. (Inherited from SPDiagnosticsSqlProvider.)
Public method WriteDataRowToServer(DateTime, String, []) Writes supplied data to Usage database. (Inherited from SPDiagnosticsProvider.)
Public method WriteDataRowToServer(String, IList<SPColumnDefinition>, DateTime, String, []) Writes a row of data into a table in the logging store. The table should have been created with CreateTable(String, IList<SPColumnDefinition>)CreateTable(String, IList<SPColumnDefinition>). (Inherited from SPDiagnosticsProvider.)

Top

See also

Reference

SPDiagnosticsBlockingQueryProvider class

Microsoft.SharePoint.Diagnostics namespace