Adaptive Server Enterprise became a new database offering within SAP HANA Cloud and enables you to use ASE, ASE Replication, Data Lake and HANA database services side by side in any kind of combinations for your applications – while the databases are fully operated by SAP in the SAP HANA Cloud.
In the first ‘step by step’ blog post – yep, that might become a series – you provisioned your first SAP HANA Cloud, adaptive server enterprise database.
In this blog post I want to show you how to change some of the database settings after the provisioning. The second part is about cost estimation and calculation, because not all of us might have an unlimited budget.
Step 1: Edit the provisioning characteristics of your ASE database
Here we are, our ASE database is up and running in SAP HANA Cloud. We can see the status and the provisioning details when we go into the SAP BTP Cockpit and from there to SAP HANA Cloud Central.
On the right end of your database details you see a line of three rings. A mouse-click shows you the pop-up with the available actions. You can also Stop and even Delete your database from here, but we are more interested to examine the Edit options.
- Page size
- Character Set
- Sort Order
The first change option is for the description of your instance. This may sound trivial, but comes in handy, if you skipped this step in the beginning. (a.k.a. I can do the documentation later)
An important option is of course to change the Compute (in- or decrease the number of your vCPUs) and Memory Type. This is what we expect from a cloud environment. But stop, we can’t change the Total Storage? Can that be true?
Don’t panic! The change of Total Storage size happens in the Storage Distribution section. Change and distribute the data storage and the log storage as per your needs.
You also have the full change options for Backup Frequency and Retention, as well as for the Connections settings.
I am increasing the data storage of my instance to demonstrate what happens. Directly after you confirmed the changes you will see your instance in the status STARTING and just a moment later (use the Refresh button) it is back running.
Step 2: Estimate and calculate your costs
Starting small and updating resources as needed is always a good method to reduce the costs of cloud subscription. The SAP HANA Cloud Capacity Unit Estimator has been updated to help you estimating the Capacity Unity per month for your ASE instance.
At the time this blog post is written ‘Microsoft Azure’ is the only available Hyperscaler option, but this will change in the next months.
For more details about the estimation process not only for the ASE service, but as well for ASE Replication, Data Lake and HANA please have a look at this article in the SAP HANA Journey space.
The next step is to use the SAP BTP Estimator Tool to calculate the costs in your currency.
Ongoing cost tracking is then again another topic and I plan to write something about this, when I will have some weeks of data for my system available.