Get Subscription Metadata (classic)

 

THIS TOPIC APPLIES TO: noSQL Server yesAzure SQL DatabaseyesAzure SQL Data Warehouse noParallel Data Warehouse

Retrieves the metadata for a Microsoft Azure subscription.

Important

The recommended REST commands to work with SQL Database are the Resource Manager based Azure SQL Database REST API. While there is no change to SQL Database, be aware that the classic deployment model command in this article is scheduled for deprecation on December 1, 2019. For a table providing links to the specific new commands you should use, see Operations for Azure SQL Databases.

Request

The Get Subscription Metadata request must be specified as follows:

Replace {subscriptionId} with your subscription ID.

Method Request URI HTTP Version
GET https://management.core.windows.net:8443/{subscriptionId}/services/sqlservers/subscriptioninfo HTTP/1.1

If an operation returns success, the operation is complete and changes are effective immediately. If an operation fails because of a user error, no changes are applied. If there is a communication error or internal server error, you should check the status of the operation using List Servers (classic).

URI Parameters

None.

Request Headers

The following table describes the required and optional request headers:

Request Header Description
x-ms-version Required. Specifies the version of the operation to use for this request. This header should be set to 2012-03-01.

Request Body

None.

Response

The response includes an HTTP status code, a set of response headers, and a response body.

Status Code

Response Headers

The response for this operation includes the following headers. The response may also include additional standard HTTP headers. All standard headers conform to the HTTP/1.1 protocol specification.

Response Header Description
x-ms-request-id A value that uniquely identifies a request made against the database management service. This request id is used for request tracking. If a failure occurs that requires the user to contact Microsoft Support, the request id should be provided to Microsoft to assist in tracking and resolving the failure for the request.

Response Body

The following is an example response body:

<ServiceResource xmlns="http://schemas.microsoft.com/windowsazure" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">  
  <Name>MyAzureSubscriptionName</Name>  
  <Type>Microsoft.SqlAzure.Subscription</Type>  
  <State i:nil="true" />  
  <SelfLink i:nil="true" />  
  <ParentLink i:nil="true" />  
  <DatabaseQuota>500</DatabaseQuota>  
  <Id>6705f9ad-647a-4e35-8e92-07669281dd0c</Id>  
  <ServerQuota>150</ServerQuota>  
  <HasFreeDatabase>false</HasFreeDatabase>  
  <Locations i:nil="true" />  
  <Versions>  
    <Version>  
      <Name>1.0</Name>  
      <IsDefault>false</IsDefault>  
      <Editions>  
        <Edition>  
          <Name>Web</Name>  
          <IsDefault>true</IsDefault>  
          <ServiceLevelObjectives>  
            <ServiceLevelObjective>  
              <Name>Shared</Name>  
              <IsDefault>true</IsDefault>  
              <ID>910b4fcb-8a29-4c3e-958f-f7ba794388b2</ID>  
              <MaxSizes>  
                <MaxSize>  
                  <Value>20</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>1</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>true</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>5</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
              </MaxSizes>  
              <PerformanceLevel>  
                <Value>0</Value>  
                <Unit>DTU</Unit>  
              </PerformanceLevel>  
            </ServiceLevelObjective>  
          </ServiceLevelObjectives>  
        </Edition>  
        <Edition>  
          <Name>Business</Name>  
          <IsDefault>false</IsDefault>  
          <ServiceLevelObjectives>  
            <ServiceLevelObjective>  
              <Name>Shared</Name>  
              <IsDefault>true</IsDefault>  
              <ID>910b4fcb-8a29-4c3e-958f-f7ba794388b2</ID>  
              <MaxSizes>  
                <MaxSize>  
                  <Value>10</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>true</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>20</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>30</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>40</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>50</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>150</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
              </MaxSizes>  
              <PerformanceLevel>  
                <Value>0</Value>  
                <Unit>DTU</Unit>  
              </PerformanceLevel>  
            </ServiceLevelObjective>  
          </ServiceLevelObjectives>  
        </Edition>  
        <Edition>  
          <Name>Premium</Name>  
          <IsDefault>false</IsDefault>  
          <ServiceLevelObjectives>  
            <ServiceLevelObjective>  
              <Name>P1</Name>  
              <IsDefault>true</IsDefault>  
              <ID>7203483a-c4fb-4304-9e9f-17c71c904f5d</ID>  
              <MaxSizes>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>500</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>1</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>2</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>5</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>10</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>20</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>30</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>40</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>50</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>150</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>200</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>250</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>300</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>400</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>500</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>true</IsDefault>  
                </MaxSize>  
              </MaxSizes>  
              <PerformanceLevel>  
                <Value>100</Value>  
                <Unit>DTU</Unit>  
              </PerformanceLevel>  
            </ServiceLevelObjective>  
            <ServiceLevelObjective>  
              <Name>P2</Name>  
              <IsDefault>false</IsDefault>  
              <ID>a7d1b92d-c987-4375-b54d-2b1d0e0f5bb0</ID>  
              <MaxSizes>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>500</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>1</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>2</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>5</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>10</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>20</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>30</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>40</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>50</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>150</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>200</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>250</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>300</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>400</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>500</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>true</IsDefault>  
                </MaxSize>  
              </MaxSizes>  
              <PerformanceLevel>  
                <Value>200</Value>  
                <Unit>DTU</Unit>  
              </PerformanceLevel>  
            </ServiceLevelObjective>  
            <ServiceLevelObjective>  
              <Name>P3</Name>  
              <IsDefault>false</IsDefault>  
              <ID>a7c4c615-cfb1-464b-b252-925be0a19446</ID>  
              <MaxSizes>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>500</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>1</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>2</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>5</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>10</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>20</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>30</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>40</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>50</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>150</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>200</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>250</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>300</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>400</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>500</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>true</IsDefault>  
                </MaxSize>  
              </MaxSizes>  
              <PerformanceLevel>  
                <Value>800</Value>  
                <Unit>DTU</Unit>  
              </PerformanceLevel>  
            </ServiceLevelObjective>  
          </ServiceLevelObjectives>  
        </Edition>  
      </Editions>  
    </Version>  
    <Version>  
      <Name>2.0</Name>  
      <IsDefault>true</IsDefault>  
      <Editions>  
        <Edition>  
          <Name>Web</Name>  
          <IsDefault>false</IsDefault>  
          <ServiceLevelObjectives>  
            <ServiceLevelObjective>  
              <Name>Shared</Name>  
              <IsDefault>true</IsDefault>  
              <ID>910b4fcb-8a29-4c3e-958f-f7ba794388b2</ID>  
              <MaxSizes>  
                <MaxSize>  
                  <Value>20</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>1</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>true</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>5</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
              </MaxSizes>  
              <PerformanceLevel>  
                <Value>0</Value>  
                <Unit>DTU</Unit>  
              </PerformanceLevel>  
            </ServiceLevelObjective>  
          </ServiceLevelObjectives>  
        </Edition>  
        <Edition>  
          <Name>Business</Name>  
          <IsDefault>false</IsDefault>  
          <ServiceLevelObjectives>  
            <ServiceLevelObjective>  
              <Name>Shared</Name>  
              <IsDefault>true</IsDefault>  
              <ID>910b4fcb-8a29-4c3e-958f-f7ba794388b2</ID>  
              <MaxSizes>  
                <MaxSize>  
                  <Value>10</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>true</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>20</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>30</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>40</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>50</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>150</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
              </MaxSizes>  
              <PerformanceLevel>  
                <Value>0</Value>  
                <Unit>DTU</Unit>  
              </PerformanceLevel>  
            </ServiceLevelObjective>  
          </ServiceLevelObjectives>  
        </Edition>  
        <Edition>  
          <Name>Basic</Name>  
          <IsDefault>false</IsDefault>  
          <ServiceLevelObjectives>  
            <ServiceLevelObjective>  
              <Name>Basic</Name>  
              <IsDefault>true</IsDefault>  
              <ID>dd6d99bb-f193-4ec1-86f2-43d3bccbc49c</ID>  
              <MaxSizes>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>500</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>1</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>2</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>true</IsDefault>  
                </MaxSize>  
              </MaxSizes>  
              <PerformanceLevel>  
                <Value>5</Value>  
                <Unit>DTU</Unit>  
              </PerformanceLevel>  
            </ServiceLevelObjective>  
          </ServiceLevelObjectives>  
        </Edition>  
        <Edition>  
          <Name>Standard</Name>  
          <IsDefault>true</IsDefault>  
          <ServiceLevelObjectives>  
            <ServiceLevelObjective>  
              <Name>S0</Name>  
              <IsDefault>true</IsDefault>  
              <ID>f1173c43-91bd-4aaa-973c-54e79e15235b</ID>  
              <MaxSizes>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>500</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>1</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>2</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>5</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>10</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>20</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>30</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>40</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>50</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>150</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>200</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>250</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>true</IsDefault>  
                </MaxSize>  
              </MaxSizes>  
              <PerformanceLevel>  
                <Value>10</Value>  
                <Unit>DTU</Unit>  
              </PerformanceLevel>  
            </ServiceLevelObjective>  
            <ServiceLevelObjective>  
              <Name>S1</Name>  
              <IsDefault>false</IsDefault>  
              <ID>1b1ebd4d-d903-4baa-97f9-4ea675f5e928</ID>  
              <MaxSizes>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>500</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>1</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>2</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>5</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>10</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>20</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>30</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>40</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>50</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>150</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>200</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>250</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>true</IsDefault>  
                </MaxSize>  
              </MaxSizes>  
              <PerformanceLevel>  
                <Value>20</Value>  
                <Unit>DTU</Unit>  
              </PerformanceLevel>  
            </ServiceLevelObjective>  
            <ServiceLevelObjective>  
              <Name>S2</Name>  
              <IsDefault>false</IsDefault>  
              <ID>455330e1-00cd-488b-b5fa-177c226f28b7</ID>  
              <MaxSizes>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>500</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>1</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>2</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>5</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>10</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>20</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>30</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>40</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>50</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>150</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>200</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>250</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>true</IsDefault>  
                </MaxSize>  
              </MaxSizes>  
              <PerformanceLevel>  
                <Value>50</Value>  
                <Unit>DTU</Unit>  
              </PerformanceLevel>  
            </ServiceLevelObjective>  
          </ServiceLevelObjectives>  
        </Edition>  
        <Edition>  
          <Name>Premium</Name>  
          <IsDefault>false</IsDefault>  
          <ServiceLevelObjectives>  
            <ServiceLevelObjective>  
              <Name>P1</Name>  
              <IsDefault>true</IsDefault>  
              <ID>7203483a-c4fb-4304-9e9f-17c71c904f5d</ID>  
              <MaxSizes>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>500</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>1</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>2</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>5</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>10</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>20</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>30</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>40</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>50</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>150</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>200</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>250</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>300</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>400</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>500</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>true</IsDefault>  
                </MaxSize>  
              </MaxSizes>  
              <PerformanceLevel>  
                <Value>100</Value>  
                <Unit>DTU</Unit>  
              </PerformanceLevel>  
            </ServiceLevelObjective>  
            <ServiceLevelObjective>  
              <Name>P2</Name>  
              <IsDefault>false</IsDefault>  
              <ID>a7d1b92d-c987-4375-b54d-2b1d0e0f5bb0</ID>  
              <MaxSizes>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>500</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>1</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>2</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>5</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>10</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>20</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>30</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>40</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>50</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>150</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>200</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>250</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>300</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>400</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>500</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>true</IsDefault>  
                </MaxSize>  
              </MaxSizes>  
              <PerformanceLevel>  
                <Value>200</Value>  
                <Unit>DTU</Unit>  
              </PerformanceLevel>  
            </ServiceLevelObjective>  
            <ServiceLevelObjective>  
              <Name>P3</Name>  
              <IsDefault>false</IsDefault>  
              <ID>a7c4c615-cfb1-464b-b252-925be0a19446</ID>  
              <MaxSizes>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>500</Value>  
                  <Unit>MB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>1</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>2</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>5</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>10</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>20</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>30</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>40</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>50</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>100</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>150</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>200</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>250</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>300</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>400</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>false</IsDefault>  
                </MaxSize>  
                <MaxSize>  
                  <Value>500</Value>  
                  <Unit>GB</Unit>  
                  <IsDefault>true</IsDefault>  
                </MaxSize>  
              </MaxSizes>  
              <PerformanceLevel>  
                <Value>800</Value>  
                <Unit>DTU</Unit>  
              </PerformanceLevel>  
            </ServiceLevelObjective>  
          </ServiceLevelObjectives>  
        </Edition>  
      </Editions>  
    </Version>  
  </Versions>  
