SAP Knowledge Base Article - Preview

1990549 - Performance Issues with SQL Anywhere using ODBC on Windows 8 & 2012

Symptom

We do have identify an performance issue which occurs only on Windows 8 clients and Windows 2012 server machines. The same installation of our application and the SQL Anywhere ODBC client on machines with other Windows versions (e.g. Windows 7) shows no performance issue.

The performance difference is tremendous. A query that may take 3 seconds gets slow down to 2-3 minutes. We observed this performance issue using our own application as well as using Interactive SQL (dbisql).

We do have tested different versions of SQL Anywhere. The behavior was always the same.


Read more...

Environment

  • SAP SQL Anywhere
  • Windows 8
  • Windows 2012
  • Trend Micro OfficeScan 10.6 SP2

 

Product

SAP SQL Anywhere all versions ; SQL Anywhere all versions

Keywords

AntiVirus , 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.