1 of 1 people found this helpful
I would start with ensuring that a proper database maintenance plan is in place - this should take care of keeping the Index fragmentation to a minimum and the statistics updated. Check KB67184 for a detailed discussion and steps.
Thanks for the quick response. I will forward that KB over to our database guy.