Our sybase server have 4 sybase DBs and it has only two processors. One Sybase server (ie sybaseA) uses almost 5o% of CPU and our sybase setting only use 1 processor. Our servers reports slow response at business for the sybaseA and it uses almost 50% of the CPU. According to VMSTAT, the kernel time is almost 60% of CPU. My question why the kernel time is over so 60%. Does it related to sybase parameter setting? I want to find out the bottleneck of the sybase servers.
US SY WA ID
06/02/08 09:02:24 2 0 537916 4550 0 0 0 0 0 0 1722 57679 2502 22 70 0 8
06/02/08 09:32:25 2 1 539835 3608 0 0 0 0 0 0 1689 69463 2409 19 80 0 0
06/02/08 10:02:24 2 0 540296 5960 0 0 0 0 0 0 1302 90319 1762 16 80 0 4
06/02/08 10:32:24 2 0 541335 5396 0 0 0 0 0 0 1632 38547 2660 19 65 0 16
We are using AIX 5.2 ML04 and sybase 12.5.
Any comment is appreciated.
Start Free Trial
