Get-AzureSqlDatabaseServerQuota
Gets quota information for an Azure SQL Database server.
Note
The cmdlets referenced in this documentation are for managing legacy Azure resources that use Azure Service Manager (ASM) APIs. This legacy PowerShell module isn't recommended when creating new resources since ASM is scheduled for retirement. For more information, see Azure Service Manager retirement.
The Az PowerShell module is the recommended PowerShell module for managing Azure Resource Manager (ARM) resources with PowerShell.
Syntax
ByConnectionContext
Get-AzureSqlDatabaseServerQuota
-ConnectionContext <IServerDataServiceContext>
[-QuotaName <String>]
[-Profile <AzureSMProfile>]
[<CommonParameters>]
ByServerName
Get-AzureSqlDatabaseServerQuota
-ServerName <String>
[-QuotaName <String>]
[-Profile <AzureSMProfile>]
[<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.
Parameters
-ConnectionContext
Specifies the connection context of a server.
Parameter properties
| Type: | IServerDataServiceContext |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
| Aliases: | Context |
Parameter sets
ByConnectionContext
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | True |
| Value from pipeline by property name: | True |
| Value from remaining arguments: | False |
-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.
Parameter properties
| Type: | AzureSMProfile |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-QuotaName
Specifies the name of the quota value that this cmdlet gets.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | True |
| Value from remaining arguments: | False |
-ServerName
Specifies the name of a server.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
ByServerName
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | True |
| Value from remaining arguments: | False |
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
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.