OK, so your DB started performing poorly after it ran for awhile....that's a pretty broad problem, but here's a few things you might try: 1) I fully agree with Bob's post - if you want it to work correctly, get someone who knows what they're doing to set things up properly. (Though I understand that doesn't fix your problem today.) 2) Check for any tables that have grown excessively large. It's possible that you have some large logging / history tables and such that can easily be archived and deleted from the working tables. 3) If there's any way to narrow your problem down to a few areas (perhaps the top 2 or 3 stored procedures you're having trouble with?) you can look at modifying indexes specifically to help with those queries - just be sure you don't replace one problem with another. 4) You could always throw more hardware at it for a temporary fix... If you have any more specifics about what the problem is, perhaps we could better help. -Dave