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.

Examples

Handling SMO Events

See Also

Reference

ServerTraceEventSet Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Tracing and Replaying Events

SQL Server Event Class Reference