Hi Alan,

Thanks for your reply. i will test these scripts.

Moreover, i would also like to know how to determine or capture this high IO/CPU queries if they run again. so i will know how these statements occur and its frequency in specified timeframe.

Is there any method to do so?

Thanks,

Jack