SAP Knowledge Base Article - Preview

3634332 - Log Switch Wait Count Ratio Alert in HANA caused by Leftover Value

Symptom

  • You are periodically getting Log Switch Wait Count Ratio alert in HANA studio or in solution manager system for a HANA system.
  • SQL: "HANA_Configuration_MiniChecks" (SAP Note 1969700, SAP Note 1999993) returns a potentially critical issue (C = 'X') for "M0340: Log switch wait count ratio (%)"
  • No explicit indication of the ongoing I/O issue on the HANA System as per SAP Note 1999930 "4. Which indications exist that the SAP HANA database suffers from I/O accesses? except for Log Switch Wait Count Ratio Alert"
  • Constant value of SWITCH_WAIT_COUNT parameter retrieved via TEL_LOG_BUFFERS View observed for all of the snapshots since last HANA System restart


Read more...

Environment

  • SAP HANA Platform Edition 1.0
  • SAP HANA Platform Edition 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

Log Switch Count Ratio; log buffer size; log buffer count; log_buffer_size_kb; log_buffer_count; SWITCH_WAIT_COUNT; M0340 , KBA , HAN-DB-MON , SAP HANA Monitoring , HAN-DB-PER , SAP HANA Database Persistence , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.