SAP Knowledge Base Article - Preview

2078125 - SQL Anywhere 11, 12 or 16 performance on Linux is slow or degraded - Error: "Direct IO disabled for file because transparent hugepage support is enabled and madvise is not supported"

Symptom

  • When running a newer version of SQL Anywhere 12 or 16  on Linux, it's possible to see performance degradation versus a Windows installation.
  • On SQL Anywhere 11, SQL Anywhere 12 or SQL Anywhere 16, you see the following console message printed in the SQL Anywhere console log (-o output):

    Direct IO disabled for file '<filename>' because transparent hugepage support is enabled and madvise is not supported


Read more...

Environment

  • SQL Anywhere 11
    SQL Anywhere 12
    SQL Anywhere 16
  • Linux operating system, with kernel 2.6.38 or greater

Product

SAP SQL Anywhere 16.0 ; SAP SQL Anywhere, cloud edition 1.0 ; SAP Sybase SQL Anywhere 12.0 ; Sybase SQL Anywhere 11.0

Keywords

KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , 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.