Sybase 15.x T5220 workload
We would like to introduce a real test example where we are using a relational database system, Sybase ASE 15.0 on a T5220 server from Sun Microsystems. We are running a basic OLTP application developed inhouse and we try to test this application and analyse the results.For the first time we will record the CPU statistics data from operating system via System Data Recorder or mpstat and analyse the results using cpuplayer.
The server uses 1 physical CPU, 8 cores per chip making 32 virtual CPUs. 32GB RAM is used for this server and Sybase configured for 3GB shared memory segment. Default configuration used for this test was 8 engines for ASE. Sybase ASE uses its own private mechanism for threading, meaning the database server deploys a number of database engines, one multithreading process as each db engine. Interesting is that you can easily see that only one thread is active per database engine at all times, visible using prstat. This is important to note when deploying Sybase on server architectures as Niagara, T5220.
A series of testes were executed on this hardware configuration and we tried to select the best setup for ASE by looking to the overall utilisation and workload: we try to maximize the utilisation of all CPUs or some part of them for our application. To maximize the utilisation and the throughput we tried to use processor sets, part of Solaris 10 operating system.