Honestly, there are two ways to deal with this.
First, is review all database code yourself and make sure it's properly tuned, before it goes into production.
Second, is monitor the database performance at a code level and fix things before anybody else notices they've gone wrong.
You can (should) do both.
Confio Ignite is really helpful for the second.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon