SAP HANA SPS 09 - What s New? SAP DB Control Center DBA Tool to manage Data Center

(1)

SAP HANA SPS 09 - What’s New?

SAP DB Control Center

– DBA Tool to manage Data Center

SAP HANA Product Management

November, 2014

(2)

Agenda

What’s New?

 Overview and Benefits

Pre-release preview

 SAP DB Control Center 4 with HANA Cockpit SPS09

Our overall story for DBA Tools

 SAP DB Control Center plus Cockpits and Solution Manager plus DBA Cockpit

Strategic Direction

(3)

What’s New?

(4)

Administration / Monitoring / Troubleshooting

What’s New in SPS09



SAP HANA cockpit

–

Web-based tool for administration and monitoring of

a single SAP HANA database



SAP DB Control Center

–

Web-based tool for administration and monitoring of

your landscape of SAP databases

–

Theme for SPS09: Support thousands of SAP

Databases in Data Center or Cloud



Enhanced SQL performance analysis in SAP HANA

studio

What’s Coming Beyond SPS09



Additional features for SAP HANA cockpit, e.g. further KPI

drill-down applications



Further monitoring and supportability improvements, e.g.

regarding alerting and resource management



Advanced landscape administration and monitoring capabilities in

SAP DB Control Center

–

Themes beyond SPS09: Support for Cloud Management,

Clusters, Embeddable databases, and Big Data.

–

Future direction: Enable 3

rd

_{party integrations, Enterprise}

(5)

What is SAP DB Control Center?

// Product Information

SAP DB Control Center is

SAP’s new-generation enterprise-class Systems Management solution that enables DBAs to

Administer and Monitor a variety of SAP Database products in one graphical UI either locally or remotely.

Capabilities:

Alerting, Monitoring and Resolution

• Alerts to notify before Database is critical, Monitor critical situations for the trending changes, and Administer

Database changes to resolve issues.

Prediction and Prevention

• Review snapshots of past as well as patterns over a period of time to predict time, place and reason for

future such events; and prevent issues before they occur.

Breadth of Coverage

• ASE, IQ, RS, ESP & SAP Mobile Platform; and extensible in future to HANA & SQLA.

Scale

• 1 to 250 servers of supported SAP DB products.

 Future release to increase scale to thousands of servers.

Ease of Use

• Graphically rich with graphs, charts and tables.

• Browser-based UI enables remote access, ease of deployment (without client-side installation), and easier upgrades/maintenance.

(6)

Steer your systems

(7)

SAP DB Control Center 4 – One-glance Snapshot

SAP DB Control Center 4 to support

Thousands of Servers of:



SAP HANA*



SAP HANA Data Management* (previously, RTDP)



SAP ASE



SAP IQ



SAP Replication Server (SRS)



SAP SQL Anywhere* (SQLA)



SAP Event Stream Processor (ESP)



SAP Mobile Platform (SMP)

*

Emerging in SAP DB Control Center 4

(8)

SAP DB Control Center – Overview

Please “Play ▶” this slide

• Variety of SAP DB

products

• Multiple deployments of

each

• Distributed

geographically

• Managed and Monitored

by a single instance of

SAP DB Control Center

• Used by DBAs dispersed

geographically across

time-zones

• Using various devices

(9)

Benefits

(10)

SAP DB Control Center and Cockpits

Standalone DB

[each]

Single Cockpit

[each]

Data Center

[Thousands of servers]

SAP DB Control Center

HANA Cockpit 1 HANA 1 HANA Cockpit 2 HANA 2 … … ASE Cockpit 1 ASE 1 ASE Cockpit 2 ASE 2 … … IQ Cockpit 1 IQ 1 … …

Cockpit is a new component added to each managed server



Co-installed with the managed server



Individualized to manage the single server it was installed with – i.e., no support for multiple servers like in SAP DB Control Center 3

(11)

SAP DB Control Center 4 benefits

SAP DB Control Center 4

{Data Center}

Cockpit

{Standalone}

SAP DB Control Center 4 provides administration and monitoring for SAP databases in Data Center or Cloud

SAP DB Control Center 4 benefits:

1. HANA support added; SQLA planned; and already supports ASE, IQ, SRS and ESP

2. Increase in scale to Thousands of managed servers

3. Re-use individualized Cockpits

4. Fiori UI new to SAP DB Control Center 4 (makes it Mobile-friendly)

