Get-AzureSqlDatabaseServiceObjective
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
Get-AzureSqlDatabaseServiceObjective
Returns a service objective for the specified Windows Azure SQL Database Server.
Syntax
Parameter Set: ByName
Get-AzureSqlDatabaseServiceObjective [-Context] <IServerDataServiceContext> [[-ServiceObjectiveName] <String> ] [ <CommonParameters>]
Parameter Set: ByInputObject
Get-AzureSqlDatabaseServiceObjective [-Context] <IServerDataServiceContext> [[-ServiceObjective] <ServiceObjective> ] [ <CommonParameters>]
Detailed Description
If the service objective is not specified, this cmdlet returns all service objectives for the specified Windows Azure SQL Database Server.
Note: This cmdlet is part of the preview of Windows Azure SQL Database Premium Edition. Only participants in the preview are able to use this cmdlet. To learn more about the preview, please see https://go.microsoft.com/fwlink/p/?LinkId=308949.
Parameters
-Context<IServerDataServiceContext>
The connection context to the specified SQL Database Server.
Aliases |
none |
Required? |
true |
Position? |
1 |
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? |
2 |
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? |
2 |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
<CommonParameters>
This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. 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.Management.SqlDatabase.Services.Server.ServiceObjective
Outputs
The output type is the type of the objects that the cmdlet emits.
- IEnumerable<Microsoft.WindowsAzure.Management.SqlDatabase.Services.Server.ServiceObjective>
Examples
-------------- EXAMPLE 1 --------------
This example displays all the service objectives for the SQL Database Server specified by the connection $ctx.
C:\PS>Get-SqlServiceObjective $ctx | Format-Table Name, State, DateCreated, IsDefault, CreatedBy