3393508 - ASE procedure cache full with error 701, server is inaccessible and does not accept any new connection - SAP ASE

• ASE procedure cache is full with error 701
• Server is inaccessible and did not accept any new connection
• Expecting that ASE should not end up being inresponsive running into such a scenario even if procedure cache is fully exhausted.
• sp_mem shows lots of active prepared_stmt_count and prepared_stmt_memusage
  
  For example:
  1> sp_mem
  spid   memory_usage prepared_stmt_count prepared_stmt_memusage
  ------ ------------ ------------------- ----------------------
        2         2099                6000                    858
       19            4                NULL                   NULL
   
  (2 rows affected)
  (return status = 0)
  In this results, SPID 2 have total 6000 active descriptor and required total 2099(the unit is 2K) memory from procedure cache
   
  
    

SAP Adaptive Server Enterprise (ASE) 16.0 or above

CR828572, CR#828572, 828572, procedure cache full, error 701, MEMC_BATCH_PARAM_2, allocator 299, 299, allocator  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To