5. HANA XS Engine new to SAP DB Control Center 4 (makes it Cloud-friendly)

6. Aggregated view of status across numerous servers

7. Executing Actions (e.g., Start/Stop) across numerous servers

8. Mass importing of Cockpits of managed servers

9. HANA provided with SAP Control Center 4 provides the foundation for future Historical Analytics and Predictive Analytics

Cockpits provide a new light-weight and individualized management for standalone DBs

Cockpits benefits:

1. Matches requirements from DBAs with fewer DB instances (i.e., not needing the Data Center level support of SAP DB Control Center 3)

2. Integrated with SAP DB Control Center 4

3. New HANA Cockpit added:

a. Uses Mobile-friendly Fiori UI

b. Runs in HANA XS Engine

4. ASE, IQ, SRS and ESP Cockpits to use new look emulating SAP’s UX3

5. Auto-discovery of managed servers

(12)

Pre-release preview

(13)

HANA Cockpit SPS09 with tiles for SAP DB Control Center 4

Top-level page of HANA Cockpit SPS09 registering the tiles for SAP DB Control Center:

(14)

SAP DB Control Center 4 – Monitor Enterprise Health

Enterprise wide monitoring in SAP DB Control Center:

Monitor Enterprise Health:

• Provides high level availability, health (capacity/performance) and alert status

• Cockpits interpret KPI’s collected and aggregate into availability/health

indicator

• Alerts broken into High (HP), Medium (MP) and Low (LP) priority to align with HANA

• User can drill into system or more context relevant URL via links under Availability, Capacity, Performance and Alerts

(15)

SAP DB Control Center 4 – Monitor Enterprise Health

Remote Start and Remote Stop servers in SAP DB

Control Center:

Start & Stop Systems:

(16)

DBA Tools story from SAP

(17)

SAP DB Control Center, HANA Cockpit, DBA Cockpit and Solution Manager

Using HANA as an example, the utility of SAP’s DBA Tools is as follows:

SAP DB Control

Center 4

HANA Cockpit

DBA Cockpit

(Solution Manager)

HANA

use case

1.Data Center

2.Cloud

1. Standalone

2. Cloud

SAP Business Suite on HANA

Core

Capabilities

Systems

Management

Systems Management

Focus

1. Landscape

2. Standalone

1. Standalone

2. Cloud

1. Standalone (DBA Cockpit)

2. Landscape (Solution Manager)

Feature /

capabilities

Database context

Business Suite context

(18)

Road Map

(19)

SAP’s Vision for DBA Tools

SAP’s vision is to provide incremental functionality to customers towards this end goal:

Business

Warehouse

Business

Intelligence

Mobile &

Embedded

ERP

Hadoop

Big Data

In-memory/real-time

SAP HANA

SAP HANA Data Management

SAP ESP

streams

SAP SQL Anywhere

mobile and embedded

SAP IQ

EDW

SAP ASE

transactions

SAP Data Services

Information management*

Common programming APIs

SAP

Sy

base

Pow

erDesigne

r

modeli

ng

SAP

DB

Contro

l Cente

r

Sy

stem

s Managem

en

t

Hadoop

Big Data

(20)

SAP DB Control Center 4 – Focus Areas

Focus Area Description

Data Center and Cloud Support

• SAP Databases join SAP DB Control Center 4 new architecture

• Core Data Center functions: Bulk/Batch Actions, Alerts, Matrix & Landscape View, Mobile support, Impact analysis, Job Scheduling & High Availability

• SAP DB Control Center readiness for Cloud support • Mobile devices remote access

Cloud Management, Clusters, Embeddable DB & Big Data Support

• Cluster-like Servers support • SQL Anywhere support

• Hadoop support (in the context of HANA and IQ) • Alert extensions

Market leading advanced capabilities

• Data Center ecosystem integrations

• Advanced Tuning, Advisors and Self-Management capabilities • Analytics integrations

• Historical Reporting integrations

(21)

Planned Innovations

Future Direction

Today

Unified Admin & Monitoring

 For ASE, IQ, RS, & SAP Mobile Platform

Scale / Performance

 Increase from ~35 to ~250 servers

 Other performance improvements

Replace SC

 Completed for IQ, ASE SMP and ASE CE

 SAP DB Control Center packaged and/or integrated into server products

Security

 SAP Security compliance

 Other Security enhancements

