Get-AzureRmSqlServerServiceObjective

NAME Get-AzureRmSqlServerServiceObjective



SYNOPSIS

Gets service objectives for an Azure SQL Database server.





SYNTAX

Get-AzureRmSqlServerServiceObjective [-ResourceGroupName] <String> [-ServerName] <String> [[-DatabaseName] <String>] [[-ServiceObjectiveName]

<String>] [-DefaultProfile <IAzureContextContainer>] [-Confirm] [-WhatIf] [<CommonParameters>]





DESCRIPTION

The Get-AzureRmSqlServerServiceObjective cmdlet gets the available service objectives for an Azure SQL Database server.





PARAMETERS

-DatabaseName <String>

SQL Database name.



Required? false

Position? 2

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-DefaultProfile <IAzureContextContainer>

The credentials, account, tenant, and subscription used for communication with azure



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-ResourceGroupName <String>

Specifies the name of a resource group. This cmdlet gets service objectives for a SQL Database server assigned to this resource.



Required? true

Position? 0

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ServerName <String>

Specifies the name of a SQL Database SQL Database server.



Required? true

Position? 1

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ServiceObjectiveName <String>

Specifies the name of a service objective for an Azure SQL Database server. The acceptable values for this parameter are: Basic, S0, S1, S2,

P1, P2, and P3.



Required? false

Position? 2

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-Confirm [<SwitchParameter>]

Prompts you for confirmation before running the cmdlet.



Required? false

Position? named

Default value False

Accept pipeline input? False

Accept wildcard characters? false



-WhatIf [<SwitchParameter>]

Shows what would happen if the cmdlet runs. The cmdlet is not run.



Required? false

Position? named

Default value False

Accept pipeline input? False

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).



INPUTS

None

This cmdlet does not accept any input.





OUTPUTS

Microsoft.Azure.Commands.Sql.ServiceObjective.Model.AzureSqlServerServiceObjectiveModel







NOTES









Example 1: Get service objectives



PS C:\\>Get-AzureRmSqlServerServiceObjective -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01"

ResourceGroupName ServerName ServiceObjectiveName Description Enabled IsDefault IsSystem

----------------- ---------- -------------------- ----------- ------- --------- --------

resourcegroup01 server01 ElasticPool True False False

resourcegroup01 server01 System True False True

resourcegroup01 server01 System0 True False True

resourcegroup01 server01 System1 True False True

resourcegroup01 server01 System2 True True True

resourcegroup01 server01 Basic True True False

resourcegroup01 server01 S0 True True False

resourcegroup01 server01 S1 True False False

resourcegroup01 server01 S2 True False False

resourcegroup01 server01 S3 True False False

resourcegroup01 server01 P1 True True False

resourcegroup01 server01 P2 True False False

resourcegroup01 server01 P3 True False False

resourcegroup01 server01 P4 True False False



This command gets the service objectives for the server named Server01 and the database named Database01.







RELATED LINKS

Online Version: https://docs.microsoft.com/en-us/powers ... eobjective

SQL Database Documentation https://docs.microsoft.com/azure/sql-database/