sybase系统的一个调优案例

alanzhu

呵呵 看了关于 T757的介绍 觉得基本功课还是没做足 但谁能想到呢?
System-wide performance issues
If the performance of Adaptive Server at the server level is not acceptable, and you are running 15.0.2 ESD #3 or later, you may shut down the Adaptive Server and restart it with trace flag 757 set in the RUN_server file. This is also effective when you experience unusually high levels of CPU usage without a clear cause, while running a multiengine Adaptive Server.

If the procedure cache is filled with idle cached plans, and the CPU usage is not high, run the following dbcc commands instead. However, using these commands is likely to have a lesser effect than restarting the server.

dbcc traceon(757)
go
dbcc proc_cache(free_unused)
go
Do not use trace flag 757 in Adaptive Server versions earlier than 15.0.2 ESD #3.

另外 statement cache确实不应该配很大 Sybase官方建议也是100M

四川蜀人

谢谢楼主，学习收藏。

eisen-pb

alanzhu 发表于 2011-5-2 16:36
呵呵 看了关于 T757的介绍 觉得基本功课还是没做足 但谁能想到呢?
System-wide performance issues
If th ...

学习了……感谢楼主
不过……有鉴于并发性以及常用SP的调用程度，不知道有什么计算公式来推算合适的statement cache呢?