Get-​Azure​Sql​Database​Service​Objective

Gets service objectives for an Azure SQL Database server.

Syntax

Get-AzureSqlDatabaseServiceObjective
   -Context <IServerDataServiceContext>
   [-Profile <AzureSMProfile>]
   [-ServiceObjective <ServiceObjective>]
   [-ServiceObjectiveName <String>]
   [<CommonParameters>]
Get-AzureSqlDatabaseServiceObjective
   [-Profile <AzureSMProfile>]
   -ServerName <String>
   [-ServiceObjective <ServiceObjective>]
   [-ServiceObjectiveName <String>]
   [<CommonParameters>]

Description

The Get-AzureSqlDatabaseServiceObjective cmdlet gets service objectives for an Azure SQL Database server. Service objectives are referred to as performance levels. If you do not specify a service objective, this cmdlet returns all valid service objectives for the specified server.

This cmdlet applies to Basic, Standard, and Premium service tiers.

Examples

Example 1: Get all the service objectives by using a connection context

PS C:\> Get-AzureSqlDatabaseServiceObjective -Context $Context

This command gets all the service objectives for the server that the connection context $Context specifies.

Example 2: Get all the service objectives by using a server name

PS C:\> Get-AzureSqlDatabaseServiceObjective -ServerName "Server01"

This command gets all the service objectives for the server named Server01.

Required Parameters

-Context

Specifies the connection context of a server.

Type:IServerDataServiceContext
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName, ByValue)
Accept wildcard characters:False
-ServerName

Specifies the name of a server.

Type:String
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

Optional Parameters

-Profile

Specifies the Azure profile from which this cmdlet reads. If you do not specify a profile, this cmdlet reads from the local default profile.

Type:AzureSMProfile
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-ServiceObjective

Specifies an object that represents the service objective that this cmdlet gets. Valid values are:

  • Basic: dd6d99bb-f193-4ec1-86f2-43d3bccbc49c
  • Standard (S0): f1173c43-91bd-4aaa-973c-54e79e15235b
  • Standard (S1): 1b1ebd4d-d903-4baa-97f9-4ea675f5e928
  • Standard (S2): 455330e1-00cd-488b-b5fa-177c226f28b7
  • *Standard (S3): 789681b8-ca10-4eb0-bdf2-e0b050601b40
  • Premium (P1): 7203483a-c4fb-4304-9e9f-17c71c904f5d
  • Premium (P1): 7203483a-c4fb-4304-9e9f-17c71c904f5d
  • Premium (P2): a7d1b92d-c987-4375-b54d-2b1d0e0f5bb0
  • Premium (P3): a7c4c615-cfb1-464b-b252-925be0a19446

*Standard (S3) is part of the Latest SQL Database Update V12 (preview). For more information, see What's New in the Azure SQL Database V12 Preview (http://azure.microsoft.com/documentation/articles/sql-database-preview-whats-new/) in the Azure library.

Type:ServiceObjective
Position:Named
Default value:None
Accept pipeline input:True (ByValue)
Accept wildcard characters:False
-ServiceObjectiveName

Specifies the name of a service objective to get. Valid values are: Basic, S0, S1, S2, S3, P1, P2, and P3.

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

Inputs

Microsoft.WindowsAzure.Commands.SqlDatabase.Services.Server.ServiceObjective

Outputs

IEnumerable\<Microsoft.WindowsAzure.Commands.SqlDatabase.Services.Server.ServiceObjective\>