Hello Jim,

From your suggestion I can tell that not only you have extensive experience dealing with databases but also with people. The windows for maintenance is quite wide, from 6:00PM to 5:00AM, the largest database is only 55 GIGs, and the whole server has only 3 databases totalling 70 GIGs, quite small to today standard, we have no replication, no log shipping, no cluster, no mirroring. I ran index maintenance jobs on a test server, the only thing I did not show to them is how much performance gain after index rebuild jobs. You're are correct by saying that index is not the only cause of slowness but that is another issue I am also facing.

Thank you, Jim, for your suggestion.

Hai