Re: [perf-discuss] mpstat output showing high cpu usage

2008-01-19 Thread Matty
On Jan 18, 2008 7:46 AM, Rafael Pires <[EMAIL PROTECTED]> wrote: > Hi, > I've been requested to investigate a performance issue with a sybase instance > bound to a processor set of 3 processors (server contains 16 in total). > After some investigation, I could not find any bottleneck with prstat,

Re: [perf-discuss] mpstat output showing high cpu usage

2008-01-18 Thread Sylvain Quartier
Hi, My experience with Database is that bottlenecks often come from queuing in the CPU or Disk. You should control the queue size for CPU with vmstats sar that msut not be higher than 10. For the Disk, the queue size must be less than 2 (but I'm sorry, I don't have the command now ... need to searc