What’s in memory technology?
In memory processing depends on data in RAM to boost database performance. Generally, data makes its way from storage to the processors. In memory cuts the route short and makes data readily available within the server’s own memory bus.
Rohan Kumar, general manager of Microsoft’s Database Systems group, has written in a blog post :
In-memory technology helps optimize the performance of transactional (OLTP), analytics (OLAP), as well as mixed workloads (HTAP)…These technologies allow you to achieve phenomenal performance with Azure SQL Database—75,000 transactions per second for order processing (11X [performance] gain) and reduced query execution time from 15 seconds to 0.26 (57X [performance gain]).
The offer can be availed by Microsoft Azure SQL customers with Premium database tier subscriptions. How many of you are already on Azure?