Newly added

 Cockpits for IQ and ESP

 For RS, Data Assurance & Multi-Path Replication support added

Expand support to SAP stack

 HANA,HANA Cloud Platform

 SAP Data Management

Continue unified UX

 New feature support for ASE, IQ, RS, ESP

Better scaling / performance

 Increase to Thousands of Servers

More ease of use

 SAP UI5 alerting

 Other usability improvements

Mobile device UX

 HTML5 Mobile devices enablement

 Apple iPad support

Continue unified UX

 New feature support for HANA, HCP, ASE, IQ, RS, and SQLA

 Add Hadoop support

 Ease of use extensions / templates

 HA (Distributed operation)

 Solution Manager integration

Integration with 3

rd

_{party tools}

 Alert integration with popular alerting solutions

Enterprise Reporting & Analytics

 Historical analysis, analytics & auditing

 API extensions or repository export

 Integration with IQ/HANA/BW, BOBJ, Crystal Reports, Lumira, ESP

This is the current state of planning and may be changed by SAP at any time.

(Release 3.3)

Road Map

Data Center and Cloud Support

Cloud Management, Clusters, Embeddable DB & Big Data Support

Market leading advanced capabilities

(Release 4)

(22)

2014-2015 Release Content

SAP DB Control Center is for Database use cases for non-SAP-Apps, and not applicable for SAP Apps use cases

Focus Area Features

Data Center

New – Enterprise Administration

 Data Center support

 Standalone support

Scale Increase to Thousands of managed servers per SAP DB Control Center instance

HANA

New – HANA Cockpit

 HANA Admin and Monitoring

 Dynamic Tiering

 HANA smart streaming

 XS Admin

 Multi-DB (HANA Multi-tenant Database Containers) support

 Data Provisioning

 Dashboard integration with Admin Cockpit of HANA Cloud Platform Mobile Services ASE

New – ASE Cockpit release

 Added platforms: AIX and HPIA

 Workload Capture and Replay

 Data Store and Access Management

 ASE HADR support

IQ Dynamic Tiering support

 Hot/cold data management ESP

HANA Streaming support

 HANA Streaming

(23)

2015 Road Map for HANA Cockpit

Feature

Description

HANA Admin and Monitoring

• Management standalone HANA; based on Fiori Launchpad; customizable; supports HANA cloud strategy;

and integrates with Control Center

Dynamic Tiering

• Hot/cold data management

o A new, optional capability for SAP HANA, enabling the classification of data as "hot" or "warm", with appropriate means of storing and processing data of these classes. This is important …

 Because not all data has the same quality

 Because not all data must be available with in-memory performance

HANA smart streaming

• Managing Streaming into HANA

XS Admin

• Administration for HANA XS

Multi-DB support

• Support for HANA Multi-tenant Database Containers

Data Provisioning

• Support federation, data movement and loading datawarehouse

(24)

Disclaimer

This presentation outlines our general product direction and should not be relied on in making

a purchase decision. This presentation is not subject to your license agreement or any other

agreement with SAP.

SAP has no obligation to pursue any course of business outlined in this presentation or to

develop or release any functionality mentioned in this presentation. This presentation and

SAP’s strategy and possible future developments are subject to change and may be changed

by SAP at any time for any reason without notice.

(25)

How to find SAP HANA documentation on this topic?

• In addition to this learning material, you can find SAP HANA

platform documentation on SAP Help Portal knowledge center at

http://help.sap.com/hana_platform

.

• The knowledge centers are structured according to the product

lifecycle: installation, security, administration, development:

SAP HANA Options



SAP HANA Advanced Data Processing



SAP HANA Dynamic Tiering



SAP HANA Enterprise Information Management



SAP HANA Predictive



SAP HANA Real-Time Replication



SAP HANA Smart Data Streaming



SAP HANA Spatial

• Documentation sets for SAP HANA options can be found at

http://help.sap.com/hana_options

:

SAP HANA Platform SPS



What’s New – Release Notes



Installation



Administration



Development



References

(26)

Thank you

Contact information

Kaleem Aziz

SAP HANA Product Management

(27)

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company. SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. Please see http://global12.sap.com/corporate-en/legal/copyright/index.epx for additional trademark information and notices. Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors.

National product specifications may vary.

These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP SE or its affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP SE or SAP affiliate company products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document or any related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation, and SAP SE’s or its affiliated companies’ strategy and possible future