Aracılığıyla paylaş


Configuration.OptimizeAdhocWorkloads Property

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

'Bildirim
Public ReadOnly Property OptimizeAdhocWorkloads As ConfigProperty
    Get
'Kullanım
Dim instance As Configuration
Dim value As ConfigProperty

value = instance.OptimizeAdhocWorkloads
public ConfigProperty OptimizeAdhocWorkloads { get; }
public:
property ConfigProperty^ OptimizeAdhocWorkloads {
    ConfigProperty^ get ();
}
member OptimizeAdhocWorkloads : ConfigProperty
function get OptimizeAdhocWorkloads () : 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

Configuring SQL Server in SMO

See Also

Reference

Configuration Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Server Configuration Options

sp_configure (Transact-SQL)