SQL Server Performance

Getting Started with SQL Server In-Memory OLTP – Part 1

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 OLTP (codenamed “Hekaton”) is a powerful engine which is fully integrated into SQL Server’s Database Engine and introduces new data structures for optimizing the performance…

In-Memory OLTP Simulator: The Experiment

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 I developed, which allows the user to easily simulate virtually any workload against the powerful In-Memory OLTP Engine of Microsoft SQL Server. This paper presents a…

In-Memory Optimization in SQL Server: Will my Workload Execute Faster?

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). If I was about to describe this technology in two simple sentences I would do so with the below: It eliminates both locks and latches with…

In-Memory OLTP Simulator v1.0 Now Live!

After two years of heavy development, my tool “In-Memory OLTP Simulator” is finally out! In-Memory OLTP Simulator enables the IT Professional and Developer to easily test the powerful In-Memory OLTP Engine of SQL Server 2014® (or later) with different simulations and against different workloads. In the Ultimate Edition of the…

Introducing In-Memory OLTP Simulator

One of the key features shipped with SQL Server 2014 was the long-awaited In-Memory OLTP, codenamed as project “Hekaton”. In-Memory OLTP introduced new data structures for optimizing the performance of OLTP workloads. These data structures are called “memory-optimized” tables and along with natively compiled stored procedures, they can offer a…

Introducing In-Memory Optimization in SQL Server

In-Memory OLTP (codenamed “Hekaton”) is the most significant feature 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…

Updating SQL Server Tables Without Causing Blocking

Even though the SQL Server Database Engine automatically sets the best possible locking hints on the underlying database objects of the various T-SQL operations that executes, there are cases where we need to manually control locking as a part of the business logic in our T-SQL script. A popular locking hint…