In the previous chapter, you learned how index in general can help your queries run faster. But indexing has its limitations. When your I/O subsystem is not performing well in combination with less RAM, then indexing is just a first aid. All these problems will return later with much higher intensity.
Simply adding more RAM, faster disks, and better CPU will solve your problems temporarily. The system will breathe better, but you must ask yourself is this it or can I push the limits sky high? Yes, you can. It is amazing what SQL Server can offer you in terms of achieving better performance.
In this chapter, you will get the basics on how to implement In-Memory OLTP on SQL Server on Linux through the following topics:
- Elements of performance
- What is In-Memory OLTP
- Implementation