Get-​Azure​Sql​Database​Server​Quota

Gets quota information for an Azure SQL Database server.

Syntax

Get-AzureSqlDatabaseServerQuota
   -ConnectionContext <IServerDataServiceContext>
   [-Profile <AzureSMProfile>]
   [-QuotaName <String>]
   [<CommonParameters>]
Get-AzureSqlDatabaseServerQuota
   [-Profile <AzureSMProfile>]
   [-QuotaName <String>]
   -ServerName <String>
   [<CommonParameters>]

Description

The Get-AzureSqlDatabaseServerQuota cmdlet gets the quota information for a specified instance of Azure SQL Database Server. Specify a connection context or the server name. If you do not specify a quota name, this cmdlet gets all the quota information for the server.

Examples

Example 1: Get information for a specific quota

PS C:\> $QuotaPremium = GetAzureSqlDatabaseServerQuota $Context -QuotaName "Premium_Databases"

This command gets the quota named Premium_Databases from the Azure SQL Database server specified by the connection stored in the $Context variable.

Example 2: Get information for all quotas

PS C:\> $QuotaList = GetAzureSqlDatabaseServerQuota $Context

This command gets all quota values from the server specified by the connection $Context.

Required Parameters

-ConnectionContext

Specifies the connection context of a server.

Type:IServerDataServiceContext
Aliases:Context
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
-QuotaName

Specifies the name of the quota value that this cmdlet gets.

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

Outputs

Microsoft.WindowsAzure.Commands.SqlDatabase.Services.Server.ServerQuota[]

Notes

  • Authentication: This cmdlet can use either SQL Server authentication or certificate-based authentication. For examples of setting up authentication, see the New-AzureSqlDatabaseServerContext cmdlet.