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
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
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
[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 program
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