naga.rohitkumar (11/18/2012)
HI jack & jeff1) IT is in the batch format from bank [client is banking domain]
2) yes update statistics are enabled and runs at morning 2AM]
3)when ever this issue comes i take performance -top queries by average IO
4) and ivl ask application team for proper tuning.
That's nice but you haven't answered most of my questions. I can't make a recommendation unless I have answers to the questions I posted.
--Jeff Moden
Change is inevitable... Change for the better is not.