Skip to Content

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

DB collector and SQL statement history in DBACockpit

Hi experts,

   I monitor our SAP system recently and I find there is probably an expensive SQL statement there.

I try to use SQL statement history but the physical reads data is not very high as I expected. What's wrong?

Is there any other DMVs and extended events I should check?

15,245 nuber of physical reads per second at 17:00 ~ 17:20.

Physical reads from 17:00 ~ 17:20 is just 1.1 millions which is not very high(ex: 60M)

replied

Hi SS,

   Thanks, I have already viewed all Leslie's presentations. I think she does not talk how to troubleshoot performance issue in detail.

   Anyway, I ask the same question in MSDN and I find I can Extended Events - Expensive Queries to trace.

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