Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Excessive runtimes for a query

Hi.

I am running a particular query in PRD that takes over 120 seconds. The same query with the same selection critetia takes only less than 10 seconds in my QAS and DEV systems. The foll are the details BASED ON RSRT.

PRD:

Records - 4185

QDBTRANS - 360

Time - 119 seconds

QAS:

Records - 3912

QDBTRANS - 348

Time - 4 seconds

DEV:

Records - 3912

QDBTRANS - 354

Time - 2.2 seconds

Then I checked in ST03N and found that the %DB time is 99.83% in PRD and about 88% in DEV and QAS.

Do I conclude that there is some issue with our dB tuning? If so what do I do or ask my BASIS guys to do?

Cheers

Anand

Not what you were looking for? View more on this topic or Ask a question