Cmdlets

Choose a cmdlet from the list on the left or search for a specific cmdlet. Choose a cmdlet from the list or search for a specific cmdlet.
About Help  Providers
 

Get-AzureSqlDatabaseServiceObjective

Get-AzureSqlDatabaseServiceObjective

microsoft.windowsazure.commands.sqldatabase.dll

Synopsis

Returns a service objective for the specified Azure SQL Database Server.

Syntax

Get-AzureSqlDatabaseServiceObjective [-Context] [-ServiceObjective] [-ServiceObjectiveName] [<CommonParameters>]

Get-AzureSqlDatabaseServiceObjective [-ServerName] [-ServiceObjective] [-ServiceObjectiveName] [<CommonParameters>]

Detailed Description

If the service objective is not specified, this cmdlet returns all service objectives for the specified Azure SQL Database Server.Note: This cmdlet applies to Basic, Standard, and Premium service tiers, which are available in preview. To learn more about the preview, please see http://go.microsoft.com/fwlink/p/?LinkId=308949.

Parameters

-Context <IServerDataServiceContext>

The connection context to the specified SQL Database Server.

Aliases

None

Required?

true

Position

0

Default value

None

Accept pipeline input?

true (ByValue, ByPropertyName)

Accept wildcard characters?

false

-ServiceObjective <ServiceObjective>

An object representing the service objective to return. If not specified, then all the service objectives for the SQL Database Server are returned.

Aliases

None

Required?

false

Position

named

Default value

None

Accept pipeline input?

true (ByValue)

Accept wildcard characters?

false

-ServiceObjectiveName <String>

The name of the service objective to return. If not specified, then all the service objectives for the SQL Database Server are returned.

Aliases

None

Required?

false

Position

named

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

-ServerName <String>

Aliases

None

Required?

true

Position

0

Default value

None

Accept pipeline input?

true (ByPropertyName)

Accept wildcard characters?

false

Input Type

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

Return Type

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

Notes

Examples

-------------------------- EXAMPLE 1 --------------------------

This example displays all the service objectives for the SQL Database Server specified by the connection context $ctx.

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

-------------------------- EXAMPLE 2 --------------------------

This example displays all the service objectives for the SQL Database Server "server1", using certificate authentication.

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

Online Version