ASE Database forum - Sybase Problem Identifier

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Sybase Problem Identifier

Bharat Kumar M

2005-04-18, 3:24 am

Hi,

We are Using ASE 12.0 on Win 2000 Adv Server.

Some times our server performance decreases drastically
in peak hours.

It happens due to a query which dosent have a proper
indexing on particular tables. When we kill this process
then the server gets to its normal state.

My problem is there are so many queries running when this
problem occurs. Its getting very difficult to find which
process is making server slow.

I just want to know What is the proces which is taking
servers performance highly?

Sponsored Links