Lot of reviews available on the net about this topic.

The first thing DBA need to do is to identify the changes made when the application was running good and is bad. From there it is general trouble shooting process which differs case to case.

Thanks,