Improve the performance of SAP ABAP HANA with the help of MS SQL Server 2012
Being a SAP HANA ABAP developer involves critical skills and responsibilities, demands the professional to develop optimized applications. And if several advantages could be retained just by a migration, it is worth the effort. The migration is from SQL Server 2005 to SQL Server 2012. For new installations on SQL Server 2008 and above, compression of the database is the default and the results are quite impressive.
Saving Disk Space
The highest compression rates we"ve seen have been on the BW landscape, but broadly similar results have happened with ERP and PI as well. The general systems now require 50-80% less space than they did before the compression.
The benefits of the reduction are significant, not only in the potential savings in expensive database disk. Storage for additional pre-production or sandbox landscapes is now feasible, and refreshing QA more frequently is an easier proposition when you don"t need to move terabytes of data files.
Improvised Performance
About any database compression were that there would surely be an overhead for compression resulting in a performance decrease. The interesting thing is that as CPUs become more powerful, database compression can actually improve performance by reducing the amount of disk I/O.
As an aside, SAP HANA also uses compression for this very reason. While the headline performance improvement in HANA is from storing data in-memory and removing the disk I/O bottleneck, that moves the bottleneck to memory I/O. SAP realized they could use extra CPU power to compress the data flowing through the remaining bottleneck.
If you have a SAP instance installed on your database host, you can see the percentage of time the CPU spends idle in transaction ST06, under "Detailed Analysis Menu". If you see idle CPU time of more than 40% over a typical 24 hour period then you can potentially use the spare CPU to get a performance gain from SQL compression.
Row and Page Compression
Row compression is the first step as it uses a variable length to store rows of data, meaning you don"t waste space storing shorter rows without any extra CPU power required.
Page compression adds further compression on top of row compression, and uses extra CPU power to compress the pages of data. Page compression has been the default for new SAP installations on SQL Server 2008 upwards since May 2011.
Adopting new Hardware
As page compression is the default for new installs, you can migrate your SAP system with the latest tools and it will import with page compression already enabled with no additional work required.
Consider the age of your existing hardware, operating system and whether you want to make any other changes to your configuration and sizing of application servers and database host. Especially bear in mind you can also migrate to a newer SQL Server version if you need to, with no extra effort.
Find a course provider to learn SAP ABAP HANA
Java training | J2EE training | J2EE Jboss training | Apache JMeter trainingTake the next step towards your professional goals in SAP ABAP HANA
Don't hesitate to talk with our course advisor right now
Receive a call
Contact NowMake a call
+1-732-338-7323Enroll for the next batch
SAP ABAP on HANA Certification
- Jun 9 2025
- Online
SAP ABAP on HANA Certification
- Jun 10 2025
- Online
SAP ABAP on HANA Certification
- Jun 11 2025
- Online
SAP ABAP on HANA Certification
- Jun 12 2025
- Online
SAP ABAP on HANA Certification
- Jun 13 2025
- Online
Related blogs on SAP ABAP HANA to learn more
How to ensure quality of a SAP ABAP HANA code?
The SAP HANA runs billions of ABAP code created by several SAP HANA developers across the computer systems of the customers around the world.
Why SAP ABAP HANA Is Considered Best For Next-Generation Apps & Analytics?
An in-memory platform, SAP HANA appears to run analytics application smarter, data infrastructures simpler and business processes faster. It is the foundation for all our data requirements, eliminating the burden of having to maintain separated legac
Understanding on SAP ABAP CDS and HANA CDS
Core Data Services, known for “one concept, two flavors” by the SAP community around the world, is an incredible infrastructure to define and consume various rich data models available in SAP HANA. At the same time, ABAP CDS also trending for its con
Accelerated Reports with SAP HANA ABAP Custom Code!
It is a globally acknowledged fact that the SAP HANA started revolutionizing the business world with its incredibly fast enterprise management solutions. SAP ABAP powered by HANA is yet another powerful platform for programmers to create complex and
When SAP HANA Unites ABAP– The Best of Both Worlds
ABAP is the foundation for numerous SAP applications, having a wide range of functionality and features to create powerful business solutions. Likewise, SAP HANA also provides an opportunity to introduce advanced, sophisticated technologies. Using su
Latest blogs on technology to explore
What Does a Cybersecurity Analyst Do? 2025
Discover the vital role of a Cybersecurity Analyst in 2025, protecting organizations from evolving cyber threats through monitoring, threat assessment, and incident response. Learn about career paths, key skills, certifications, and why now is the be
Artificial intelligence in healthcare: Medical and Diagnosis field
Artificial intelligence in healthcare: Medical and Diagnosis field
iOS 18.5 Is Here: 7 Reasons You Should Update Right Now
In this blog, we shall discuss Apple releases iOS 18.5 with new features and bug fixes
iOS 18.4.1 Update: Why Now is the Perfect Time to Master iPhone App Development
Discover how Apple’s iOS 18.4.1 update (April 2025) enhances security and stability—and why mastering iPhone app development now is key to building future-ready apps.
What is network security Monitoring? A complete guide
In the digital world, we have been using the cloud to store our confidential data to register our details; it can be forms, applications, or product purchasing platforms like e-commerce sites. Though digital platforms have various advantages, one pri
How to Handle Complex and Challenging Projects with Management Skills
Discover actionable strategies and essential management skills to effectively navigate the intricacies of challenging projects. From strategic planning to adaptive problem-solving, learn how to lead your team and achieve exceptional outcomes in compl
What are the 5 phases of project management?
A streamlined approach to ensure project success by breaking it into five essential stages: Initiation, Planning, Execution, Monitoring & Controlling, and Closing. Each phase builds on the other, guiding the team from concept to completion with clear
About Microsoft Job Openings and Certification Pathway to Explore Job Vacancies
Explore exciting Microsoft job openings across the USA in fields like software engineering, data science, cybersecurity, and more. Enhance your career with specialized certifications and land top roles at Microsoft with Sulekha's expert courses.