Skip to Content
Author's profile photo Vivek Singh Bhoj

HANA SPS09 Features – Administration & Monitoring

Hi Everyone,

I have just been checking out new features in HANA SPS09 and wanted to share with you guys new administration and monitoring features:

One of the things that I noted first after HANA upgrade is that now Web dispatcher has its own service and its own ini config file:



As you can see from above screenshot, web dispatcher has its own ini file and also HANA SPS09 comes with lot of new config files like multidb.ini related to tenant database.

Web dispatcher even has its own admin page for further monitoring:



Another thing that we can do now is we can control HANA memory consumption by setting a statement memory limit for  a particular user.

This can be pretty handy in many cases. To set a statement memory limit for a User, write the below statement


We can also control HANA Parallelism now by changing below parameters in indexserver.ini file:

  • SqlExecutor: sql_executors = <min number of threads that can be used>
  • SqlExecutor: max_sql_executors = <max number of threads that can be used>
  • JobExecutor: max_concurrency = <max number of threads that can be used>

Be careful while selecting maximum threads for Job Executor as it can affect other System tasks like Memory Garbage Collection, table update, backup etc

HANA SPS09 comes with SAP HANA Cockpit which is a web based application for HANA administration and monitoring

To open the HANA Cockpit, enter the below URL


To view the Cockpit, you need any of the below two roles:



Once you open the link in the browser, you will get the below Screen:


As you can see from the above screenshot, it consists of a lot of tiles that provide relevant information and few of these tiles are even clickable.

Upto SPS08, we could see Memory Overview and Resource Utilization in HANA Studio but with SPS09, those options are gone from HANA Studio and only HANA Dashboard is available though it can be directly opened from HANA Studio.

As you can see all tiles are self explanatory: like first tile is showing information pertaining to Database status. All tiles are clickable except for Query Running Jobs, Active Sessions, General Information and  Query Load and you can get detailed information. Like if you want to go to Memory Overview as shown in HANA SPS08, just click on Memory Usage tile and similarly for Resource Utilization just click on CPU Usage tile.

You can even create a Customized Dashboard for yourself,

To create a new dashboard, click on 3 lines on left side of the page and then below page will be available.


As you can see from above screenshot, by default SAP HANA Administration and Monitoring Group already exists. To create a new group, click on New Group and enter a name. Let’s give a name SP9TESTGROUP.


Now we will add tiles to the dashboard as shown below.


Once we add all the tiles we need in the dashboard, we can see our own Customized Dashboard.


By default, lot of tiles are available – like tiles for XS Jobs, SMTP Configuration, Trust Configuration and if you have installed Lumira Server on your HANA System then even Lumira tiles are available.

HANA SPS09 also has SAP DB Control Center which is also a web based application for administration and monitoring of landscape of SAP databases(has to be installed separately by downloading the Delivery Unit from SAP Marketplace)

And If you have installed SAP Database Control Center in your HANA System then its tiles are also visible as shown below.


If you have installed SAP DB CC, then you can open the below URL to check it:


You need role sap.hana.dbcc.roles::DBCCAdmin to setup and change configuration and role sap.hana.dbcc.roles::DBCCUser to display DB CC.

HANA Cockpit is a very useful tool as we can know the status of HANA from a single glance and if needed we can even drill down to find more information.

Controlling Memory for a particular user and controlling HANA parallelism can be very handy



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Denys van Kempen
      Denys van Kempen

      For those interested, I uploaded a video on this topic to the Academy:

      SAP HANA Academy - SAP HANA Administration: SAP HANA Cockpit - Monitoring [SPS 09] - YouTube

      Author's profile photo Oliver Goetz
      Oliver Goetz

      Hi Vivek,

      that's very helpful, thanks for that post. However, there is a small error in one of the role names: it's sap.hana.admin.roles::Administrator, not sap.hana.admin.roles::Administration, at least on a Rev.94 system (maybe it was changed after you wrote the article...)

      Best regards,


      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Thanks for pointing it out - it's a typo mistake

      Author's profile photo Former Member
      Former Member

      Thank you for sharing.  Very good information.  One thing I noticed is that I used to have 2 options under "Configuration and Monitoring".  Dashboard and SAP HANA cockpit.  Now the Dashboard option is gone.  Anyone else experience this?


      Dae Jin

      Author's profile photo Krishna Tangudu
      Krishna Tangudu

      Can we add custom queries and also add them to the dashboard? is it possible?


      Krishna Tangudu