SUMMARY: Performance Help

First, many thanks to:

Ramiro Santos
Ben Green
Kevin Buterbaugh 
Moamer O. Mohsin

All responses proved useful. Kevin knew actually what 
caused the problem: Sybase was using 3.5 of of 4GB,
not leaving enough memory for the OS in genernal.
Reducing Sybase's shared memory usage to 3GB solved
the problem. 
Best Regards,
-- 
Reggie Beavers

Free High Availability Software for 
Solaris at  http://www.fstha.com
--


--- Reggie Beavers <reggiebeavers@fstha.com> wrote:
> Greetings Managers,
> 
> I have two servers running Solaris 8, with 4GB Ram
> and
> 2 CPUs each. Storage is on an EMC. Both servers run
> Sybase (ASE 12.5) and perform the same function. The
> DBA is having performance trouble from ServerB. What
> I
> see is:
> 
> iostat -xn 
> ServerA
> r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b
> device
> 33.2 142.0 315.2 1803.3 7.9 1.3 45.0 7.4 5 15
> c2t8d70
> ServerB
> 449.6 4.8 19158.5 252.8 0.0 1.7 0.0 3.8 0 68 c2t1d59
> 
> I notice the high kilobytes/sec and %busy from
> ServerB
> but I also notice that the disk appears to be
> keeping
> up with the request (wsvc_t and asvc_t are low).
> 
> As far a memory goes ServerA is scanning for pages
> at
> 50 while ServerB is high, around 400! Both have 4GBs
> of RAM.
> 
> Both servers are running the same apps and doing the
> same function (Database updates). They are not
> clustered.
> 
> I think the problem is related to why the shared
> memory segments differ:
> 
> ipcs
> ServerA
> Shared Memory:
> m  100   0x655e005a --rw-------   sybase   sybase
> m  101   0x655e0094 --rw-------   sybase   sybase
> 
> ServerB
> Shared Memory:
> m  80600   0x65db0b93 --rw-------   sybase   sybase
> m  80201   0x65db0b0f --rw-------   sybase   sybase
> m 301502   0          --rw-------   sybase   sybase
> m 301303   0          --rw-------   sybase   sybase
> 
> Has anyone seen a problem such as this?
> Thanks for any help.
> Regards,
> --
> Reggie Beavers
> 
> Free High Availability Software
> for Solaris at www.fstha.com
> --
> _______________________________________________
> sunmanagers mailing list
> sunmanagers@sunmanagers.org
>
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers