Storage workload estimation for database management systems
- 11 June 2007
- conference paper
- conference paper
- Published by Association for Computing Machinery (ACM)
- p. 377-388
- https://doi.org/10.1145/1247480.1247523
Abstract
Modern storage systems are sophisticated. Simple direct-attached storage devices are giving way to storage systems that are shared, flexible, virtualized and network-attached. Today, storage systems have their own administrators, who use specialized tools and expertise to configure and manage storage resources. Although the separation of storage management and database management has many advantages, it also introduces problems. Database physical design and storage configuration are closely related tasks, and the separation makes it more difficult to achieve a good end-to-end design. In this paper, we attempt to close this gap by addressing the problem of predicting the storage workload that will be generated by a database management system. Specifically, we show how to translate a database workload description, together with a database physical design, into a characterization of the storage workload that will result. Such a characterization can be used by a storage administrator to guide storage configuration. The ultimate goal of this work is to enable effective end-to-end design and configuration spanning both the database and storage system tiers. We present an empirical assessment of the cost of workload prediction as well as the accuracy of the result.Keywords
This publication has 8 references indexed in Scilit:
- Quickly finding near-optimal storage designsACM Transactions on Computer Systems, 2005
- Describing the Elephant: The Different Faces of IT as ServiceQueue, 2005
- Quartermaster-a resource utility systemPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2005
- Database tuning advisor for microsoft SQL server 2005Published by Association for Computing Machinery (ACM) ,2005
- Developing a characterization of business intelligence workloads for sizing new database systemsPublished by Association for Computing Machinery (ACM) ,2004
- The vision of autonomic computingComputer, 2003
- Automating physical database design in a parallel databasePublished by Association for Computing Machinery (ACM) ,2002
- AutoAdmin “what-if” index analysis utilityPublished by Association for Computing Machinery (ACM) ,1998