Automatic tuning of the multiprogramming level in Sybase SQL Anywhere

@article{Abouzour2010AutomaticTO,
  title={Automatic tuning of the multiprogramming level in Sybase SQL Anywhere},
  author={Mohammed Abouzour and K. Salem and P. Bumbulis},
  journal={2010 IEEE 26th International Conference on Data Engineering Workshops (ICDEW 2010)},
  year={2010},
  pages={99-104}
}
This paper looks at the problem of automatically tuning the database server multiprogramming level to improve database server performance under varying workloads. We describe two tuning algorithms that were considered and how they performed under different workloads. We then present the hybrid approach that we have successfully implemented in SQL Anywhere 12. We found that the hybrid approach yielded better performance than each of the algorithms separately. 
Database Self-Management: Taming the Monster
Topics in Meeting Complex Service Level Objectives for Mixed Database Workloads
EasyControl: Improve Database Throughput under Overloading
Report: 4th Int'l Workshop on Self-Managing Database Systems (SMDB 2009)
...
1
2
...

References

SHOWING 1-10 OF 16 REFERENCES
Automatically Tuning Database Server Multiprogramming Level
A predictive performance model to evaluate the contention cost in application servers
How to Determine a Good Multi-Programming Level for External Scheduling
Staged database systems
Adaptive Load Control in Transaction Processing Systems
SQL Anywhere: A Holistic Approach to Database Self-management
A smart hill-climbing algorithm for application server configuration
Rethinking Database System Architecture: Towards a Self-Tuning RISC-Style Database System
Goal-oriented dynamic buffer pool management for data base systems
...
1
2
...