top

Azure SQL Premium gets In-Memory Capabilities

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.
Rated 4.0/5 based on 20 customer reviews
Normal Mode Dark Mode

Azure SQL Premium gets In-Memory Capabilities

Susan May
What's New
14th Nov, 2016
Azure SQL Premium gets In-Memory Capabilities

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.

Susan

Susan May

Writer, Developer, Explorer

Susan is a gamer, internet scholar and an entrepreneur, specialising in Big Data, Hadoop, Web Development and many other technologies. She is the author of several articles published on Zeolearn and KnowledgeHut blogs. She has gained a lot of experience by working as a freelancer and is now working as a trainer. As a developer, she has spoken at various international tech conferences around the globe about Big Data.


Website : https://www.zeolearn.com

Leave a Reply

Your email address will not be published. Required fields are marked *

SUBSCRIBE OUR BLOG

Follow Us On

Share on

other Blogs

20% Discount