SQL Server, as with other modern database engines, is designed to work on servers with a large number of CPUs. It has many optimizations that help the Engine to scale and efficiently work in such environments.
This chapter will discuss one such optimization: lock partitioning, which is automatically enabled on servers with 16 or more logical CPUs.
Lock Partitioning Overview
As all of us are aware, hardware costs are dropping over time, allowing us to build more powerful servers. Twenty years ago, database servers used to have just one or very few CPUs. ...
