DB collector and SQL statement history in DBACockpit

[former_member211576]

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)

[Sriram2009 · Accepted solution]

Hi Lee

Kindly refer the link

http://scn.sap.com/docs/DOC-1012

Regards

Ram

[former_member211576 · Accepted solution]

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.