DB collector and SQL statement history in DBACockpit
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)