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.
Chapter 3. Database structure 79
Both trigger and stored procedure are written in a proprietary language called
Transact-SQL. This is a structured programming language that can imbed and
execute SQL command without the need to compile it.
The important tools for administering Microsoft SQL Server are:
? Microsoft SQL Server Enterprise Manager: a snap-in application to Microsoft
Management Console that enables almost any database administration
function to be performed, even launching other tools. The sample Microsoft
SQL Server Enterprise Manager screen in Figure 3-1 shows the available
servers with all the objects underneath them.
Figure 3-1 Microsoft SQL Server Enterprise Manager
? SQL Query Analyzer (isqlw): An interactive program that enables execution
of SQL command and displays the result. A non-GUI version of the Query
Analyzer can be called from the command line using the isql command.
? SQL Query Profiler: A tracing tool that shows the applications accessing the
database engine and the SQL statements that have been executed. This is an
excellent debugging tool for a large number of components, as it enables you
to see the SQL statements that are issued by each component.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset