Share via

  • Article

ServerTraceEventSet.HashWarning Property

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a hashing operation that is not processing on a buffer partition has reverted to an alternate plan.

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

Syntax

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

value = instance.HashWarning

instance.HashWarning = value

public bool HashWarning { get; set; }

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

member HashWarning : bool with get, set

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

Property Value

Type: System.Boolean
A Boolean value that specifies whether the HashWarning 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

Hashing operations include hash join, hash aggregate, hash union, and hash distinct. The hash warning can occur because of recursion depth, data skew, trace flags, or bit counting.

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