This paper discusses (i) representative application "delinquent design patterns", (ii) an application code parser to find them, (iii) a log parser to identify the patterns that are critical, and (iv) a display to give a global view of the issue. We present a tool called AppSleuth that parses application code and the tracing log for two popular database management systems in order to lead a competent tuner to the hot spots in an application. The question is: can a tool help in this effort? We believe so. Our performance tuning experience across various industries (finance, gaming, data warehouses, and travel) has shown that enormous additional tuning benefits (sometimes amounting to orders of magnitude) can come from reengineering application code and table design. Other excellent work (]-) has shown how to use the optimizer to do automatic physical design or to make the optimizer itself more self-adaptive (-). ICIC InternationalĮxcellent work (-) has shown that memory management and transaction concurrency levels can often be tuned automatically by the database management systems. The difficult and complex tasks are performed through autonomic way with low cost, reduction of labor and in an efficient manner. In this survey paper, we discuss about autonomic Computing, self optimizing systems and its components with respect to DBMS and future work to be carried out in this area. And these increasingly valuable, complex systems require highly skilled IT professionals to install, configure, operate, tune and maintain them. Our information society has created unpredictable and highly variable workloads for these networked systems. The value of database technology and the Internet have fueled significant growth in storage subsystems, which now are capable of holding terabytes of structured and unstructured information. An exponential growth has occurred in the number and variety of systems and components. It is the complexity of the IT components themselves that have helped fuel this problem. In an on demand business, information technology, IT, components produced by high-tech companies over the past decades are so complex that IT professionals are challenged to effectively operate a stable IT infrastructure.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |