Compartir a través de

Refresh Método

This method fills in the Cpus()()()() and NumaNode()()()() with the local server settings.

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
Public Sub Refresh
'Uso
Dim instance As AffinityInfo

instance.Refresh()

public void Refresh()

public:
void Refresh()

member Refresh : unit -> unit 

public function Refresh()

Comentarios

To set any AffinityInfo object properties and users must have ALTER permission on the database.

Ejemplos

This example shows you how to determine the number of CPUs on the local instance of SQL Server.

using System;
using Microsoft.SqlServer.Management.Smo;

namespace samples
{
    class Program
    {
        static void Main(string[] args)
        {
            Server dbServer = new Server("(local)");
            dbServer.Refresh();
            Console.WriteLine("Total CPUs = {0}",
                dbServer.AffinityInfo.Cpus.Count);
        }
    }
}

Powershell

//Create the server. 
$dbServer = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")

//Set the Affinity Type to Auto
#dbServer.AffinityInfo.Refresh()
Write-Host "Total CPUs = ",$dbServer.AffinityInfo.Cpus.Count
  • Last updated on