This page is to explain troubleshooting steps for various issues which you may encounter with the statistics server on SAP HANA
There are two versions of the statistics server. One exists as a standalone process, visible in the HANA studio. The other, possible after revision 74 of SAP HANA, is the embedded statistics server.
This is the original statistics service which is still delivered as active with HANA SPS7, SPS8 and SPS9. You must manually migrate to the new embedded statistics service.
The embedded statistics service is only available from revision 74 onwards.
Embedded Statistics Service
This version consumes less memory than the older, standalone statistics server process. It is available from revision 74 onwards. See the documents and notes below for guidance on migrating from the standalone statistics service to the embedded statistics service.
See the following blog explaining the migration process:
See section titled "The Statistics Service" of the SAP HANA Administration Guide
Related SAP Notes/KBAs
SAP Guided answer: Troubleshooting Embedded Statistics Server Migration
SAP Note 1929538 - HANA Statistics Server - Out of Memory
SAP Note 2019148 - Statistics server cannot be started due to LOG FULL event reported
SAP Note 1917938 - Migration of the statistics server for Revision 74 or higher
SAP Note 2092033 - Embedded Statistics Service Migration Guide
SAP Note 2154442 - Delete spare volume files of the statisticsserver after its migration
SAP Note 2006652 - SAP HANA Statistics Server - Switch to Embedded Statistics Service fails
SAP Note 2036630 - Statisticsserver migration fails with 'error installing' / 'SQL error 129'
SAP Note 2139017 - Embedded Statistics Server migration failed while creating STARTUPMIGRATIONSTEPIMPLEMENTOR procedure
SAP Note 2130884 - Statisticserver is continuously crashing due to an Orphaned Timestamp
SAP Note 1950221- SAP HANA DB Reinitializing the statisticserver
SAP Note 1859700 - System Over view shows Statistics Server has been disabled
SAP Note 2111691 - Statistics server crash dump after upgrade to Revision 84 of HANA
SAP Note 2113564 - Error reading data from table STATISTICSSERVER.STAT_VIEW_COLUMN_TABLES_PART_SIZE
SAP Note 2154844 - HANA Alerts keep getting disabled after switching to the embedded statisticserver
SAP Note 2170779- SAP HANA DB: Big statistics server table leads to performance impact on the system
SAP Note 2215093 - After upgrading to Rev 97 the statisticsServer does not work