Kordia has reduced processing times on its SAP-related databases by up to 70 percent by installing SQL Server 2012.
The telco was experiencing performance and stability issues with the database supporting its SAP business intelligence system. It was running the original SAP Max DB database.
Application development manager Gavin Martin says the database was not optimised for a BI environment. “It lacked compression, column-store table partitioning functionality and other features that could improve performance.”
As a result, it was taking managers 10 minutes to generate a report that should have taken 10 seconds to run.
“Our CEO couldn’t get the detailed analysis he needed fast enough to make business decisions,” says Martin.
Kordia engaged Tango Group, which specialises in SAP systems. Tango suggested Kordia migrate to Microsoft SQL Server 2012 Enterprise software.
The new solution supports 19 databases.
Data compression has enabled Kordia to compress the SAP environments by more than 50 percent; while the company’s total database size has been reduced from 2TB to 1.5TB. Kordia is also using back-up compression in SQL Server 2012 to reduce back-up times for all databases by 80 percent. Overall performance is 30 percent faster.