Skip to Content
0
Nov 27, 2013 at 07:09 AM

DB collector and SQL statement history in DBACockpit

167 Views

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)

Attachments

sql1.png (50.6 kB)
sql2.png (67.8 kB)