- 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)
- SAP Adaptive Server Enterprise (ASE)
- Workload Analyzer
SAP Adaptive Server Enterprise 16.0
t_repeatqrys, slow , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.