Get-AzureSqlDatabaseServiceObjective

Updated: January 5, 2016

Applies To: Azure PowerShell 1.0

Get-AzureSqlDatabaseServiceObjective

Gets service objectives for an Azure SQL Database server.

Syntax

Parameter Set: ByConnectionContext
Get-AzureSqlDatabaseServiceObjective [-Context] <IServerDataServiceContext> [-Profile <AzureSMProfile> ] [-ServiceObjective <ServiceObjective> ] [-ServiceObjectiveName <String> ] [ <CommonParameters>]

Parameter Set: ByServerName
Get-AzureSqlDatabaseServiceObjective [-ServerName] <String> [-Profile <AzureSMProfile> ] [-ServiceObjective <ServiceObjective> ] [-ServiceObjectiveName <String> ] [ <CommonParameters>]




Detailed 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.

Parameters

-Context<IServerDataServiceContext>

Specifies the connection context of a server.


Aliases

none

Required?

true

Position?

1

Default Value

none

Accept Pipeline Input?

True (ByValue, ByPropertyName)

Accept Wildcard Characters?

false

-Profile<AzureSMProfile>

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


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ServerName<String>

Specifies the name of a server.


Aliases

none

Required?

true

Position?

1

Default Value

none

Accept Pipeline Input?

True (ByPropertyName)

Accept Wildcard Characters?

false

-ServiceObjective<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.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

True (ByValue)

Accept Wildcard Characters?

false

-ServiceObjectiveName<String>

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


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

<CommonParameters>

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see    about_CommonParameters.

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

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

Outputs

The output type is the type of the objects that the cmdlet emits.

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

Examples

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

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


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

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

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


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

Related topics

Show: