one of the first things to look for in database performance tuning
is the existence (or nonexistence) of indexes (for SELECTs, that is).
they are perhaps the "#1 most used" optimization for relational
databases.
if you can, i would suggest first tracking down the query text itself.
sybase a
>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 effici
[cc list cut]
On Thu, 18 Sep 2003, 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 progr
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 stateme