HANA SPS09 Features – Administration & Monitoring
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
ALTER USER <username> SET PARAMETER STATEMENT MEMORY LIMIT = <In GB>
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