Rohan Kumar, the General Manager at Database Systems Group, has taken to the Microsoft Azure blog to showcase the ways which In-Memory technology brings remarkable performance to Microsoft’s Azure SQL Database.
Overall, Rohan highlights that in-memory technology allows you to achieve phenomenal performance with Azure SQL Database, reduced query execution time, and increased performance and reduced cost. He describes a few of these performance enhancements as follows:
- In-Memory OLTP increases throughput and reduces latency for transaction processing. Scenarios such as trading and gaming really see the performance benefits. Another common scenario is data ingestion from events or IoT devices. You can also use it to speed up caching, data load, and temp table and table variable scenarios.
- Clustered Columnstore Indexes reduce storage footprint (up to 10X) and improve performance for reporting and analytics queries. Use it with fact tables in your data marts to fit more data in your database and improve performance. Use it with historical data in your operational database to archive and be able to query up to 10 times more data..
The post also addresses how several groups have been using In-Memory Technology and Microsoft’s Azure SQL Database. First up is Quorum, which was able to grow their business by onboarding new customers and supporting organizations at much larger scale, without spending more on more database throughput. Second is Quest, which was able to speed up the processing of requests and events. Third is M-Files which was able to allow its customers to gain insights and find information much faster.
For more details, be sure to check out the full post on the Microsft Azure Blog. And, while you’re at it, check out the SQL In-Memory documentation. Once you’ve checked it out, let us know what you think by dropping us a comment in the section below!Further reading: Azure, Azure SQL Database