Aracılığıyla paylaş

Configuration.SetWorkingSetSize Property

  • Makale

Gets the ConfigProperty object that is used to set the set working set size configuration option.

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

Syntax

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

value = instance.SetWorkingSetSize

public ConfigProperty SetWorkingSetSize { get; }

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

member SetWorkingSetSize : ConfigProperty

function get SetWorkingSetSize () : ConfigProperty

Property Value

Type: Microsoft.SqlServer.Management.Smo.ConfigProperty
A ConfigProperty object that specifies the settings for the set working set size configuration option.

Remarks

This property specifies that the operating system does not swap SQL Server pages out of memory even if they can be used more easily by another process when SQL Server is idle.

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)