Database Reference
In-Depth Information
In this chapter, we will look at the automated administration practices such as the
implementation of security, availability, performance monitoring, and tuning features of
SQL Server 2008 R2. We will also look at the concepts related to scheduling aspects of the
SQL ServerAgent to handle the Extract-Transform-Load (ETL) processes, and administering
the replication process to trouble shooting multi-server instances using the new utility
administration tool from SQL Server Management Studio (SSMS).
Designing automated administration
practices
The automation of administrative tasks is essential when the data platform turns to more
complex systems and larger databases. The key task for the Database Administrator is to be
able to automate the routine tasks and develop proactive maintenance to ensure that data
availability and integrity is maintained without any interruption. The life-cycle of automated
processes for SQL Server administration is a large topic, and it's not possible to cover all of
them in this recipe alone. Hence, the key aspects of automation have been enlisted. In order
to accomplish the automated administration, the SQL Server Services must be setup with
startup accounts with necessary privileges that will help to harden the SQL Server platform at
the time of deployment.
The evolving business needs and application requirements have made the Database
Administrator's role more challenging. Prior to SQL Server 2008, a great deal of time was
spent performing routine administrative tasks such as backup/restore operations and
monitoring the SQL Server instances. The key ingredient for this recipe is to understand
the windows operating system service and account privileges to implement the SQL Server
platform's automation methods.
Getting ready
The SQL Server setup wizard follows the process of a windows installer-based installation
that provides a single-tree feature to select or de-select SQL Server tools and components.
The various components that can be selected are the SQL Server Database Engine, Analysis
Services, Reporting Services, Integration Services, Replication, and Management tools. Each of
the above services in SQL Server represents a set of processes to manage the authentication of
server operations with Windows services, as seen in the following screenshot:
Search WWH ::
Custom Search