مشاركة عبر

  • مقالة

ServerTraceEventSet.BlockedProcessReport Property

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a process has been blocked for more than a specified amount of time.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Property BlockedProcessReport As Boolean
    Get
    Set
'Usage
Dim instance As ServerTraceEventSet
Dim value As Boolean

value = instance.BlockedProcessReport

instance.BlockedProcessReport = value

public bool BlockedProcessReport { get; set; }

public:
property bool BlockedProcessReport {
    bool get ();
    void set (bool value);
}

member BlockedProcessReport : bool with get, set

function get BlockedProcessReport () : boolean
function set BlockedProcessReport (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether the BlockedProcessReport event is included in the event set.
If True, the event is included in the event set.
If False (default), the event is not included in the event set.

Remarks

This event does not include system processes or processes that are waiting on non deadlock-detectable resources. Use sp_configure to configure the threshold and frequency at which reports are generated.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.