In this blog post you will get a clear, step-by-step process of how to install and run the HANA Sizing Report (described in SAP Note 1872170), with screenshots accompanying each step.
When dealing with sizing requests from the presales field, I typically ran into the problem of not having clear instructions to follow for running the Sizing Report available on any of the knowledge share platforms. I had put a guide together in a personal document for my own reference when I had to talk colleagues through the steps involved, but felt that it could be a useful to make a blog post on the topic as a knowledge share for newcomers who are running the report for the first time.
Next, I will share the main steps to follow.
Steps involved
1) Check System Version
The first thing to do is to verify the version of your system that you are going to install and run the report on. This report runs on SAP_BASIS 620 and higher.
Click System > Status then under SAP System Data click the magnifying glass icon:
Once you know you are on the required system version, you can follow the steps to run the report.
Run the Report
Access the system you want to run the report on via SAP Logon with your system credentials.
In the search bar you need to access transaction SE38:
In the next window access program /SDF/HDB_SIZING and then click the Execute button (or hit the F8 key):
If you see a screen like this, it would indicate a very old version of the report and an update of the report will be required:
The steps for how to do the update are explained in the final section of this blog: “4) Update the Report on the System”
The newer version contains a lot more fields. It looks like this:
In the Technical Options section you can set the number of parallel dialog processes. It is recommended that you change the number of parallel processes from the default, here it was 1 by for example. But the standard recommendation would be to set it to 3.
To execute the program, Click Program in top left, and then choose to either Execute or Execute in Background:
For background execution, click the green tick button:
Click Immediate to run straight away:
Then click the Save icon:
A message will be displayed the the report is now running:
To check on the progress of the job running, you can go to transaction SM37:
Click the Execute button:
You will see it is the Active job that is currently running under /SDF/HDB_SIZING. Click on the “Active” status in the table:
Then on the next screen click on the Job Log button:
This will display how much of the report has been completed so far (In this example it would have needed about another hour to complete. The runtime will always depend on the size of the system):
3) Show Output Spool
To show output of finished report, run transaction SE38 > /SDF/HDB_SIZING > Execute then tick Display a stored Sizing result:
The result is displayed:
This result can also be downloaded to a file. Enter %p as a transaction on the open screen of the result (or use the icon if available):
Choose the format of the file you wish to save the output to from the list then click the green tick:
On the next screen give the file a name and click Generate:
4) Update the Report on the System
If you wish to install or update the report to the latest version, SAP Note 1872170 contains the details for how this is done, highlighted in this section: