How DBA solved overload problem ?

[Supote Leelasupphakorn]

To all,

   As a newly DBA, I really don't know how I deal with
this problem. My problem is not so long ago, my database
server seem to overloaded. It take me a time to find
the cause of problem. I realize that some program don't
queried wiht inappropriated SQL statement. I mean they're
not efficient one.

AS DBA how do you solved this problem?

Thanks in advance,

________________________________________________________________________
Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk