2032645 - Server no longer accepting new connections -SAP ASE

• The server stopped accepting connections appears to have hung.
• No processes are moving.
• A manual memdump was collected at the time of this behavior.
• In the memdump we see 3 SPIDs, one for auditing that is blocking the other processes.
• Auditing was unable to truncate sysaudits_01 table due to being blocked by select query.

SAP Adaptive Server Enterprise (ASE) 15.0.2 

server hung, audit table blocked, auditing deadlock, SAP ASE connection issue, auditing process blocking, select query lock, audit table truncation issue, audit table design change, audit table lock, audit table segmentation, audit table archiving, audit table resolution , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem