I have been assigned a project for performance optimization
of a Swiss ASA 7 database that is being used by Dolphin
application.
How do I optimize performance as whenever I try to execute
any system stored procedures using Interactive SQL to enable
RequestLogging and Procedure profiling using call
sa_server_option ('Procedure_profiling','ON') and call
sa_server_option ('RequestLogging','ALL'), I get an error
"Error at line 1 Invalid Option 'Procedure_profiling'- no
PUBLIC settings exist.

There was a sa_server_option( ) procedure in V7
but thes settings were these

The options that can be reset are as follows:
Option name Values Default
========= ===== =====
Disable_connections ON or OFF OFF
Liveness_timeout integer, in seconds 120
Quitting_time valid date and time none
Remember_last_statement OFF
ON or OFF
Request_level_log_file Filename
Request_level_logging ALL, SQL, NONE
NONE

so you can see the names have changed since V7.

You can also see Procedure_profiling was not documented
and will not be present; having only been introduced in
Version 8.0 and enhanced in 8.0.2.



<deepali.sahni (AT) ebookers (DOT) com> wrote

Hi Nick.. Thank You so much for your reply...
I am relatively new to Sybase, so I was working out options
for performance tuning.. How can then I optimize the
performance of my database server as upgrade cannot be done
because the application would not be compatible with the new
version.

There was a sa_server_option( ) procedure in V7