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! |
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) |
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
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.
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
- LinkedIn > linkedin.com/in/dvankempen
- Twitter > @dvankempen
For the author page of SAP PRESS, visit
Over the years, for the SAP HANA Academy, SAP’s Partner Innovation Lab, and à titre personnel, I have written a little over 300 posts here for the SAP Community. Some articles only reached a few readers. Others attracted quite a few more. For your reading pleasure and convenience, here is a curated list of posts which somehow managed to pass the 10k-view mile stone and, as sign of current interest, still tickle the counters each month. |
Thanks Denys
Really helpful!!Thank you..
Very Useful!! better than Braindumps, I would say 🙂
Thank you