In this article, we are presenting our new course titled “Boost SQL Server Database Performance with In-Memory OLTP” and explain how can the course help you, significantly improve the performance of your SQL Server-based data processes. What is In-Memory OLTP in SQL Server? In-Memory OLTP, is SQL Server’s powerful In-Memory Optimization Engine, which is … Read more…
In my previous article of this blog series, I introduced SQL Server In-Memory OLTP and explained how it is possible to create an In-Memory OLTP – enabled database. Also, I showed via simple examples, how easy is to create memory-optimized tables (durable and non-durable). Today we are going to talk about naively-compiled stored procedures as well … Read more…
SQL Server In-Memory OLTP (MS Docs article) is a powerful engine integrated into the SQL Server Engine (version 2014 and later), optimized for Online Transaction Processing (OLTP). This article helps you getting started with SQL Server In-Memory OLTP and it is the first part in a series of articles focusing on SQL Server In-Memory OLTP. … Read more…
A few days ago I published a 38-page technical paper titled “In-Memory OLTP Simulator: The Experiment“. In-Memory OLTP Simulator is a software tool that we developed, which allows the user to easily simulate virtually any workload against the powerful In-Memory OLTP Engine of Microsoft SQL Server. What Does the Paper Discuss? This paper presents … Read more…
Please read below for In-Memory OLTP Simulator Frequently Asked Questions (FAQ): What is In-Memory OLTP Simulator? In-Memory OLTP Simulator is third-party tool that allows the user to easily create and run scenarios with different workloads against the In-Memory OLTP Engine of SQL Server®. What is a Simulation Scenario? A simulation scenario is a set of … Read more…
In-Memory OLTP in SQL Server 2014 or later is a powerful engine integrated into the SQL Server Engine, optimized for Online Transaction Processing (OLTP). In-Memory Optimization in SQL Server, has certain characteristics and can help increasing performance in a great number of scenarios. A Short Description of the SQL Server In-Memory OLTP Technology If I … Read more…
Introduction to SQL Server In-Memory Optimization In one of my previous articles I briefly introduced In-Memory Optimization in SQL Server. In this article we will conduct a simple experiment utilizing this new technology and discussing the benefits. The experiment will be organized in the following steps: Create the In-Memory processing enabled database Create the tables … Read more…
In-Memory OLTP (codenamed “Hekaton”) is the most significant feature originally shipped with SQL Server 2014. It is Microsoft’s new technology which is fully integrated into SQL Server’s Database Engine. In-Memory OLTP introduces new data structures for optimizing the performance of OLTP workloads. These data structures are called “memory-optimized” tables and along with natively compiled stored … Read more…
A few days ago, on March 21st, I participated as an invited speaker at Microsoft Conference 2014 that took place in Nicosia, Cyprus. My session was on SQL Server 2014 and specifically about what’s new in this release of SQL Server. My session’s agenda was on the following areas of new features on SQL Server: … Read more…
