Development Performance Considerations Using Native Hekaton Code

Bogdan Alexandru Dumitrescu

While Hekaton, Microsoft SQL Server’s in-memory processing engine, is a powerful tool that can be leveraged in multiple applications, it still lacks love within the SQL community. The session intends to show some of the benefits of using native code and how to optimize it.

We explore alternative methods for mitigating page latches, relocating recursive queries within native stored procedures, selecting correct indexes, handling deletes and updates in a natively compiled stored procedure and – time permitting – other optimization topics.

By addressing these topics, this abstract provides insights into advanced optimization techniques tailored for Hekaton, offering guidance to database administrators and developers seeking to maximize the performance and scalability of their SQL Server deployments.