There are options to making an existing SAP BW quicker including, but not only, SAP HANA. The question is what do you want to speed up and what is it worth to your organization? I often hear that a query runs too long, but then I find that the person who reads the results doesn’t pick up the report for days. Putting query on SAP HANA so it runs in 3 seconds doesn’t return any value if someone who cares about the result doesn’t read it for 3 days. To take advantage of the 3 second turn around you need to modify the business process so it is near real time as well.
Speed and speed of information delivery is increasingly important in our more competitive 7×24 world. We all want to go fast, be speedy, and highly responsive, but we need to spend the company’s money wisely. Here is a range of options to consider and evaluate just assuming you really require that speed.
The most overlooked area for speeding up BW is good housekeeping. First look to see if you have lots of unused data. Are you loading items no one uses or running reports no one looks at. Back in the manual distribution of printed reports days, I put an orange stop letter inside the first page of 300 reports saying if you didn’t call us, we’d stop the reports. I stopped about 280 reports from running the next week and only one person called to complain and ask for their report. I had a lot more cycles for those the remaining reports and saved a small forest of paper, ink, effort, and money.
Tuning as part of housekeeping is important. I’ve seen savings of 40% of server capacity at one of my clients through aggressively hunting down poorly performing programs, tables, and indexes. A good performance SAP Basis person with OS and DB knowledge can identify and tune some of it. You do have to follow through with making programming changes, so be sure to prioritize and budget the required development resources.
While housekeeping is not as sexy as HANA, it is important. Check to see if your company has a good housekeeping checklist for its SAP systems since it applies to more than just BW.
What if you could speed up any database under SAP? FLASH is an option that enables any database to run quicker by simply moving your disk based storage files to FLASH in just a few hours. There is no migration or optimizations required. It runs with all your existing equipment.
A lot of time used in SAP in general, and specifically in BW, is accessing the database on the disk. HANA is an in-memory database for the same reason. What if you could put a traditional database in memory so it will just run faster. Previously, this meant using large caching devices in front of storage arrays. Caching works well if you have small amount of data relative to the entire database that you access frequently. It does not help with any long, sequential actions like restoring a table or backups. Large caches are an excellent way to allow you to exploit lower cost disk, but has limits.
More recently, speeding up storage meant including some or all of the data on Solid State Disk (SSD). SSD’s are significantly faster, but most solutions involved some percentage of the array using SSD’s in combination with cache. While larger than the cache, SSD’s were rarely used for the whole database and SSD memory is non-volatile meaning it doesn’t lose its storage when the power is removed. Flash is similar in using NAND based memory, but faster. FlashSystem uses some RAM for write buffering, clients can rest assured knowing that FlashSystem includes redundant and hot swappable batteries to provide the power needed to flush these buffers before shutting down gracefully. FLASH is considered as safe and reliable, or more, as standard arrays and disks.
IBM FLASH is NAND and is very, very fast. More importantly works at speeding any traditional database like DB2, Oracle, or Microsoft SQL. Clients are seeing real, measurable improvement in their SAP systems.
- Over 400% improvement in response over disk only
- Over 150% better CPU utilization
- 75% lower operational costs
- 2-4x overall performance improvement for critical month-end batch process
- Critical application was improved from 2.5 hours to 6 minutes of processing time
FLASH, or any memory based disk, has to be installed correctly. It has to have a Universal Power Supply (UPS) to make sure it doesn’t go down even for microsecond. It is more expensive than standard disk and SSD, so you might elect to use it with critical table spaces or logs. It can even be utilized as the disk storage for SAP HANA based systems.
Beyond just improved performance, the FLASH disk are providing savings in power and with improved server performance, it can enable substantial savings on database licenses due to increased CPU efficiency assuming your license costs are based on a per server cost common to many Oracle Enterprise licenses. FLASH is one option you should consider that works with all databases and doesn’t required modifications of SAP or a database migration.
IBM DB2 BLU:
What if you could speed up your IBM DB2 database under SAP? DB2 BLU is a free option for users of DB2 10.5 to exploit with BW. It enables you to move some or all of your tables into the computer’s memory. IBM DB2 BLU is executing long-running SQL queries shortened on average, by a factor of 8x to 25x and storage compression savings of up to 10x over systems with uncompressed data. Like FLASH, you would now be using that very fast RAM for storage. Like FLASH you need to make sure your computer has UPS protection and will write out to some sort of non-volatile storage when the power is shut down.
It has the advantage of not requiring you to re-write or migrate your applications to gain the speed of an in-memory database. It provides world class support for SAP and non-SAP applications from the inventor of relational databases. IBM DB2 and SAP started with R/3. DB2’s history is founded on IBM Fellow Dr. Codd’s work on System R in the 1970’s and has been product since 1983. IBM has long, rich heritage as database company.
Today, DB2 BLU is only certified for use with columnar stores in a SAP BW 7.3 system and for the associated Near Line Storage (NLS). NLS is used age data out of expensive storage, in this case in-memory, to slower, less costly storage. IBM is continuing to work with SAP on how SAP can utilize more of the power of DB2. Specifics for SAP DB2 BLU are in SAP Online Support System (OSS) note #1819734 . I’d keep an eye on it. You may see some new capabilities emerge in the near future.
If you are not on DB2, why would you migrate to it? Again, migrations are not cheap, easy or without risk. While HANA might be your choice for SAP, HANA does not run the 100’s or even 1000’s of commercial applications at your company; whereas, DB2 will run most. Some clients want to have everything on a single database technology. You also might not be interested in putting all of your SAP applications in memory (various reasons), your company is a late adopter of technology, your system will not fit in the HANA Intel architecture limitations, or you want to be able to run your database on non-Intel based systems. IBM DB2 remains a very good and economical way to run your SAP systems and potentially a way to speed up your SAP BW system.
SAP HANA is an excellent way to speed up your BW system. HANA is SAP’s in-memory database for SAP and non-SAP use. It currently only runs on Intel based servers running SUSE Linux. It must be run on certified hardware configuration on premise or on a cloud provider. It can run on the VMware hypervisor only and only for non-production. It works with BW, but also works with most SAP systems which is referred to as Suite on HANA (SoH). SAP has a clear, articulate roadmap of where HANA works today and in the future. SAP continues to provide new optimizations and high value features for business via HANA. HANA is the database of choice for SAP and is critical to SAP’s current and future strategy as an application and as company.
The question is SAP HANA critical to your company and meets the business case. IBM’s SAP practice has helped many clients implement HANA for solid business reasons and with great success. I believe it will continue to become easier to implement and more valuable over time. SAP is building some highly compelling business capabilities. Assuming SAP’s continued investment in HANA, for most companies, it is not question of “if HANA”, but “when HANA.” Eventually, some or all of your SAP applications will want to be on the SAP HANA bus.
I’ll go deeper on SAP HANA in a future blog entry on HANA. I offer it here for completeness. There is plenty of material online for your consideration. SAP’s SAP HANA website is good (see above). I often consult Jon Reed’s blog as a starting point. Jon is an outspoken proponent of SAP HANA.
For most companies, SAP BW is a critical data store, data warehouse, and a source for SAP analytics, operational, and business reporting. Speed and speed of information delivery is increasingly important in our more competitive 7×24 world. You owe it to your company to see how some, or all of these options, might give your company the information edge over the competition.