Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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)
public bool BlockedProcessReport { get; set; }

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.