SAP Knowledge Base Article - Preview

2324814 - Process consuming procedure cache unable to kill spids - SAP ASE

Symptom

  • Ran into a situation where 2 spids were using 8GB of memory each were not able to be killed.
  • Caused problems for the others processes trying to use procedure cache.
  • sp_who show these processes in "Awaiting Command". These processes could also holding locks and blocked other processes.
  • monProcesswaits show wait event 280 "wait for access to a memory manager semaphore".

 


Read more...

Environment

SAP Adaptive Server Enterprise 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

DYNAMIC_PREPARE , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.