Symptom
- 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. - 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 - 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.