Post on 05-Dec-2014
description
SAP Analitik & İnovasyon Forum İstanbulOyun Devam EdiyorSAP Sybase ASEKonuşmacı Adı : Mustafa KutluFirma Adı : SAP Türkiye
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 2
Gündem
Real-Time Data Platform
SAP Sybase ASE
SAP Uygulamalarına ASE’nin Sağladığı Faydalar
Kapanış
Real-time data platform
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 4
Next generation SAP Real-time Data Platform VisionUnified Data Management Platform for real time business
SAP RTDP Foundations● Cross-application data management &
access for new models of value discovery.
● High-performance on all classes of application and usage scenarios
Benefits● Store, analyze, optimize, transact and
mobilize without system limitations.
● Embrace and extend across variations of data forms and processing models.
● Common modeling, integrated development environment, shared systems management infrastructure and deployment independent solutions.
● Trusted and unified data environment.
Business Warehouse
Business Intelligence
Mobile & Embedded
ERP
Hadoop Big Data
In-memory/real-timeSAP HANA
SAP Real-time Data Platform
SAP Sybase ESPstreams
SAP Sybase SQL Anywhere
mobile and embedded
SAP Sybase IQEDW
SAP Sybase ASEtransactions
SAP Data Services / SAP Information Stewardinformation management
Common programming APIs
SAP
Syba
se P
ower
Des
igne
rm
odel
ing
SAP Sybase C
ontrol Center m
onitoring
Hadoop Big Data
Introduction to SAP Sybase ASE
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 6
What is SAP Sybase ASE?
A high-performance enterprise database management system
Designed for mission-critical transactional environments
Ideal foundation for data-intensive applications
Secure and scalable
Known for: Rock-solid reliability Superior performance Lowest TCO
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 7
SAP Sybase ASE: Proven and trustedPowering the world’s leading global organizations
>30,000Customers worldwide
90%Of top 50 banks and securities firms
1100SAP on ASE customers in 2012
97%Customer satisfaction rating
#1 Database on Wall Street five years running
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 8
SAP Sybase ASE is architected for performanceA recognized RDBMS leader in data-critical industries
In healthcare In telecommunicationsOn Wall Street
30%–40%Faster than
competitive RDBMS
2 millionTransactions per
minute
1 billion Transactions
per day
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 9
Milestones for SAP Sybase ASE
SAP Sybase ASE Technical Overview
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 11
SAP Sybase ASE Technical Overview
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 12
SAP Sybase ASE is Architected For Performance
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 13
Compression
Compression is an option in ASE •Application transparent set of compression capabilities •Both regular relational data as well as unstructured data •Reduces the storage footprint of databases •Benefits of reduced costs, while improving performance
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 14
Partitioning
Partitioning allows DBAs to divide tables into smaller partitions that are separately accessed and managed, good for large and growing data sets
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 15
Column Level Encryption
Encryption is a column property, just like NULL or NOT NULL
Benefits
• Simple and logical extension of concept of column properties, you can
selectively encrypt specific columns in a table with different key, thus
providing granularity of access
• You can create different keys for different columns
• The actual key value is generated by the system
• Minimizes performance impact
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 16
SAP Sybase ASE Supports High Availability Scenarios
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 17
SAP Sybase Replication Server
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 18
Comparing SAP Sybase ASE with alternativesBeyond initial licensing and maintenance costs
1 Calculating the True Cost of RDBMS Ownership and How Sybase ASE Stacks Up: A Guide for SAP Business Suite Users, Carl Olafson and Randy Perry, IDC Corporation, December 2011.
SAP Sybase ASE: Five-year savings per 100 users: $128,5801
“On average, companies in
the study estimated the
total cost for [SAP] Sybase
ASE to be 28% less than
the total cost of other
RDBMSs they are using,
which will save them about
$129,000 per 100 users
over five years.”1
Get more value from your landscape of SAP software
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 20
Optimized and certified to run SAP softwareDatabase of choice for SAP Business Suite
Software and database have been jointly developed, tested, and tuned
Each release is optimized and production-ready
Automated setup and configuration for straightforward implementation
Native interoperation with complementary products: SAP Sybase Replication Server SAP HANA
Integrated high availability and disaster recovery for zero-downtime scenarios1
1 Delivered via SAP Sybase Replication Server
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 21
Certified Results1
6,250 users 34,100 SAPS
Red Hat Enterprise Linux 6.2, SAP Sybase ASE 15.7 and SAP enhancement package 5 for SAP ERP 6.0
HP ProLiant DL380p Gen8 server 2 Intel Xeon Processors E5-2690 at 2.90 GHz 16 cores and 32 threads 256G RAM with 2 processors.
#1 Performance Achieved on SAP SD BenchmarkFirst SAP Sybase ASE results on SAP and HP
1Certification number 2012032, valid as of Sept. 7, 2012. Details can be found at http://www.sap.com/benchmark.
Best two-processor Linux result on the two-tier SAP SD standard application benchmark
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 22
Task and Challenges for DB Administrators
Are there performance bottlenecks?
?! Is the Backup scheduled?
Is there sufficient
disk space available?
Which tables need new statistics?Change DB
Configuration? Are there any DB errors that
need to be taken care of?
Why is a spesific transaction
running slow?
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 23
Unified administration reduces complexitySingle interface for managing both the application and SAP Sybase ASE
Database administration (DBA) cockpit and SAP Solution Manager: Integrated monitoring and administration tools for easier
database administration. The DBA cockpit is fully remote-enabled and allows
database management even if the SAP software system is down
Database performance warehouse in SAP Solution Manager provides full insight into database performance and its history
SAP Sybase ASE allows dynamic configuration for several parameters and avoids unnecessary downtimes of the database for customers
Flexible backup and restore methods available, support of filesystem and tape devices, and integration with storage managers
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 24
Run Better with SAP Sybase ASE DBA Cockpit
DBA Cockpit - Sybase specific implementation
• Database monitoring is based on database server level
• Short term history kept in monitored system (depending on type of data and configuration; default
is 14 days)
• All data is stored in a special database outside the SAP schema: saptools
• Data collection is done by stored procedures (injected by the DBA Cockpit)
• Stored procedures are called by the Sybase ASE scheduler
• Data collection takes place independent of the monitoring system
• No network traffic needed for data collection
• One central data source for all monitoring tools (DBA Cockpit, DB Performance Warehouse, E2E
Alerting, EWA...)
• No SAP application needed on monitored system, full remote enablement
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 25
Run Better with SAP Sybase ASE DBA Cockpit
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 26
Run Better with SAP Sybase ASE DBA Cockpit
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 27
Run Better with SAP Sybase ASE DBA Cockpit
Conclusion
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 29
SAP Sybase ASE for your SAP software landscapeBusiness value in the short and long run
o Proven: A respected RDBMS leader in data-critical industries
o Most cost-effective: Lower capital investment, more efficient use of hardware, and greater ease of management
o Best transactional performance: Extreme throughput, unlimited scalability, and breakthrough compression
o Vision: Integrated road map to the next-generation real-time data platform
Optimized data management portfolio
o Migration of RDMS involves minimum disruption and risk: Database-neutral SAP software architecture
Rapid-deployment services, SAP expertise, and global ecosystem of partners
© 2013 SAP AG or an SAP affiliate company. All rights reserved.
Teşekkürler
Mustafa KutluÇözüm Yöneticisi
mustafa.kutlu@sap.com