Source: www.saphana.com, Posted by Lori Vanourek
What type of learning curve should you expect when it comes to administering SAP HANA? SAP HANA uses SQL. If you have experience working with modern administrative tools that leverage SQL, then you will be pleased to find that the learning curve is rather minimal. We witnessed this at SAP TechEd this year. We offered hands-on sessions for the SAP HANA studio. Participants were a bit tentative until they had a chance to log on to the SAP HANA studio. The attendees began experimenting based on their own SQL knowledge, and we noticed they started to be relaxed. They discovered that they were able to work well with the tooling, and they realized that they were already familiar with most of the SAP HANA admin concepts.
SAP HANA usually needs less administration than other databases. Typical duties for the admin include regular backups (database, bare-metal software and configuration backup), patches and updates (such as SPS Stack of appliance – usually on demand in case of problems or known issues), and monitoring (automated or manual). HANA behaves to an SAP admin in the same manner as every other database (i.e. it can be managed / monitored using the same tools as every other SAP/DB Scenario). Additionally we offer a lot of features in the HANA specific admin tool called the SAP HANA Studio.
SAP recognizes that different administrators have different tooling preferences. As such, there are multiple tooling choices available. The SAP HANA Studio is the main GUI tool for administering SAP HANA. For those who prefer to work with command lines, or strive for automation through OS scripts scheduled via cron, there are also command line admin tools available. SAP HANA is fully integrated with the SAP Solution Manager. This enables consistent integration of SAP HANA based systems into standardized IT service management and application lifecycle management processes that are common in existing non-SAP HANA based systems. For example, the technical monitoring of the database is embedded into the monitoring of the end-to-end scenario of the solution landscape and of the complete stack, thus enabling operation control from a technical perspective as well as from an end-user point of view. For support and troubleshooting, there is also integration with the SAP DBA Cockpit so that support employees can access information easily from an ABAP System. This integration allows access to best-practice processing from guided procedures and knowledge documents, and ensures that there is a segregation of duty between administering changes and troubleshooting.
This is a simple summary of what one can expect when administering SAP HANA. Check out the following videos for additional insights into the SAP HANA Studio:
Additional videos on http://www.saphana.com/community/resource