I have updated the sats with full scan but still i didn't find much more improvement on the performance.

Thanks for your quick suggestion.

We did all the changes in old h/w only.As you suggested we rebuilt all the indexes and tested the application but still it is running with...