Microsoft has announced the In-Memory capabilities for the Azure SQL, which is aimed to accelerate the database performance.
In the existing system, the data which is required has to be fetched from the storage components and has to be provided to the server’s processor, which is less efficient and comparatively slower than the current system. The newer In-Memory capabilities will be able to fetch the much faster since the server will be having its own memory bus with faster data transfer speeds.
In order to accommodate massive amounts of data, a large amount of system memory, which are in terms of terabytes are used. For example, 16TB of RAM is used in the scale-up configuration of the SAP HANA, a ConvergedSystem 900 systems by Hewlett-Packard Enterprise's (HPE).
Rohan Kumar, general manager of Microsoft's Database Systems group stated that customers of Azure SQL Premium database tier will be getting a big performance boost due to the new In-Memory capabilities. It was also stated that customers can access the data at higher speeds with no extra cost. For example, Up to 10x faster data speeds can be gained by the customers who are under P2 database plan.
Along with the performance boost for data speeds, the new system also includes some extra features, such as Online Transaction Processing (OLTP), which enables higher data throughput enabling rapid data ingestion and high-speed trading from IoT devices and another feature called as Clustered Columnstore Indexes, which accelerates the analytics and reporting workloads by increasing the data storage footprints up to 10x.
Competition is expected from SAP, which has plans to release an incredibly fast database which is expected to have bring-your-own-language capabilities along with new AI algorithms, helping developers to build a new generation of intelligent applications.