共用方式為


Configuration.OptimizeAdhocWorkloads 屬性

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

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public ReadOnly Property OptimizeAdhocWorkloads As ConfigProperty 
    Get
'用途
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

屬性值

型別:Microsoft.SqlServer.Management.Smo.ConfigProperty
A ConfigProperty object that specifies the settings for the optimize ad hoc workloads configuration option.

備註

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

範例

在 SMO 中設定 SQL Server

請參閱

參考

Configuration 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

伺服器組態選項

sp_configure (Transact-SQL)