3752594 - Poor performance and high CPU utilization or hanging shared memory dump - SAP ASE

• Upgrade ASE to SP04 PL07, SP04 PL07 HF1 or SP04 PL08.
• Or upgrade ASE to 16.1 SP00 PL01 or SP00 PL02.
• Performance has degraded since the upgrade.
• CPU utilization has increased since the upgrade.
• In rare occasions, a shared memory dump will hang, and the server is non-responsive.
• dbcc stacktrace for a slow performing spid will look similar to this:
  

  b_tget_gtod

  now

  mda_fdp_write_stmt_stats

  s_execute

• Stacktrace from pstack for a hanging shared memory dump will look similar to this:
  __lll_lock_wait_private
  tzset
  b_tz_linux
  b_tget_gtod
  ucerrmsghdr
  kcerrlog
  sm_diag_printf
  shm.memdump
  shm_memdump_server
  csmd_dump_condition

• SAP Adaptive Server Enterprise (ASE) 16.0 SP04 PL07 through SP04 PL08
• SAP Adaptive Server Enterprise (ASE) 16.1 SP00 PL01 and above

CR831684, CR#831684, 831684, slow after upgrade, high cpu, slow performance , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem