SAP Knowledge Base Article - Preview

1898755 - How to adjust the number of workers for the SQL Anywhere database engine/server

Symptom

  • Usually the default behavior of SQL Anywhere is good enough for most implementations to handle the client requests in an appropriate time.
  • However if experiencing longer execution times or even hanging, while the database server has to handle high number of requests, it is worth to look at the number of worker threads and see if a change will have a positive impact.


Read more...

Environment

SAP SQL Anywhere - all versions

Product

SAP SQL Anywhere all versions ; SQL Anywhere all versions

Keywords

SQL Anywhere, SQLA, SQLAny, database, db, workers, worker, thread, threads, request, requests, execute, execution, hang, hanging, hung, adjust, change, tuning, number , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , How To

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.