Use the Administrator SQL Resource Provider User Interface to Create DBaaS Plan and Resource Allocation
Step 1 On the WAP Admin Portal, log in with your Active Directory user ID and password.
Step 2 Open the SQL Server RP tab. At the bottom of screen, click + New to add a group.
Step 3 Enter the Group Name and specify whether it is standalone or HA. In this example, HA selection is Always on (enabled).
Step 4 Check the SQL Server Group View to verify that the Group is created when done.
Step 5 Add an SQL Server to the new group.
Step 6 Specify the Server Name, User Name/Password, and Instance Disk Size Allocation.
Step 7 Create a New Resource Pool Template by clicking + New (Add Template).
Step 8 In the resulting form, specify the template name and define the resource allocation.
Step 9 Set the Workload Group settings for the new template
Note The maximum memory must be the same as the minimum assigned memory previously defined in the resource allocation parameters.
Step 10 Create a new plan.
Step 11 In the plan creation view, specify the plan name.
Step 12 Select the applicable services (a function of the resource providers previously registered to WAP for the cloud).
If add-on service options are defined (extra capacity in this example), they may be offered for inclusion in this new plan.
Step 13 View the list of defined plans to verify that the new plan is included.
Step 14 Configure service quotas. Click the new plan (Min-RGPlan) from the list in the view above to view its dashboard listing the available services.
Step 15 Click the SQL Servers service to begin configuring quotas for the servers associated with this DBaaS plan on which the databases will be created per tenant request.
Step 16 Add the SQL Server Group to the plan with the desired quotas. These include the number of allowed databases and size per database, per tenant subscription.
Step 17 From the SQL Server view within the plan, see the list of defined groups to verify that the newly defined group is listed.
Step 18 Select the newly created plan from the plan list to change the plan from the default “private” to “public” so that it is selectable from the tenant service management portal.
Use the Tenant SQL Resource Provider User Interface to Create DBaaS Plan and Resource Allocation
Step 1 Login to the WAP Tenant Administrator portal. Enter your username/password.
Step 2 Subscribe to a plan. Go to My Account and select Add Plan.
Alternatively, +New may be used to add a subscription.
Step 3 From the resulting list of available plan(s) previously created and published through the SP Admin UI, select a shared DBaaS plan.
Step 4 Check My Account subscriptions to verify that the new service subscription is listed.
Step 5 Create new database. Click + New to bring up the SQL Server Database/Create Database option.
Step 6 In resulting view, select the database name and associated plan from the pull-down list of plans to which the tenant has subscribed.
Step 7 Enter credentials for database access in the resulting view.
Step 8 View the list of defined SQL databases to verify that the newly created one is included.
Step 9 View the Database Credentials. Select the newly created database from the list. From the bottom of the Tenant Service Management Portal, select View Info to see the SQL database access credentials for that database.