The following sessions will be part of the in-conference SAP Adaptive Server Enterprise track in Atlanta:
Achieving Linear Performance Scalability in Large Multi-core systems with SAP ASE 16 – Stefan Karlsson (1 Hour Lecture)
While hardware providers and processor designers continue their breakthrough innovations in delivering larger multi-core & large memory systems, the SAP ASE team has been hard at work to ensure SAP ASE can leverage these large capacity systems efficiently. This session will explore the breakthrough innovations we are delivering in SAP ASE 16 by improving run-time logging as well as lock, metadata, and latch management.
Case Study - Building and Maintaining an Historical System Monitoring Environment for SAP ASE – Apurba Saha (1 Hour Lecture)
The accumulation of historical monitoring metrics information for the SAP ASE Database server is a critical task in any production environment. It is especially important to be able to tie performance metrics to different application processes. This session will provide a case study of our approach both in capturing and storing the information but also in enriching the raw data to provide more detailed information on the health of our SAP ASE database servers.
Case Study - Taming Data Growth and Maintaining Performance using Semantic Partitioning – Dharmapalan Sreekumar (1 Hour Lecture)
Today, SAP ASE has good support for basic partitioning models such as range, list, and hash partitions. However, missing from SAP ASE's partitioning model is the notion of subpartitions. This session will explore how we overcame this limitation by designing and implementing an innovative solution. The session will explore Semantic Partitions in detail and our solution including performance characteristics both before and after our approach was implemented.
Configuration and Tuning of SAP ASE on RedHat Enterprise Linux – Chris Brown (1 Hour Lecture)
Linux in general, and Red Hat in particular, is fast becoming a dominant deployment platform for ASE. This session will cover the best practices for configuration and tuning of ASE running on the RedHat Linux platform. We will cover how to tune the different memory, networking, CPU, and storage options so that you are able to maximize performance of ASE on Red Hat Linux.
Continuous Availability: The Top 15 (or more) Reasons to use Data Only Locking Scheme in ASE 15.7 – Cory Sane (1 Hour Lecture)
There are several subtle differences between features of the Data Only Lock scheme and All Page Lock scheme in the operational management commands for recent versions of ASE. Fifteen of these differences will be discussed in regards to ease of maintenance tasks and other ASE system features.
Continuous Availability: Using SAP Replication Server for SAP ASE Hardware Swapout with Minimal Downtime A Case Study – Cory Sane (1 Hour Lecture)
A review of steps used to move a Replication Server, a primary ASE instance and a replicate ASE instance to new hardware using two smaller maintenance windows instead of a multi-day outage.
Enhancements in Database Recoverability in SAP ASE 16 – Peter Thawley (1 Hour Lecture)
For most DBAs and IT Managers, the sheer mention of database recovery brings and fear and uncertainty to the forefront of the mind. This session explores key enhancements in SAP ASE 16 to reduce the stress in these situations and speed recoverability to get the business back on track quickly.
Enhancements in Operational Scalability in SAP ASE 16 – Stefan Karlsson (1 Hour Lecture)
As OLTP databases grow into the ten's of Terabytes, operational scalability becomes a much more issue. Consider the time simply to building indexes on tables that often themselves can be a Terabyte or more. This session will explore critical enhancements in SAP ASE 16 to simplify the management of these extremely large OLTP systems we are now seeing become more common.
Enhancements in Optimization and Query Processing in SAP ASE 16 – Peter Thawley (1 Hour Lecture)
Efficient and accurate query optimization and query processing is the key to good performance in any RDBMS. SAP ASE 16 brings several key enhancements in these areas, especially for extremely databases. This session will explore these innovations in areas such as dynamic thread assignment for improved parallelism, improved performance of SORT and HASH JOIN operators, star join optimizations as well as the higher query limits for things like numbers of tables in a query and order-by clauses.
Enhancements in SAP ASE 16's Semantic Partitioning for Improved Operational Simplicity – Peter Thawley (1 Hour Lecture)
Historically, OLTP databases tended to be reasonably small in comparison to their OLAP counterparts. Over the past several years, we see the growth of OLTP data sets to be significant which is placing great pressure on operations teams. Today, it is fairly common to see an ASE database that is well over 10 Terabytes. This session will dive into the details of several enhancements to semantic partitions to improve both run-time query performance and operational maintenance activities in these extreme cases.
Enhancing the Security of Data at Rest with SAP ASE 16 – Vinod Chandran (1 Hour Lecture)
With the recent publicity of significant data breaches at several large retailers in the US, data protection continues to be an important topic for DBAs and IT Managers to support. SAP ASE 16 extends the column level encryption option with both full database encryption as well as some other general enhancements to increase the overall security of data.
How to be a Great SAP ASE DBA – Jeff Garbus (1 Hour Lecture)
How does a DBA go from Senior to GURU? What does a Production DBA from another technology need to know in order to move to ASE? This session is both technical and theoretical in nature. I share detail from our ISUG-TECH -Journal articles as well as new material. Topics include but are not limited to:
- Difference between a production & development DBA
- Appropriate preventive maintenance regimens (list, + abbreviated technical details)
- Disaster planning / Business continuity
- Developer interaction
- Personality attributes
Indexing for Performance – Jeff Garbus (2 Hour Lecture)
It's amazing how many performance issues are resolved by adding or changing indexes. This session talks about how to choose indexes based upon query needs with an understanding of physical index structure. Topics include:
- Cost-based optimization
- How the optimizer chooses indexes
- Clustered vs. nonclustered indexes
- Physical storage of the indexes
- Index covering
- Indexing for Joins
- Lots of examples
Key Operational Scalability Features in SAP Adaptive Server Enterprise – Vinod Chandran (1 Hour Lecture)
In this session, we will discuss some of the key features like shrink database, incremental reorg, cumulative/incremental backup, online index creation, improved data load performance, BW enhancements, and new query plan optimizations that were introduced in SAP ASE. We will get into the details of features in the area of operational scalability, namely shrink DB and incremental reorg. The alter database command can add space to a database but there is no equivalent command to remove space. This presentation will introduce the SAP Adaptive Server Enterprise enhancement that addresses this demand by providing the ability to shrink the database, including both data and log. Shrinking a database means removing physical storage from it. We accomplish that purpose by disassociating logical storage from physical storage in identified areas of the database. Any existing data will be moved to a new location as needed, for the purpose of emptying the space to be released. Additionally, we will also cover incremental reorg, which allows a user to schedule and resume reorganizations, while allowing reads/writes on the data being reorganized. Come join us for a discussion on the new features and benefits offered by SAP ASE and how these new features can be leveraged in your environment.
Managing Multi-Terabyte OLTP databases in SAP ASE – Jeff Tallman (2 Hour Lecture)
As a result of SAP ASE's support of the SAP applications, the number of multi-TB VLDB's on SAP ASE has increased significantly. Now, low single digit TB implementations are quite common but we are starting to see a few implementations in the 10-15TB range. This has exposed a number of issues concerning how to effectively manage such systems with considerable focus on operational DBA tasks and overall system availability. This session takes a look at enhancements in SAP ASE 15.7 and forthcoming 16.0 that reduce time for create index and update statistics as well as enhancements such as online index creation/online reorgs and addresses the age-old but oft plaguing issues of dbcc's, backups and storage implementation.
Migrating Custom Applications to SAP Databases with SAP's Exodus Migration Tool – Rob Verschoor (1 Hour Lecture)
With the recent and broad interest from SAP customers in migrating custom applications (i.e. non-SAP applications) to the SAP databases, SAP has created a migration tool named 'Exodus' to help with migrating custom applications from non-SAP to SAP databases.The main function of Exodus currently is to migrate server-side SQL code (e.g. stored procedures etc.) to the SQL dialect of a SAP database. Migrating such server-side SQL code is typically the most challenging part of a cross-database migration, since many developers choose to utilize a lot of the proprietary enhancements in the vendor's SQL dialect.
This presentation looks at the different Exodus features as well as at common aspects, challenges and success factors of custom-app DBMS migrations.
Migrating SAP ASE to IBM Power Systems, upgrading existing Power Systems supporting SAP ASE, and upgrading SAP ASE in the migration process each present planning and technical challenges, particularly in the context of faster, more powerful processors. Based on field experience, we present an overview of reasons for migration, the migration and upgrade processes, the elements of infrastructure which have to be taken into account, and best practices for configuring SAP ASE and the AIX or Linux OS on faster, more powerful processors. While the vast majority of SAP ASE installations on Power use AIX, differences of detail for Power Linux will be noted in context. Topics will include:
- How SAP ASE's design makes cross platform migration and same-platform upgrade easier
- Important new features of ASE 15.7 and how they interact with AIX and Linux on Power
- How SAP and IBM together support advanced Power Virtualization features such as Live Partition Mobility and Active Memory Expansion
- How Cross-Platform Dump and Load (XPDL) works with AIX and Power Linux
- Other data migration options
- Network and client infrastructure considerations
- Virtual memory configuration and tuning
- Data layout best practices -- raw devices, file system, striping
- Storage virtualization
- SAP ASE engine sizing and Power CPU allocation-- how to determine the best fit for the fastest processors
- Consolidation, scaling out and scaling up: how Power Systems shared processor model can accomodate various scenarios
- Requirement gathering for Proof of Concept and full migration
- Commonly encountered performance problems with SAP ASE on very fast processors, and suggested remedies
Query Tuning - Getting it Right the First Time! – Janis Griffin (1 Hour Lecture)
Whether you are a developer or DBA, this presentation will outline a method for determining the best approach for tuning a query every time by utilizing response time analysis and SQL Diagramming techniques. Regardless of the complexity of the statement or database platform being utilized (this method works on all), this quick and systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
Round Table Discussion: Performance and Tuning of SAP ASE Housekeeping – Joe Woodhouse (1 Hour Round Table)
There's usually little disagreement about what SAP ASE housekeeping "should" be performed in a Production server... but one of the main reasons it might not be is due to performance, windows of opportunity, elapsed time, and outages. This session will be a round-table discussion of everything we've ever done that made backups, update statistics, dbcc or reorg faster (or less necessary).
Everything is in scope! Hardware! SAP ASE configuration! O/S tuning! How often do we really need to run these things? Do we really need to run them at all? Intended for seasoned DBAs but all welcome to listen and learn, as well as contribute!
SAP ASE 15.7 IMDB and Compression – Real World Results from Caixa Economica – Fernando Santos (1 Hour Lecture)
This presentation will discuss the results of real world tests using real world business applications of the ASE options for In Memory Database and Compression. The session will elaborate on performance gains and implementation tips/tricks and give the attendee a good idea where to use and not to use these options.
SAP ASE 16 and Future Directions – Ashok Swaminathan (1 Hour Lecture)
For the last three years, the SAP ASE engineering team has been hard at work delivering significant enhancements, most of which have been on wish lists of our customers for years. Features like incremental backups, shrinking database sizes, and online index creations and reorgs are just a few of the areas within SAP ASE that received significant investment. This session will provide you with key insights into the technology and business trends that are driving the SAP ASE roadmap over the course of the next 3-5 years. Where appropriate, specific features planned in the next couple of releases with be discussed in detail. You will also have an opportunity to express your business and technical requirements directly to SAP ASE Product team.
SAP ASE 16 in the Cloud – Sumit Kundu (1 Hour Lecture)
SAP Adaptive Server Enterprise’s (ASE’s) Virtual Server Architecture with built-in multi-tenancy is inherently suited to serve the needs of cloud computing environments. Supporting modern hardware architectures, SAP ASE 16 combines the power of scale up, in-memory support of hot data and synchronous replication to handle large number of users of applications in a private cloud that need extreme performance and a native HADR solution to ensure that applications are always available and data can be recovered in case of a disaster. This presentation will cover key SAP ASE capabilities that enable cloud computing and will also cover solutions by key partners to support Database-as-a-Service that enable developer productivity and hosting by Infrastructure-as-a-Service providers to reduce total cost of ownership of using SAP ASE in the cloud.
SAP Control Center. In Depth – Ricardo Murcia (2 Hour Workshop)
SAP Control Center is an centralized administration and monitoring tool for the SAP Data Management Platform covering the core SAP Data Management products including ASE, IQ, Replication Server, Data Assurance, and HANA. This session will demostrate how to configure SCC, register a resource, configure monitoring and alerts, authenticate the agent, and then perform administration tasks specific to each of the resources.
Tips, Tricks & Little-Known Features in SAP ASE – Rob Verschoor (2 Hour Lecture)
This presentation is Rob Verschoor's traditional roundup of useful SAP ASE-related topics that customers should know about, but have received little or no attention anywhere else. This presentation will look at a series of such features that will be useful to know for any DBA or developer working with SAP ASE.
Top 10 SAP ASE Configuration Tips – Jeff Garbus (1 Hour Lecture)
For both newer and more experienced DBAs, this session has a collection of tips and SAP ASE features that are underutilized / underconfigured. We reserve the right to add a few more than 10...
Troubleshooting and Tuning SAP ASE Statement Cache Query Performance – Jeff Tallman (2 Hour Lecture)
ASE 15.7 brought a lot of changes to the ASE statement cache. This session will look at some of those changes (such as plan sharing) and detail how to tune the ASE statement cache as well as troubleshoot query problems using statement primitives such as show_cached_plan_in_xml() and discuss the myths, limitations and realities of dbcc purgesqlcache.
Due to increase optimization costs, the use of the statement cache in ASE 15 was almost a necessity for many upgrades from ASE 12.5. In addition, the shared prepared statement enhancements added to ASE 15.7 not only was necessary to support SAP ERP systems, but also a critical resolution to a common app server performance issue with connection pools and statement cache. This session takes a look at the role of statement cache with fully prepared statements as well as adhoc SQL, discusses how to size/tune the statement cache as well as how to retrieve the statement text and statement execution plan from the statement cache, describes the impact of concurrent execution and shared plans and discusses how to effectively remove bad plans from cache. Session will cover show_cached_text(), show_cached_plan_in_xml(), show_condensed_text(), show_dynamic_params_in_xml(), dbcc purgesqlcache(), etc. as well as MDA tables monCachedStatement and monStatementCache.
Understanding Data and Index Compression in SAP ASE 16 – Peter Thawley (1 Hour Lecture)
As OLTP databases grow into the 10's of Terabytes, compression of both data and indexes becomes mandatory to maintain low TCO. In SAP ASE 15.7, we added data compression that uniquely balances storage savings with run-time performance. In SAP ASE 16, we extend this innovation to indices as well. This session will review the internals of SAP ASE compression for both data and indices while offering the best practices to enable DBAs to effectively balance the system for maximum performance at minimum storage costs.
SAP ASE users may also be interested in these sessions from the other tracks:
Best Practices using SAP ASE Windows Drivers – Paul Vero (2 Hour Lecture)
In this session we will cover best practices in using SAP ASE Windows Drivers (ODBC and ADO.NET) in regards to various applications, ranging from small customer applications to enterprise level. The session will break out via SAP ASE ODBC Driver and ADO.NET Provider. We will cover certain connection properties relevant to performance and optimizations and how to tune the drivers to achieve best results. Focus is centered on the use of new SAP ASE functionality implemented for use with SAP Business Suite but in terms of custom application development as well as use of Windows packaged services such as IIS and SSIS, as examples. These areas will be covered at low level in custom code to high level.
Building an ODBC Utility Library with SAP ASE ODBC Driver – Paul Vero (Half-Day Workshop)
The workshop will demonstrate how to build a Windows DLL using Windows Visual Studio (versions can be 2008, 2010, 2012) to be used for testing applications and learning ODBC API concepts. It's a hands on session where the library will be built, covering nuances of Visual Studio and some of my techniques I use to build such a DLL/Library. The second part will be dealing with creating an application and how to use it with our newly created library.
SAP IQ for SAP ASE DBAs - Joe Woodhouse (1 Hour Lecture)
This session is intended for absolute novices who know nothing about SAP IQ but plenty about SAP ASE or another traditional RDBMS.
So you know SAP ASE pretty well. How about this SAP IQ product? (And where does SAP HANA fit in?) There's a lot to learn and even more to unlearn to become effective with SAP IQ. Unfortunately most of your SAP ASE or general RDBMS instincts will not serve you well in SAP IQ-land. This session will give you enough knowledge to be dangerous! It will also help you better understand just how upside-down SAP IQ is compared to everything else you know.
Understanding and Building Applications with the Open Data Protocol (OData) for SAP ASE and SAP SQL Anywhere – Javier Cuerva (1 Hour Lecture)
OData (Open Data Protocol) enables data services over RESTful HTTP, allowing you to perform operations through URIs (Universal Resource Identifiers) to access and modify information. This session will cover the ODATA concepts and how SAP ASE and SAP SQL Anywhere provide Odata support in the current releases.
Use of SAP ASE ADO.NET BulkLoad capabilities – Paul Vero (1 Hour Lecture)
The SAP ASE ADO.NET Data Provider is capable of using bulk library-like capabilities to load data into the SAP ASE. This is achieved via the use of customer applications as well as the Microsoft SQL Server SSIS (SQL Server Integration Services). The lecture will cover the various levels of bulk loading, similar in effect to the bcp utility in Open Client. This capability will provide a means to effectively transfer large amounts of data from one database to another. SAP ASE is the target and source is typically SAP ASE or other databases in the case of mixed shops.
And don't forget the pre- and post-conference workshops:
Analyzing sp_sysmon – Joe Woodhouse (Half Day, Pre-conference)
sp_sysmon is seen as "old school" ever since the MDA interface was made available to SAP ASE users. There's still a place for sp_sysmon in the toolkit of every DBA, and even today there are questions that MDA cannot answer but sp_sysmon can.
This is a live ammunition exercise! Attendees are urged to submit a real sp_sysmon output from a troubled SAP ASE, suitably redacted to remove any sensitive server/device/database names. We will put them up on the screen and discuss them in a roundtable.
You'll receive half a day of analysis of sysmon after sysmon from one of the world's best SAP ASE performance & tuning people plus whomever else is in the roundtable. Expect some vigorous debate! Expect to be armed with ideas to try as soon as you're back at your workplace! Even if time doesn't permit analysis of every output file during the workshop, every attendee who submits an sp_sysmon output will receive a written report analysing it with suggestions for tuning and for further investigation.
Basic Installation and Configuration of SAP Adaptive Server Enterprise – Chris Baker (Half Day, Pre-conference)
This session will introduce a new DBA to installing and configuring ASE from scratch on Windows and Linux. Topics covered will include installation, configuration, connectivity, and tools. We will also cover common tasks such as creating and loading databases, ensuring a secure infrastructure, and ensuring operational continuity with backup & restore. While we will be using SAP ASE 15.7 for this workshop, the content should apply to all recent versions of SAP ASE with any exceptions noted by the instructor.
SAP ASE Quick Start for Oracle and SQL Server DBAs – Bob Barker (Full Day, Pre-conference)
This course is designed to provide an in-depth understanding of the architecture and administration of a SAP ASE server for medium and senior level DBAs. The course does not cover SAP Business Suite database server administration. It is designed specifically for Oracle and SQL Server DBA’s who are transitioning to SAP ASE database servers, or DBAs who have worked with SAP ASE in the past and need an update by providing the following information about successfully administrating SAP ASE:
- Organizational technology roadmap
- SAP ASE database expertise
This version of the training class has been specially edited for the ISUG-TECH. It is a one day, condensed course based on an established 3 day class that has been taught several times before.
Goals of the workshop:
- Provide Oracle and SQL Server DBAs a road map to learn SAP ASE database administration.
- Enable DBAs leveraging their native competencies to learn SAP ASE database server concepts.
- Highlight differences and similarities in Oracle, SQL Server and SAP ASE database administration.
- Provide in-depth knowledge of SAP Sybase ASE architecture and administration concepts.
- Provide hands-on opportunity to learn SAP Sybase ASE database administration in a trainer-facilitated setting.
Troubleshooting ASE Performance Problems using SAP ASE's MDA Tables – Chris Brown (Full Day, Post-conference)
This workshop will be an in-depth discussion of how to troubleshoot performance problems using SAP ASE's MDA tables. After attending this workshop you should be more comfortable using them to solve any performance problem you encounter.
In the workshop, we will be discussing SAP ASE's MDA tables, and how to troubleshoot common performance problems. We will focus specifically on the threaded kernel, and look at such areas as CPU, network, storage, and internal system events that can be diagnosed using them vs using sp_sysmon. Furthermore, we will explore how to diagnose and fix poorly performing queries, and show how to extract any running SQL with them.