Let's take a closer look at how we can speed up the system's performance using the Buffer Pool Extension. For testing I will use a virtual machine with 4 GB RAM. I created a separate database with one table. The table has 2 columns [id] and [n]. The first column contains integer data type. This column is the primary key with a clustered index on it. The second column simply presents any data in the system.

The case describes how Forrards helped a leading business cloud vendor who provides hosted mail, file sharing, VOIP solutions to improve business intelligence and put into order the abandoned ETL which was not properly documented and supported, and that jeopardized overall performance of the business.