What are the recommended values for the following parameters when configuring a non-sa user for spotlight for Sybase:
deadlock pipe max messages.
errorlog pipe max message.
statement pipe max messages.
N/A
Here are the average figures:
deadlock pipe max messages = 1000
errorlog pipe max message = 1000
statement pipe max messages = 5000
Note that the above values are the minimal that we find to cover most situations. The value most useful for each server varies with number of users on the server weighed against memory overhead. i.e. if you set statement pipe max messages to 5000 and the server processes 6000 statements between the poll cycles of Spotlight then statements 1-1000 will age out before we could retrieve them (Sybase will age out the older statements when new one comes in to keep the total at or below the 'max messages' value). Each one of those values is like sizing a bucket, the larger the bucket the more it can hold. Once you fill it to the top and add more water - new water comes in and then old water is forced over the side.
N/A
