ASE server on SUN M5000 hardware - 05-11-2011 , 08:55 AM
Has anyone running an ASE server on a M5000 machine of SUN with more
than 20 engines activated ? And what are the experiences ?
Re: ASE server on SUN M5000 hardware - 05-12-2011 , 07:27 PM
We've been using a Sun M5000 with 4 UltraSparc VII 2.4 GHz Quad-Cores and 64GB of RAM with ASE 12.5.4.
However, we're only using 14 engines. We also disabled the SMT feature because of performance issues, so it's only one thread per core.
The performance of the server has been phenomenal though, we've been hitting up to 2500+ Committed Xacts per sec, 2000+ Procedure Requests per sec and 4500+ Total Requested Disk I/Os per sec during peak time without a hitch.
Hope this helps.
Re: ASE server on SUN M5000 hardware - 05-16-2011 , 02:10 AM
Our SUN M5000 has 8 Ultrasparc VII 2.66 GHz Quad-Cores and 96GB of
RAM also with ASE 12.5.4.
We first have enabled the threading (2 threads per core) and we have
started the ase seever with 40 engines and 60G memeory (our previous
configuration on a SUN Fire E2900 was 20 engines / 30G memory).
We have switched to this new machine in the evening and during the
night the batch processes runs faster and during the morning our OLTP
runs good but then suddenly the cpu consumptions of the ase server was
very high (in sysmon we saw a very high spin lock contention on the
Object Manager > 60%) and the global performance was decreasing . We
have switched back to our standby server (with replication server) to
out old E2900 installtion, we have reconfigured the SUM with 1 thread
per core and we have started the ase server back with 20 engines and
we have switched back to the new machine and until now everything runs
The performance ot the new machine is better then the previous but we
see one problem when we execute a database extension (add a fragment
of 2000M to a database) then it seems that the global server
performance is impacted . We are investigating this with SUN.
Is it possible to describe your perofmance issues with multiple