Skip to Content
Technical Articles

The SAP HANA Hot 100 | FAQ and How To

Over the years, SAP Support has released to customer (RTC) a long list of knowledge base articles (KBA) in frequently asked question (FAQ) and How To format.

Below a list of the most frequently updated articles.

For information about all the acronyms. terms and terminology, see

Most of the notes are technical and assume a solid foundation. For those that are looking for a more gentle approach, see

Questions? Please post as comment.

Useful? Give us a like and share on social media.

Thanks!

/wp-content/uploads/2016/02/sapnwabline_885687.png

FAQ

Hot 100

The list below is an update and extension of KBA: 2872774 – Bookmark of Frequently Asked Questions for SAP HANA

Wikipedia: The purpose of an FAQ is generally to provide information on frequent questions or concerns: the format is a useful means of organizing information, and text consisting of questions and their answers may thus be called an FAQ regardless of whether the questions are actually frequently asked.
Number Title
1642148 FAQ: SAP HANA Database Backup & Recovery
1755396 Released disaster tolerance solutions for SAP HANA with disk replication
1758890 SAP HANA: Information needed by Product/Development Support
1813020 How to generate a runtime dump on SAP HANA
1892593 Preparing Support Services for SAP HANA Scenarios
1999880 FAQ: SAP HANA System Replication
1999930 FAQ: SAP HANA I/O Analysis
1999997 FAQ: SAP HANA Memory
1999998 FAQ: SAP HANA Lock Analysis
2000000 FAQ: SAP HANA Performance Optimization
2000003 FAQ: SAP HANA
2014562 FAQ: SAP HANA LT Replication Server (SLT)
2044468 FAQ: SAP HANA Partitioning
2057595 FAQ: SAP HANA High Availability
2073112 FAQ: SAP HANA Studio
2079372 SAP HANA – Statement Routing
2082286 FAQ: SAP HANA Graph
2091095 SAP HANA Smart Data Integration and SAP HANA Smart Data Quality
2100009 FAQ: SAP HANA Savepoints
2101244 FAQ: SAP HANA Multitenant Database Containers (MDC)
2104291 FAQ – SAP HANA multitenant database containers
2112604 FAQ: SAP HANA Compression
2114710 FAQ: SAP HANA Threads and Thread Samples
2115815 FAQ: SAP HANA Database Patches and Upgrades
2116157 FAQ: SAP HANA Consistency Checks and Corruptions
2124112 FAQ: SAP HANA Parsing
2127458 FAQ: SAP HANA Loads and Unloads
2142945 FAQ: SAP HANA Hints
2143736 FAQ: SAP HANA Table Distribution for BW
2147247 FAQ: SAP HANA Statistics Server
2159014 FAQ: SAP HANA Security
2160391 FAQ: SAP HANA Indexes
2165547 FAQ: SAP HANA Database Backup & Recovery in an SAP HANA System Replication Landscape
2169283 FAQ: SAP HANA Garbage Collection
2180119 FAQ: SAP HANA Smart Data Access
2180165 FAQ: SAP HANA Expensive Statements Trace
2186744 FAQ: SAP HANA Parameters
2213725 How-To: Troubleshooting of -10709 errors
2220627 FAQ: SAP HANA LOBs
2222110 FAQ: SAP HANA Load History
2222200 FAQ: SAP HANA Network
2222220 FAQ: SAP HANA DBACOCKPIT
2222277 FAQ: SAP HANA Column Store and Row Store
2250144 FAQ: SAP HANA Secure User Store
2332170 How-To: Analyzing SAP HANA composite OOM dump
2336344 FAQ: SAP HANA Static Result Cache
2340450 FAQ: SAP HANA Table Replication
2362820 SAP HANA Performance Management Tools
2366291 FAQ: SAP HANA Executed Statements Trace
2375176 SAP HANA Revisions and SAP HANA Studio Versions
2380176 FAQ: SAP HANA Database Trace
2384500 How to Convert Row Store to Column Store and Vice Versa
2393013 FAQ: SAP HANA Clients
2399993 FAQ: SAP HANA Fast Data Access (FDA)
2400005 FAQ: SAP HANA Persistence
2400006 FAQ: SAP HANA Statement Hints
2400022 FAQ: SAP HANA Smart Data Integration (SDI)
2407186 How-To Guides & Whitepapers For SAP HANA High Availability
2416490 FAQ: SAP HANA Data Aging in SAP S/4HANA
2444090 FAQ: SAP HANA Backup Encryption
2469025 How-To: Upgrading to SAP HANA 2.0
2470289 FAQ: SAP HANA Non-Uniform Memory Access (NUMA)
2477204 FAQ: SAP HANA Services and Ports
2493172 SAP HANA Hardware and Cloud Measurement Tools
2502256 FAQ: SAP HANA Caches
2506811 FAQ: SAP HANA Dynamic Result Cache
2520774 FAQ: SAP HANA Performance Trace
2535951 FAQ: SAP HANA Users and Schemas
2554012 FAQ: SAP HANA Big Endian to Little Endian Migration for IBM Power
2593571 FAQ: SAP HANA Integrated liveCache
2600076 FAQ: SAP HANA Inverted Individual Indexes
2632231 SAP HANA and Non-Uniform Memory Access (NUMA)
2639193 SAP HANA SQL Plan Stability
2643763 FAQ – SAP HANA Extension Node for SAP HANA native applications
2653155 Using backup and recovery to upgrade HANA 1.0 to HANA  2.0
2669621 FAQ: SAP HANA Capture and Replay
2670064 FAQ: SAP HANA Multi-Dimensional Services (MDS)
2688382 SAP HANA Smart Data Integration Memory Sizing Guideline
2700084 FAQ: SAP  HANA Persistent Memory
2728331 SAP HANA Client Interfaces Redistributable Files
2786237 Sizing SAP HANA with Persistent Memory
2799997 FAQ: SAP HANA Native Storage Extension (NSE)
2799998 FAQ: SAP HANA Plan Stability
2800006 FAQ: SAP HANA Cockpit
2800007 FAQ: SAP HANA Temporary Tables
2800008 FAQ: SAP HANA Fulltext Indexes
2800020 FAQ: SAP HANA Triggers
2800028 FAQ: SAP HANA Optimizer Statistics
2800055 FAQ: SAP HANA Kernel Sentinel
2937069 SAP HANA Cloud Migration FAQ
2941449 SAP HANA Client 2.0 Releases
2942189 SAP HANA Spark Controller – Troubleshooting Guide
2951859 Understanding HANA “Issue number” Referenced in SAP Notes
2958224 SAP HANA Revision Release Details
2975780 FAQ: SAP HANA LDAP Based Authentication and Authorization
2983742 SAP HANA Cloud Availability of Services per Data Center
2993439 Statement on SAP HANA Studio and SAP HANA Cloud
3027477 General information about auditing activity in SAP HANA
3049706 FAQ: SAP HANA Hardware and Cloud Measurement Tools (HCMT)

