Continuous resource monitoring for self-predicting DBMS

Proceedings - IEEE Computer Society's Annual International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunications Systems, MASCOTS

Volumn 2005, Issue , 2005, Pages 239-248

  Narayanan, Dushyanth ^a   Thereska, Eno ^b   Ailamaki, Anastassia ^b  

^a MICROSOFT RESEARCH   (United Kingdom)

^b CARNEGIE MELLON UNIVERSITY   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

ADMINISTRATORS; RESOURCE ADVISOR; RESOURCE MONITORING;

PERFORMANCE; PROGRAM PROCESSORS; STORAGE ALLOCATION (COMPUTER); SYSTEMS ANALYSIS;

DATABASE SYSTEMS;

EID: 33646923445     PISSN: 15267539     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/MASCOTS.2005.21     Document Type: Conference Paper

References (27)

1. S. Agrawal, S. Chaudhuri, L. Kollar, A. Marathe, V. Narasayya, and M. Syamala. Database tuning advisor for Microsoft SQL Server 2005. In Proc. 30th VLDB conference, Aug. 2004.
2. A. Ailamaki, D. J. DeWitt, M. D. Hill, and D. A. Wood. DBMSs on a modern processor: Where does time go? In Proc. 25th VLDB conference, Sept. 1999.
3. P. Barham, A. Donnelly, R. Isaacs, and R. Mortier. Using Magpie for request extraction and workload modelling. In Proc. 6th Symposium on Operating Systems Design and Implementation, Dec. 2004.
4. L. A. Barroso, K. Gharachorloo, and E. Bugnion. Memory system characterization of commercial workloads. In Proc. 25th Annual International Symposium on Computer Architecture, June 1998.
5. K. P. Brown, M. Mehta, M. J. Carey, and M. Livny. Towards automated performance tuning for complex workloads. In Proc. 20th VLDB conference, Sept. 1994.
6. M. J. Carey, S. Krishnamurthy, and M. Livny. Load control for locking: the 'half-and-half' approach. In ACM Symposium on Principles of Database Systems, Apr. 1990.
7. S. Chaudhuri and G. Weikum. Rethinking database system architecture: towards a self-tuning RISC-style database system. In Proc. 26th VLDB conference, Sept. 2000.
8. M. Chen, E. Kiciman, E. Fratkin, E. Brewer, and A. Fox. Pinpoint: Problem determination in large, dynamic, Internet services. In Proc. International Conference on Dependable Systems and Networks (IPDS Track), June 2002.
9. H. Chou and D. DeWitt. An evaluation of buffer management strategies for relational database systems. In Proc. 11th VLDB conference, Aug. 1985.
10. A. Dan, P. S. Yu, and J.-Y. Chung. Characterization of database access pattern for analytic prediction of buffer hit probability. VLDB J., 4(1): 127-154, 1995.
11. W. Effelsberg and T. Härder. Principles of database buffer management. ACM Transactions on Database Systems, 9(4):560-595, Dec. 1984.
12. J. Gray. Benchmark handbook: for database and transaction processing systems. Morgan Kaufmann, 1992.
13. IBM. Autonomic computing: IBM's perspective on the state of information technology. http://www.research.ibm.com/autonomic/manifesto/, 2001.
14. IBM. DB2 performance expert. http://www-306.ibm.com/software/data/ db2imstools/db2tools/db2pe/, 2004.
15. S. T. Leutenegger and D. Dias. A modeling study of the TPC-C benchmark. In Proc. 1993 ACM SIGMOD International Conference on Management of Data, May 1993.
16. G. Lohman, G. Valentin, D. Zilio, M. Zuliani, and A. Skelley. DB2 Advisor: An optimizer smart enough to recommend its own indexes. In Proc. IEEE International Conference on Data Engineering (ICDE), Feb. 2000.
17. S. Manegold, P. Boncz, and M. L. Kersten. Generic database cost models for hierarchical memory systems. In Proc. 28th VLDB conference, Aug. 2002.
18. R. L. Mattson, J. Gecsei, D. R. Slutz, and I. L. Traiger. Evaluation techniques for storage hierarchies. IBM Systems Journal, 9(2):78-117, 1970.
19. D. T. McWherter, B. Schroeder, A. Ailamaki, and M. Harchol-Balter. Priority mechanisms for OLTP and transactional web applications. In Proc. IEEE International Conference on Data Engineering (ICDE), Mar. 2004.
20. Microsoft. Event Tracing for Windows (ETW). http://msdn.microsoft.com/ library/en-us/perfmon/base/event_tracing.asp, 2002.
21. Microsoft. Improving SQL Server performance, http://msdn.microsoft.com/ library/, 2002.
22. Oracle. Oracle database manageability. http://www.oracle.com/technology/ products/manageability/, 2004.
23. S. Papadomanolakis and A. Ailamaki. Automating schema design for large scientific databases using data partitioning. In Proc. 16th International Conference on Scientific and Statistical Database Management (SSDBM), June 2004.
24. M. Seltzer, P. Chen, and J. Ousterhout. Disk scheduling revisited. In Proc. 1990 Usenix Winter conference, Jan. 1990.
25. Transaction Processing Performance Council. TPC Benchmark C (On-Line Transaction Processing) Specification. http://www.tpc.org/tpcc/.
26. T.-F. Tsuei, A. N. Packer, and K.-T. Ko. Database buffer size investigation for OLTP workloads. In Proc. 1997 ACM SIGMOD international conference on Management of Data, May 1997.
27. M. Wang, K. Au, A. Ailamaki, A. Brockwell, C. Faloutsos, and G. R. Ganger. Storage device performance prediction with CART models. In Proc. 12th Annual Meeting of the IEEE/ACM International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems (MASCOTS), Oct. 2004.