Data Management

Automatic Tuning of the Multiprogramming Level in Sybase SQL Anywhere

Download Now Date Added: Jan 2010
Format: PDF

This paper looks at the problem of automatically tuning the database server multiprogramming level to improve database server performance under varying workloads. The authors describe two tuning algorithms that were considered and how they performed under different workloads. They then present the hybrid approach that they have successfully implemented in SQL Anywhere 12. They found that the hybrid approach yielded better performance than each of the algorithms separately. Database servers are used in a variety of software environments. Each application has its own workload characteristics. As a result, a database server must be configured to achieve the best performance possible for a specific workload on specific hardware.