Skip to Content

In my previous blog (How to Decrease Your SAP Database Size?) I gave all known options to decrease the Total DB size of SAP Solutions. The fastest and may be the cheapest method is using an alternative database software.

The Dino’s in IT still doesn’t believe in databases other than Oracle, but nowadays it is easy to say that they are wrong. With the 64-bit technology evolution, all databases performs quite well.

This weekend, in Turkey,  at one of the biggest Retail customers, we did an export and import of ERP production system which is already running Windows 2008/Sql Server 2008. But their database doesn’t have ROW and PAGE compressions.

So we decided to export and import the database to lower DB size.

Results

Total DB Size (prior to operation): 5200 GB

Total DB Size (after SQL 2008 R2 conversion*): 1000 GB

Export/Import Duration (done in parallel): 60 Hours

Space BeneFIT: ~ 81 %

—————————

* SQL 2008 R2 Conversion: Here, the meaning of conversion is exporting the database and importing again on a SQL 2008 R2 version database with latest SAP Kernel 7.0 to enable ROW and PAGE compressions.
To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

    1. Hüseyin Bilgen Post author

      Hi RT,

      Good point and we have an answer 🙂

      The customers SQL Datafile distribution and file sizes, even the datafile number has to be organized. That’s why decided to export/import.

      (0) 
      1. Ramesh Thalluru

        So export/import is the only way to distribute the data evenly among the data files?

        What tool do you use to export/import? System copy procedure?

        (0) 
        1. Hüseyin Bilgen Post author

          Hi again,

          We used standart SAP System Copy Tools for Export/Import.

          Using System Copy Tools is the easiest, standart and fast method to meet these requirements.

          (0) 
  1. Simon Ahuja

    Hii..
    even I had reduced the size of my ERP 6.0 EHP5 system by 71%…
    The application is awesome…
    It is not possible for me to take export-import as a downtime for ERP is not possible…
    I hav read about shrinking datafiles… and creating primary index after tht…
    has any one done this before.. ??

    (0) 
    1. Hüseyin Bilgen Post author

      Hi,

      Yesterday I did use MSSCOMPRESS report to compress tables & indices on our IDES server. We’ve Windows 2008R2 and SQL 2008 R2 with 180 GB (%0 free) Database. The tables have ROW compress so we expect %40-%50 reduction in DB size before we started. We ran the report in background and it finished in 12 hours. The DB now have 94 GB free space (%52). We’ll shring the datafiles to save disk space.

      (0) 

Leave a Reply