• Article

IServerConfigurationFacet.OptimizeAdhocWorkloads Property

Gets or sets a value that determines whether ad hoc workloads will be optimized.

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

Syntax

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

value = instance.OptimizeAdhocWorkloads

instance.OptimizeAdhocWorkloads = value

bool OptimizeAdhocWorkloads { get; set; }

property bool OptimizeAdhocWorkloads {
    bool get ();
    void set (bool value);
}

abstract OptimizeAdhocWorkloads : bool with get, set

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

Property Value

Type: System.Boolean
Returns True if workloads will be optimized; otherwise, False (default).