SAP Knowledge Base Article - Preview

3228587 - sp_dropuser is slow after upgrade from SP03 PL10 to SP04 PL02 - SAP ASE 16.0

Symptom

  1. SAP ASE 16.0 SP03 PL10 has been upgraded to SAP ASE 16.0 SP04 PL02.
    The installmaster script was executed as part of the upgrade.
  2. There was an IBM hardware flash copy of a database to a reporting side.  
    sp_dropuser was run on all users (~10,000) in the reporting side
  3. Then added in the extracted users from before the flash process. 
    • In SP03 PL10, dropping all users would take 15-20 minutes to run
    • In SP04 PL02, it takes 50-60 minutes to run.
    • Is this expected behavior?  
    • Apparently, there is a difference in the sp_dropuser code between SP03 and SP04


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP04 PL02

Product

SAP Adaptive Server Enterprise 16.0

Keywords

performance, speed, fast, installmaster, query, plan, cache, cached, procedure , 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.