Prerequisites for Azure Marketplace deployment

To deploy SQL Tran on Azure Marketplace, one needs to have quota in the region where they plan to deploy:

1. Quota for our web application

2. Quota for the managed Postgres database we use to keep track of the projects

Quota for the web application

Unfortunately, AppService web application quota cannot be provisioned using the Azure portal. You need to ask support for it.

First, open a support request.

Open a support request

Then, pick Azure services, Service and subscription limits (quotas), select the desired subscription, and choose the "Web app" quota type.

Specify it's about the Web App

In request details, specify that you need "P3mv3", which means a 8-core vcpu with 64 GB of RAM.

In details, specify you need P3mv3

Database quota

For Postgres database, you do not need to raise a support ticket, fortunately.

Search for Quotas in Azure portal.

Click the "Azure PostgreSQL" button.

Select Postgres quotas

We need a "Standard_D2s_v3" instance, so let's search for DSv3. Once that's listed, select your region and click on the tiny pencil icon on the right end of its row to edit the region quota.

Edit your region

Change the limit. We only need two, but if you are at zero, perhaps set it to 4 or 8.

Do not forget to click Submit :)