</ServiceResource>  
  

Example

The following console application returns the metadata for a subscription.

Replace the following values:

  • {subscriptionId} – replace with the subscription identifier for your subscription.

  • {thumbprint} – replace with the thumbprint of a management certificate in your subscription.

using System;  
using System.Collections.Generic;  
using System.Linq;  
using System.Text;  
using System.Threading.Tasks;  
using System.IO;  
using System.Xml;  
using System.Security;  
using System.Security.Cryptography;  
using System.Security.Cryptography.X509Certificates;  
using System.Net;  
  
namespace GetSubscriptionMetadata  
{  
    /// <summary>  
    /// Gets metadata for a subscription.  
    /// </summary>  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            Uri requestUri = new Uri("https://management.core.windows.net:8443/"  
                        + "{subscriptionId}"  
                        + "/services/sqlservers/subscriptioninfo");  
  
            // Create the request and specify attributes.  
            HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(requestUri);  
  
            // Add a x-ms-version header to specify API version.  
            request.Headers.Add("x-ms-version", "2012-03-01");  
  
            // Generate a request ID that can be used to identify this request in the service logs.  
            string clientRequestId = Guid.NewGuid().ToString();  
            request.Headers.Add("x-ms-client-request-id", clientRequestId);  
            request.Method = "GET";  
            request.ContentType = "application/xml";  
  
            // The thumbprint value of the management certificate.  
            // Replace {thumbprint} with the thumbprint of a management certificate associated with your subscription.  
            // It must also be installed on the machine accessing the API.  
            string certThumbprint = "{thumbprint}";  
  
            // Create a reference to the My certificate store.  
            X509Store certStore = new X509Store(StoreName.My, StoreLocation.CurrentUser);  
  
            // Open the store.  
            certStore.Open(OpenFlags.ReadOnly);  
  
            // Find the certificate that matches the thumbprint.  
            X509Certificate2Collection certCollection = certStore.Certificates.Find(X509FindType.FindByThumbprint, certThumbprint, false);  
            certStore.Close();  
  
            // Verify the certificate was added to the collection.  
            if (0 == certCollection.Count)  
            {  
                throw new Exception("Error: No certificate found with thumbprint " + certThumbprint);  
            }  
  
            // Create an X509Certificate2 object using our matching certificate.  
            X509Certificate2 certificate = certCollection[0];  
  
            // Attach the certificate to the request.  
            request.ClientCertificates.Add(certificate);  
  
            try  
            {  
                using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())  
                using (Stream responseStream = response.GetResponseStream())  
                using (StreamReader reader = new StreamReader(responseStream))  
                {  
                    // Display the client request ID.  
                    Console.WriteLine("clientRequestId: " + clientRequestId);  
  
                    // Display the web response status code.  
                    Console.WriteLine("Response status code: " + response.StatusCode);  
  
                    // Display the request ID returned by Windows Azure.  
                    Console.WriteLine("x-ms-request-id: "  
                        + response.Headers["x-ms-request-id"]);  
  
                    // Display the raw response.  
                    Console.WriteLine("Received response:");  
                    Console.WriteLine(reader.ReadToEnd());  
                }  
            }  
            catch (Exception e)  
            {  
                Console.WriteLine(e.StackTrace);  
            }  
        }  
    }  
}  

See Also

Common REST API Error Codes
Azure SQL Database
Operations for Azure SQL Databases
Azure SQL Database Cmdlets