ServerAdapterBase.OptimizeAdhocWorkloads Property

Gets or sets a value that specifies whether optimization for ad hoc workloads is enabled.

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

Syntax

'Declaration
Public Property OptimizeAdhocWorkloads As Boolean 
    Get 
    Set
'Usage
Dim instance As ServerAdapterBase 
Dim value As Boolean 

value = instance.OptimizeAdhocWorkloads

instance.OptimizeAdhocWorkloads = value

public bool OptimizeAdhocWorkloads { get; set; }

public:
virtual property bool OptimizeAdhocWorkloads {
    bool get () sealed;
    void set (bool value) sealed;
}

abstract OptimizeAdhocWorkloads : bool with get, set 
override OptimizeAdhocWorkloads : bool with get, set

final function get OptimizeAdhocWorkloads () : boolean 
final function set OptimizeAdhocWorkloads (value : boolean)

Property Value

Type: System.Boolean
A Boolean value whether ad hoc workload optimization is enabled.If True, optimization is enabled. Otherwise, False.

See Also

Reference

ServerAdapterBase Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

optimize for ad hoc workloads Server Configuration Option