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).

See Also

Reference

IServerConfigurationFacet Interface

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

optimize for ad hoc workloads Server Configuration Option