78 Tivoli Business Systems Manager Version 2.1: End-to-End Business Impact Management
3.1 Microsoft SQL Server overview
Microsoft SQL Server is a full-function database platform that provides an
advanced RDBMS processing function with a tight integration into the operating
system. We used Microsoft SQL Server 2000 for our examples.
Microsoft SQL Server has the following services:
? SQL Server engine, which is the primary process that performs the RDBMS
function
? SQL Server agent, a job-scheduling function that automates execution of
certain database functions on a given schedule
? Microsoft Distributed Transaction Coordinator (MSDTC), which is not used by
IBM Tivoli Business Systems Manager
When it is initially installed, Microsoft SQL Server comes with the following
databases:
? master: The primary database of this Microsoft SQL Server instance, which
contains other databases and extended stored procedure information
? model: The database that will be used for creating new (empty) databases
? msdb: Database for SQL Server agent and log-forwarding feature information
? tempdb: Temporary database for creating and using temporary tables, such
as tables that start with a hash sign (#)
? Northwind: A sample database
Each of those databases is implemented initially as a single file. Each database
has a log file associated with it to record any incomplete transactions.
These are the important objects in the user database:
? Tables and indexes to store data.
? System tables to store database objects. The names are typically have the
sys prefix.
? Trigger, a program that is executed on a certain condition of a row in a table,
such as insertion, update, or deletion.
? Stored procedure, which performs a specific action that can be called as a
single transaction.
? User defined data types and functions, which provide the user flexibility when
defining new columns or variable types and new data processing routines.