SAP Knowledge Base Article - Preview

2516936 - Analyzing step take a long time to complete in Workload Analyzer

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.