SAP Knowledge Base Article - Preview

3384061 - Stored Procedure performance is decreasing, until finally it stops returning at all - SAP ASE

Symptom

  • There is a stored procedure that has been is use for some time.  
  • Over the past few months it is taking 30 minutes to return.
  • Now, the stored procedure is not returning after hours of running.
  • The data is changing all the time (more data is added daily).


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Keywords


stored procedure performance issue, SAP ASE stored procedure, query optimization, stored procedure not returning, stored procedure slow performance, stored procedure troubleshooting, database performance issue, query execution time, stored procedure optimization, database query issue, stored procedure not responding, stored procedure execution, database query performance , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.