Sybase - Slow response, possible network problem?
Posted on 2006-03-30
My customer has been complaining of slow response time. Looking at the sysmon report, we noticed that when Engine CPU Busy is high (80-99), the context switch network packet sent count is also high (7000-11000, 65-84%). On the times when engine CPU busy is low (< 50%), the network packet sent count is also lower (< 5000, ). The cache searches misses is mostly at < 1%.
There is a similar question posted earlier (Q_21722680.html). But I want to make sure that the solution recommended there is also applicable to my problem.
tcp no delay (from 1 to 0) - is there any memory increase with this change? Is it safe to change it now and just wait for the ASE recycle for it to take effect?
increase default packet size - currently, it is set to 512. When you say, the client has to be changed also, where is that? At ODBC? Do I also have to increase the 'additional network memory' ? It is currently set to 100352 bytes.
Lastly, is there anything else at sysmon that I can check for this slow response?
BTW, this is for ASE 12.5.3, Windows 2000 Server.