Speed Tip: Apply In-Memory Capabilities

    Business Strategy & Perspectives

Clock Image

Senturus recommends to our clients that they implement in-memory capabilities in the relational databases they are using for their data warehouses. By doing so, they can see some serious improvements in reporting response time. It takes less than a few hours to do and, in our experience, requires no changes to existing models or reports.

Among our clients, SQL Server is the most common relational database and its in-memory capability is called Columnstore Indexes. We implemented them in various situations and saw some report execution times drop from 6 minutes to an impressive 2 seconds. Recently, we executed them for an outdoor apparel retailer client and are seeing sub-second response times with relational DMR package queries. 

Columnstore Indexes are available in SQL Server 2012, 2014 and 2016. They are only available in the Enterprise Edition. You can check the version and edition with these SQL statements:

SELECT
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('Edition') AS Edition,
GO

Version Pattern

SQL Product

12.0. x . x

SQL Server 2014

11.0. x . x

SQL Server 2012

10.50. x . x

SQL Server 2008 R2

10.00. x . x

SQL Server 2008

In DB2, the edition you’ll want is DB2 with BLU Acceleration.

In Oracle it’s an Enterprise Edition option called (surprisingly) Oracle Database In-Memory.

Happy Speeding! To learn more on the subject, check out our webinar: Demystifying In-Memory Technologies.

/