Ktl-icon-tai-lieu

SQL Server 2005

Được đăng lên bởi nanaleu
Số trang: 166 trang   |   Lượt xem: 2518 lần   |   Lượt tải: 0 lần
SQL Server 2005
Database Administration

Agenda
•
•
•
•
•
•
•
•
•

Introduction
Installation
Data Storage Architecture
Database Physical Architecture
Tuning and Monitoring
Security
High Availability
Backup-Restore
Administration Overview

SQL Server 2005

SQL Server 2005 – Components Overview

SQL Server 2005- Components
Replication
Service Broker

Reporting Services

SQL Server 2005
SQL Server Agent

Relational Database
Engine

Analysis Services

.NET CLR

Notification Services

Integration Services

SQL Server 2005 – Relational Database Engine
Database Engine
• The primary component of SQL Server 2005
• The Online Transaction Processing (OLTP) engine for
SQL Server
• Responsible for the efficient storage, retrieval, and
manipulation of relational and Extensible Markup
Language (XML) formatted data
• Highly optimized for transaction processing

SQL Server 2005 – Analysis Services
Analysis Services
• Provides Online Analytical Processing (OLAP) and Data
Mining functionality
• Analytical processing done through multidimensional
data structures containing de-normalized and
aggregated data, often from diverse data sources
• Data Mining allows analysis of large quantities of data
for relationships and patterns

SQL Server 2005 – Integration Services
Integration Services
• Supports data extraction and loading to and from
heterogeneous data sources
• A complete change from its predecessor, Data
Transformation Services (DTS)
• Supports data extraction and loading to and from
heterogeneous data sources

SQL Server 2005 – Reporting Services
Reporting Services
• Provides solution for designing, deploying, and
managing flexible, dynamic Web-based reports
• Can pull information from various data sources
• Implemented as a Web service
• Supports user defined adhoc report

SQL Server 2005 – Notification Services
Notification Services
• Helps building applications that support the generation
and sending of data-driven notifications
• Notifications are personalized, timely messages that
can be sent to a wide range of devices according to
subscriber preference
• Enables sending critical information to customers,
partners, and employees

SQL Server 2005 – SQL Server Agent
SQL Server Agent
• Essential tool for automating database administration
• Executes scheduled administrative tasks through jobs
• Jobs can perform various database and non database
activities

SQL Server 2005 – Service Broker
SQL Server Service Broker
• Is a new technology in Microsoft SQL Server...
SQL Server 2005
Database Administration
SQL Server 2005 - Trang 2
Để xem tài liệu đầy đủ. Xin vui lòng
SQL Server 2005 - Người đăng: nanaleu
5 Tài liệu rất hay! Được đăng lên bởi - 1 giờ trước Đúng là cái mình đang tìm. Rất hay và bổ ích. Cảm ơn bạn!
166 Vietnamese
SQL Server 2005 9 10 84