The upcoming sections are going to show you some useful scenarios for In-Memory OLTP usage. The sections are designated as walk through examples. We will work with a large amount of data into In-Memory, then we will change the scope to heavily updated data, and in the next exercise we will add a system versioning feature. In the last example we will divide OLTP and OLAP workloads to cooperate in separate areas on top of quickly incoming data.
In-Memory OLTP usage scenarios
Assignment of the user story sample
To provide a consistent use case, we will use an imaginary water management company. Such companies have geographically spread tube networks delivering water across a whole region. The network has to be monitored...