Symptom
- Analyzing steps take a long time to complete.
- The dbcc sqltext show Wordload Analyzer spid is running delete from repeated query.
dbcc sqltext output DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role. SQL Text: Executing procedure: p_analyzerepeatqrys_cap10000000000008 Subordinate SQL Text: Subordinate SQL Text: delete from t_repeatqrys_cap10000000000008 where rep_id in (select repeatid from #temptbl)
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE)
- Workload Analyzer
Product
SAP Adaptive Server Enterprise 16.0
Keywords
t_repeatqrys, slow , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.