SAP Knowledge Base Article - Preview

2460703 - How to Debug Blocking in SQL Anywhere

Symptom

  • Performance is slow, and possibly hung/frozen
  • Transactions cannot be performed
  • SQL Statements take a long time
  • In Sybase Central, selecting the database and clicking on the 'Overview' tab reveals blocked connections to be a problem

    blocking edit.png


Read more...

Environment

  • Sybase SQL Anywhere 10.0
  • Sybase SQL Anywhere 11.0
  • SAP Sybase SQL Anywhere 12.0
  • SAP SQL Anywhere 16.0
  • SAP SQL Anywhere 17.0

Product

SAP SQL Anywhere 16.0 ; SAP SQL Anywhere 17.0 ; SAP Sybase SQL Anywhere 12.0 ; Sybase SQL Anywhere 10.0 ; Sybase SQL Anywhere 11.0

Keywords

Deadlock, blocked, freeze, hang, frozen, sql anyhwere , 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.