Abstract
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.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
