Did you ever monitor the long running queries. I know for big boards, adding some extra indexes can just make the difference.
I would love to give you an easy solution, but there is not a single way a problem like this can be resolved, it would take some serious testing and investigating to find where you can still gain some performance. Maybe you just need a litle relieve of the server to avoid those corruptions, maybe it will just not work with the hardware. Very difficult to give a generic answer.
|