Problem of sybase 11.0.3 performace

[netwolf]

i have a IBM rs6000 with 8 prossesor, 2.5Gb mem, 165GB Hdisk and OS version 4.3.3 with sybase dbserver v11.0.3 and at midle of day , this machine is near to stop.
im new at job can someone give some ideias about this?
can this sybase version work properly with this HW, becouse if i check the resources of the machine they are only used at 20%.
the sybase dont use multy-processors?
thanks in advance

 

[qyllr]

hello,

i would begin with the sybase server logs... in unix, you can find the log files in the following subdir:

$SYBASE/install/

tail the SQL_SERVER_NAME.log file or vi the file. look for errors... this would at least indicate if the problem is in sybase or in the os level...

you can also check your tempdb using isql and gauge if there is a significant drop... during your peak hours...
here's the syntax:

sp_helpdb tempdb

-- you can write a shell script or batch job to monitor your server...or write a sp_thresholdaction stored procedure and create an emergency dump device... you can find this procedure in your sybase manual or in the sybase website...

you can check your query traffic by doing sp_who...

and finally check your stored procedures if it's taking some time to complete or if you have any memory leaks... this may take some time because you will have to do some performance tuning... you can also find this in the sybase manuals...

hope this helps,
q.

 

[Guest_imported]

Check how many online engines you are using with showserver in UNIX, if you only have one dataserver process you are not using the extra processors in the server, in Sybase issue: sp_configure "engines"

This will give you a couple of rows where "max online engines" and "min online engines" is the key.

change "max online engines" to something like 5-7 if you have 8 processors in your box and it is not running anything else that needs a lot of power.

Regards
Richard