Supote Leelasupphakorn wrote:
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?
You're hitting up against, what I feel is one of the most common
and most difficult to solve problems out there.
The best solution is to fix the SQL statements. Unfortunately,
it's quite possible that you won't be able to fix the application
that's causing the problem, becuase it's closed-source and
written by someone else. At that point, you're up against the
frustrating chore of convincing the application designer to
fix their lousy code, which is often impossible.
In the end, it seems that most people end up buying faster,
more expensive hardware to make up for lousy application design.
It's a damn shame, but that's what seems to happen a lot.
--
Bill Moran
Potential Technologies
http://www.potentialtech.com
_______________________________________________
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
