Friday May 06, 2016

Best Practices Using ZFS For SAP ASE Database

SAP Adaptive Server Enterprise (ASE) database 16.0 and 15.7 are certified to run on Oracle Solaris 11 systems using ZFS as data storage and logs. Recent testing with OLTP workloads on Oracle SPARC systems with Solaris 11 show better or on-par performance with ZFS compared to UFS or raw devices.  

Oracle Solaris ZFS is a powerful file system that combines file system capabilities with storage features that are traditionally offered by a volume manager. ZFS is the default file system in Oracle Solaris 11 and includes integrated data services, such as compression, encryption, and snapshot and cloning. Oracle Solaris and ZFS are also the foundation of Oracle ZFS Storage Appliance.  

ZFS Best Practices For SAP ASE Database:

  • Create separate zpools for data and the transaction log.
  • Create zpool for data using multiple LUNs for better I/O bandwidth.
  • ZFS record size for data is one of key parameters for optimal performance. The default  value of 128K is too large and causes page overhead.  For Solaris SPARC systems with the DB page size of 8K or less, a ZFS record size of 32K provides  the best performance for both file system block and raw zvol.
  • Place ZIL (ZFS Intent Log) on SSDs for improved latency of both data and transaction log.
For more details see SAP Note  2300958 : ZFS Certification of SAP ASE 16.0 and Sybase ASE 15.7 on Oracle Solaris 11 (requires SAP login).

Monday Apr 25, 2016

Unbeatable Scalability of SAP ASE on Oracle M7

The Oracle SPARC M7 platform has incredible performance and some examples of it can be found in this blog. One very interesting customer example is with SAP ASE performance and scalability. SAP Adaptive Server Enterprise (Sybase) database is used by University hospitals Leuven (UZ Leuven). UZ Leuven is one of the largest healthcare providers in Europe and provides cloud services to 16 other Belgian hospitals, sharing patient records supported by the same IT infrastructure and systems. 

UZ Leuven was looking to increase the scale capacity of its SAP ASE platform to accommodate an anticipated 50% business growth in user transactions, along with added functionality of the application as more hospitals join the network. Their current load was about 80 million transactions per day for a 5 TB database.

420 vs 48 on Intel

The SPARC M7 platform proved to be the only platform that could linearly scale up to 420 SAP ASE clients, while their Intel E7-8857v2 platform scaled to only 48 clients.

The SPARC M7 platform also delivered better performance and response times while ensuring data availability and information security, critical needs for UZ Leuven’s patients. 

“Today, SPARC is the only suitable platform that meets our application needs. We selected SPARC servers over IBM and x86-based solutions because scalability and performance are essential for our mission-critical SAP Adaptive Server Enterprise database infrastructure. With the SPARC M7 servers, we can expand our business and grow at the speed of our customers,” said Jan Demey, Team Leader for IT Infrastructure, University Hospitals Leuven.

You can read the full story here.

In the next blog, we will discuss best practices for using Oracle Solaris ZFS file system for your SAP ASE database.

Tuesday Aug 07, 2012

Sybase releases ASE 15.7 64 Bit/SPARC on Solaris 11

Sybase logo

Sybase released ASE 15.7 ESD#1 64 Bit for Solaris 11 (Sybase platform certifications M-class servers , T-class servers). The product is available as well for Solaris 10 with support for SPARC.

About

Application tuning, sizing, monitoring, porting on Solaris 11

Search

Categories
Archives
« June 2016
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
9
10
11
12
13
14
16
17
18
19
21
22
23
24
25
26
27
28
29
30
  
       
Today