sql server 2012 essentials for oracle dbas - training day 1

5/28/2018 SQL Server 2012 Essentials for Oracle DBAs - Training Day 1

1/13

Module 1: Database andInstance


2/13

Overview

Defining a Database and an InstanceIntroduce Microsofts and Oracles Implementations of aDatabase and an Instance

Understand Client Interaction

Key Database and Instance Limitations


3/13

Concept of Database and Instance

Database Management System (DBMS) encompasses database and

instance

A Database is a set of physical files that store application and system data

An instance consists of the hardware resources of the system (primarilymemory and CPU utilization) that facilitates data access for the end-user

Storage

PC

Data

Server

CPU CPU

Process

Process

Process

Process

Memory

Data

Data

System

Log

CLIENT DATABASEINSTANCE

Control

Temp


4/13

Database and Instance Implementations

Oracle 11g


5/13



6/13



7/13



8/13


SQL Server 2012


9/13

Demonstration:

Understanding the SQL ServerInstance Environment


10/13

Client Interaction with Database and Instance

Key components in the interaction of the user (client) with thedatabase environment

Application

Layer

-------------

SQL Server

Network

Interface

protocol

layer

-------------SNAC

network

libraries

Client

Person

ClientSystem

Database Server

Engine

TDS Endpoints

(Shared

memory,TCP/IP, named

pipes, VIA,DAC)

Relational

Engine

--------------

Tabular Data

Stream (TDS)

Packet------------

SQL Server

Network

Interface (SNI)

Layer

Storage

System

Data

Storage

ApplicationLayer

-------------

Oracle Net

Foundation

Layer

-------------

Oracle

Protocol

Support

Layer

Client

Person

Client

System

Database Server

Listener

(defined bylistener.ora may

implement

TNSnames.ora

OracleInstance

--------------

Oracle Net

FoundationLayer

------------

Oracle

Protocol

Support

Layer

StorageSystem

Data

Storage

Oracle

Connections

SQL Server

Connections


11/13

Demonstration:

Reviewing Network Connections


12/13

Database Capacities

A brief look at Oracle and SQL Server 2012 maximumcapacity specifications

Database Capacities on Windows

Server 2008 R2 (x86 or x64)

Oracle 11g SQL Server 2012

Minimum data block size 2 KB 8 KB

Maximum data block size 16 KB (Linux or Windows) or 32

KB (other OSs)

8 KB

Maximum file size 64 GB 16 TB

Maximum number of files 65,536 32,767

Maximum database size 4 PB

(65,536 * 64 GB)

524 PB

Maximum control file size 20,000 data blocks N/A

Instances per server Limited by host resources 50 for all editions

Maximum database extent 4GB 64 KB

Maximum number of tablespaces 65,536 32,767 (filegroups

seeModule 2)

Maximum log file size 2 GB (operating system limit) 2 TB


13/13

Review

Provided a definition for the database and how it is morespecialized than normal file system.

Differentiated the instance from the database and lookedat the high level components of each DBMS.

Both DBMS systems rely on network protocols,listeners, and client software that allow communicationsin a database environment.

Each of the DBMS provide large resource capacities for

applications using the Microsoft Windows operatingsystem.

sql server 2012 essentials for oracle dbas - training day 1

Documents