We happen to draw system resources usage graph for 24 window, where in we noticed spike of IO write and specific point in time. to reason out we dig out more we moved to Tuple_mover_operations to see if any mergout happened for the particular timeframe, but no success .
My questions ?
1) Is there a way to know what cause this IO spike ?
2) Can we know, how much of IO do a perticular query take ? no system table gives this info @ query level.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.