Configuration.OptimizeAdhocWorkloads Property

  • Article

 

Applies To: SQL Server 2016 Preview

Gets the ConfigProperty object that sets the optimize ad hoc workloads configuration option.

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

Syntax

public ConfigProperty OptimizeAdhocWorkloads { get; }

public:
property ConfigProperty^ OptimizeAdhocWorkloads {
    ConfigProperty^ get();
}

member OptimizeAdhocWorkloads : ConfigProperty with get

Public ReadOnly Property OptimizeAdhocWorkloads As ConfigProperty

Property Value

Type: Microsoft.SqlServer.Management.Smo.ConfigProperty

A ConfigProperty object that specifies the settings for the optimize ad hoc workloads configuration option.

Remarks

The OptimizeAdhocWorkloads property sets the optimize ad hoc workloads configuration option. This property is used to optimize ad hoc workloads.

Examples

Legacy Code Example

Configuring SQL Server in SMO

See Also

Configuration Class
Microsoft.SqlServer.Management.Smo Namespace
Server Configuration Options (SQL Server)
sp_configure (Transact-SQL)

Return to top