/wp-content/uploads/2016/02/sapnwabline_885687.png

Expert Search

My SAP Notes & KBAs

The list above is a selection of the most relevant and frequently updated articles. To view them all or to perform your own Expert Search, navigate to the Knowledge Base section, select Expert Search, and filter on

  • Search Term: FAQ
  • Components: HAN
  • Category: FAQ, How TO

To get started, you can this as template

Note that the categorisation is not rigid: KBAs with FAQ in the title might be categorised as How To and there are many articles categorised as FAQ but without FAQ in the title.

Released On indicates the last update. Version the number of updates. To sort by date, sort by Number which lists the most recent KBA first.

Get Notified

To get notified when new FAQ KBAs are published, you can save your search and select for updates, as explained in

/wp-content/uploads/2016/02/sapnwabline_885687.png

Knowledge Base Articles

FAQ and How To

SAP Support maintains an extensive knowledge base full of notes (articles) categorised as FAQ and How To. These articles provide a list with questions with answers. How often the questions have actually been asked is not disclosed but we can acknowledge that some notes are at least frequently updated.

Exhibit 1

The FAQ on SAP HANA memory, for example, approaches (and no doubt soon surpasses) version 1000. Printed as PDF, the article counts 96 pages, references 206 other articles and is reference by 130.

From the SAP ONE Support Launchpad, you can mark the note as favourite and get notified about updates. You can also print the note (as PDF) or share. Show Changes highlights what has changed since the previous version.

Exhibit 2

Fortunately not all notes resemble PhD dissertations. We also find more concise KBAs just pointing to the documentation and/or best practice guide with references to relevant notes and articles.

S-User ID

To access the SAP ONE Support Launchpad you need an S-User ID (SAP Support account). How to get one is explained here

Without an account, we can only access the preview article made available to facilitate Google search.

/wp-content/uploads/2016/02/sapnwabline_885687.png

Share and Connect

Questions? Please post as comment.

Useful? Give us a like and share on social media.

Thanks!

If you would like to receive updates, connect with me on

For the author page of SAP PRESS, visit

/wp-content/uploads/2016/02/sapnwabline_885687.png

3 Comments
You must be Logged on to comment or reply to a post.