Set-AzSqlInstancePool
Define propriedades para um pool de Instâncias SQL do Azure.
Syntax
Set-AzSqlInstancePool
[-ResourceGroupName] <String>
[-Name] <String>
[-LicenseType <String>]
[-Tag <Hashtable>]
-VCore <Int32>
-Edition <String>
-ComputeGeneration <String>
-MaintenanceConfigurationId <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Set-AzSqlInstancePool
[-InputObject] <AzureSqlInstancePoolModel>
[-LicenseType <String>]
[-Tag <Hashtable>]
-VCore <Int32>
-Edition <String>
-ComputeGeneration <String>
-MaintenanceConfigurationId <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Set-AzSqlInstancePool
[-ResourceId] <String>
[-LicenseType <String>]
[-Tag <Hashtable>]
-VCore <Int32>
-Edition <String>
-ComputeGeneration <String>
-MaintenanceConfigurationId <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Description
O cmdlet Set-AzSqlInstancePool modifica as propriedades de um pool de Instâncias SQL do Azure.
Exemplos
Exemplo 1: Definir um tipo de licença de pool de instâncias
Set-AzSqlInstancePool -ResourceGroupName resourcegroup01 -Name instancePool0 -LicenseType LicenseIncluded
ResourceGroupName : resourcegroup01
Type : Microsoft.Sql/instancePools
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancePool0
InstancePoolName : instancePool0
SubnetId : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Network/virtualNetworks/vnet_name/subnets/subnet_name
VCores : 8
ComputeGeneration : Gen5
Edition : GeneralPurpose
Tags :
Sku : Microsoft.Azure.Management.Sql.Models.Sku
Location : canadacentral
LicenseType : LicenseIncluded
DnsZone : 1234567890
MaintenanceConfigurationId : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_canadacentral_MI_1
Este comando define o tipo de licença e/ou tags para um pool de instâncias chamado instancePool0.
Exemplo 2: Definir um tipo de licença de pool de instâncias usando um objeto de pool de instâncias
$instancePool = Get-AzSqlInstancePool -ResourceGroupName resourcegroup01 -Name instancePool0
Set-AzSqlInstancePool -InputObject $instancePool -LicenseType LicenseIncluded
ResourceGroupName : resourcegroup01
Type : Microsoft.Sql/instancePools
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancePool0
InstancePoolName : instancePool0
SubnetId : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Network/virtualNetworks/vnet_name/subnets/subnet_name
VCores : 8
ComputeGeneration : Gen5
Edition : GeneralPurpose
Tags :
Sku : Microsoft.Azure.Management.Sql.Models.Sku
Location : canadacentral
LicenseType : LicenseIncluded
DnsZone : 1234567890
MaintenanceConfigurationId : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_canadacentral_MI_1
Este comando define o tipo de licença e/ou tags para um pool de instâncias usando um objeto de pool de instâncias.
Exemplo 3: Definir um tipo de licença de pool de instâncias usando um id de recurso do pool de instâncias
Set-AzSqlInstancePool -ResourceId "/subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancePool0" -LicenseType LicenseIncluded
ResourceGroupName : resourcegroup01
Type : Microsoft.Sql/instancePools
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancePool0
InstancePoolName : instancePool0
SubnetId : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Network/virtualNetworks/vnet_name/subnets/subnet_name
VCores : 8
ComputeGeneration : Gen5
Edition : GeneralPurpose
Tags :
Sku : Microsoft.Azure.Management.Sql.Models.Sku
Location : canadacentral
LicenseType : LicenseIncluded
DnsZone : 1234567890
MaintenanceConfigurationId : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_canadacentral_MI_1
Este comando define o tipo de licença e/ou tags para um pool de instâncias chamado instancePool0.
Parâmetros
-AsJob
Executar cmdlet em segundo plano
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Confirm
Solicita a sua confirmação antes de executar o cmdlet.
Type: | SwitchParameter |
Aliases: | cf |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DefaultProfile
As credenciais, a conta, o locatário e a assinatura usados para comunicação com o Azure.
Type: | IAzureContextContainer |
Aliases: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-InputObject
O objeto de entrada do pool de instâncias.
Type: | AzureSqlInstancePoolModel |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-LicenseType
Determina qual tipo de licença usar. Os valores possíveis são BasePrice (com desconto AHB) e LicenseIncluded (sem desconto AHB).
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Name
O nome do pool de instâncias.
Type: | String |
Aliases: | InstancePoolName |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResourceGroupName
O nome do grupo de recursos.
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResourceId
O identificador de recurso do pool de instâncias.
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-Tag
As tags a serem associadas à instância
Type: | Hashtable |
Aliases: | Tags |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-WhatIf
Apresenta o que aconteceria mediante a execução do cmdlet. O cmdlet não é executado.
Type: | SwitchParameter |
Aliases: | wi |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
Entradas
Saídas
Azure PowerShell
Comentários
https://aka.ms/ContentUserFeedback.
Brevemente: Ao longo de 2024, vamos descontinuar progressivamente o GitHub Issues como mecanismo de feedback para conteúdos e substituí-lo por um novo sistema de feedback. Para obter mais informações, veja:Submeter e ver comentários