Seventh IEEE/ACIS International Conference on Computer and Information Science (icis 2008) Autonomic Computing in SQL Server May 14-May 16 ISBN: 978-0-7695-3131-1
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICIS.2008.111
With the growing size of enterprise data, the task of managing a database is becoming more and more complex as well as time-consuming. A database administrator spends most of his time in activities that can be made automatic. Also, scarcity of skilled database administrators have motivated the database industry to develop Autonomic Database Management Systems (ADBMS) which can alleviate many of the database administrators’ problems. These ADBMS may have one or more autonomic properties. In this paper, autonomic characteristics of Microsoft SQL Server are presented and analyzed to illustrate how self-managing behaviour of an ADBMS can reduce the workload of a DBA significantly. It has also been discussed which components of SQL Server are not fully autonomic and require Human Intervention. This provides the motivation for devising algorithms to further reduce the degree of human intervention still required in ADBMS.
Index Terms:
Autonomic computing, human intervention, optimization, SQL Server
Citation:
Abdul Mateen, Basit Raza, Tauqeer Hussain, M. M. Awais, "Autonomic Computing in SQL Server," icis, pp.113-118, Seventh IEEE/ACIS International Conference on Computer and Information Science (icis 2008), 2008 Usage of this product signifies your acceptance of the Terms of Use. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||