Speed Tip: Apply In-Memory Capabilities

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.

Senturus Upcoming Events

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:

SERVERPROPERTY(‘ProductVersion’) AS ProductVersion,
SERVERPROPERTY(‘Edition’) AS Edition,

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.

Connect with Senturus

Sign up to be notified about our upcoming events

Back to top