Home
1. HANA Studio?
The SAP HANA Studio is both the central development environment and the main administration tool for SAP HANA.
2. Execute individual SQL statements with SAP HANA Studio?
You can execute individual SQL statements (e.g. taken from the SQL statement collection in SAP Note 1969700) using the SQL console of SAP HANA Studio.
It is possible to open multiple SQL consoles and run several SQL statements in parallel.
3. To stop an individual SQL statement started with SAP HANA Studio?
If you have started to execute a SQL statement with SAP HANA Studio and problems arise (e.g. high memory consumption), you can terminate this statement via the "Cancel operation" button in the Progress View (Windows -> Show View -> Progress).
4. How to SQL statements in the SQL editor be formatted automatically?
You can optimize the formatting of SQL statements using the keyboard combination CTRL - SHIFT - O, e.g.:
Original statement:
sqlOriginal.JPG
Formatted statement:
sqlFormatted.JPG
5. SAP HANA Studio delivered with version number 2.x as of SPS 09?
As of SAP HANA SPS 09 SAP HANA Studio is delivered with version number 2.x while the SAP HANA software still has version number 1.x. This change is caused by the intension of SAP to decouple the versions of SAP HANA Studio and the SAP HANA database. It doesn't impact the compatibility, so you can use SAP HANA Studio version 2.x in combination with SAP HANA databases 1.x.
6. How to resolve problems displaying the load graph?
The load graph ("Administration" -> "Performance" -> "Load") is a useful tool to check for historic database figures like CPU consumption, memory consumption or SQL throughput, but there can be situations where it's not working properly or the performance is slow. In this case you can access the underlying information differently (e.g. via DBACOCKPIT or SQL) or adjust the memory limit for SAP HANA Studio. See SAP Note 2222110 ("What can I do if displaying the SAP HANA Studio load graph doesn't work?") for more information.
7. What can we do if other memory-intensive activities in SAP HANA Studio don't work?
If other activities in SAP HANA Studio with a high memory requirement like a large PlanViz evaluation fail, the adjustment of the SAP HANA Studio memory configuration as described in SAP Note 2159510 can help.
8. What can we do if opening the overview tab in the administration console takes a long time?
Opening the overview tab in the administration console often suffers from a high amount of SAP HANA alerts. If it takes many seconds or even minutes to open the overview tab, you can check according to SAP Note 2147247 if the number of alerts in table STATISTICS_ALERTS_BASE is too high and perform a cleanup.
9. Which SAP HANA Studio version should be used for a certain SAP HANA database?
SAP HANA Studio is downward compatible, but not upward compatible. This means that you should always use at least the SAP HANA Studio Revision that was delivered together with the SAP HANA server software in order to perform monitoring and development tasks.
In some cases a SAP HANA Studio version higher than the SAP HANA server version can also result in errors, see e.g. SAP Note 2337716. To be on the save side, you should use identical versions for SAP HANA Studio and SAP HANA whenever possible.
10. How does the SAP HANA Studio version correspond to the SAP HANA Revisions?
The SAP HANA Studio version and the SAP HANA SPS level correspond in the following way:
1. HANA Studio?
The SAP HANA Studio is both the central development environment and the main administration tool for SAP HANA.
2. Execute individual SQL statements with SAP HANA Studio?
You can execute individual SQL statements (e.g. taken from the SQL statement collection in SAP Note 1969700) using the SQL console of SAP HANA Studio.
It is possible to open multiple SQL consoles and run several SQL statements in parallel.
3. To stop an individual SQL statement started with SAP HANA Studio?
If you have started to execute a SQL statement with SAP HANA Studio and problems arise (e.g. high memory consumption), you can terminate this statement via the "Cancel operation" button in the Progress View (Windows -> Show View -> Progress).
4. How to SQL statements in the SQL editor be formatted automatically?
You can optimize the formatting of SQL statements using the keyboard combination CTRL - SHIFT - O, e.g.:
Original statement:
sqlOriginal.JPG
Formatted statement:
sqlFormatted.JPG
5. SAP HANA Studio delivered with version number 2.x as of SPS 09?
As of SAP HANA SPS 09 SAP HANA Studio is delivered with version number 2.x while the SAP HANA software still has version number 1.x. This change is caused by the intension of SAP to decouple the versions of SAP HANA Studio and the SAP HANA database. It doesn't impact the compatibility, so you can use SAP HANA Studio version 2.x in combination with SAP HANA databases 1.x.
6. How to resolve problems displaying the load graph?
The load graph ("Administration" -> "Performance" -> "Load") is a useful tool to check for historic database figures like CPU consumption, memory consumption or SQL throughput, but there can be situations where it's not working properly or the performance is slow. In this case you can access the underlying information differently (e.g. via DBACOCKPIT or SQL) or adjust the memory limit for SAP HANA Studio. See SAP Note 2222110 ("What can I do if displaying the SAP HANA Studio load graph doesn't work?") for more information.
7. What can we do if other memory-intensive activities in SAP HANA Studio don't work?
If other activities in SAP HANA Studio with a high memory requirement like a large PlanViz evaluation fail, the adjustment of the SAP HANA Studio memory configuration as described in SAP Note 2159510 can help.
8. What can we do if opening the overview tab in the administration console takes a long time?
Opening the overview tab in the administration console often suffers from a high amount of SAP HANA alerts. If it takes many seconds or even minutes to open the overview tab, you can check according to SAP Note 2147247 if the number of alerts in table STATISTICS_ALERTS_BASE is too high and perform a cleanup.
9. Which SAP HANA Studio version should be used for a certain SAP HANA database?
SAP HANA Studio is downward compatible, but not upward compatible. This means that you should always use at least the SAP HANA Studio Revision that was delivered together with the SAP HANA server software in order to perform monitoring and development tasks.
In some cases a SAP HANA Studio version higher than the SAP HANA server version can also result in errors, see e.g. SAP Note 2337716. To be on the save side, you should use identical versions for SAP HANA Studio and SAP HANA whenever possible.
10. How does the SAP HANA Studio version correspond to the SAP HANA Revisions?
The SAP HANA Studio version and the SAP HANA SPS level correspond in the following way:
SAP HANA Studio | SAP HANA |
2.0.x | SPS 09 |
2.1.x | SPS 10 |
2.2.x | SPS 11 |
2.3.x | SPS 12 |