Find Offensive SQL

Supporting a Database really boils down to one of two things: Proactive and Reactive.
You could wait until something goes wrong and fix it.
Or you could adopt some measure to prevent bad things from happening to the DB.

The number one cause of degrading performance on DB is offensive SQL. That is Code written to run against the DB, but taking ages to complete and release
ressources for other process to use.
Read the Full article: