Hi All,

can anyone give an idea about the best configuration of Sybase ASE, i know many factors that have impact on the performance like:

number of user connections
number of locks
number of indexes
number of open objects
number of open databases
data cache
procedure cache
character set

but can you provide me with the best configuration? and what are the parameters important to have a good performance.

thank you

I don't think there is an universal best configuration. Here are two links where you can start your searches:

http://www.isug.com/Sybase_FAQ/ASE/section1.5.html
http://infocenter.sybase.com/help/in...ases/title.htm