Sybase ASE 15 System-wide performance issues

If the performance of Adaptive Server at the server level is not acceptable, and you are running 15.0.2 ESD #3 or later, you may shut down the Adaptive Server and restart it with trace flag 757 set in the RUN_server file. This is also effective when you experience unusually high levels of CPU usage without a clear cause, while running a multiengine Adaptive Server.

If the procedure cache is filled with idle cached plans, and the CPU usage is not high, run the following dbcc commands instead. However, using these commands is likely to have a lesser effect than restarting the server.

dbcc traceon(757)
go
dbcc proc_cache(free_unused)
go

Note : Do not use trace flag 757 in Adaptive Server versions earlier than 15.0.2 ESD #3.

Thanks Joshi for your information.

I would like to know, is it documneted trace flag by sybase ase 15.0?
As there are lot of trace flages and dbcc commands for ASE 12.5 which are not documneted by sybase.


Thanks.

Yes.It is also recommended by Sybase when Sybase Tech Support is contacted for a sybase performance issue.

Sybase Version being used : Adaptive Server Enterprise/15.0.3/EBF 16906 ESD#1 ONE-OFF/P/Sun_svr4/OS 5.8/ase1503/2681/32-bit/FBO

(01-29-2010 08:43 PM)Joshi Wrote:  Yes.It is also recommended by Sybase when Sybase Tech Support is contacted for a sybase performance issue.

Sybase Version being used : Adaptive Server Enterprise/15.0.3/EBF 16906 ESD#1 ONE-OFF/P/Sun_svr4/OS 5.8/ase1503/2681/32-bit/FBO