Jared Poche continues a series on page latches:
In my previous blog, I set up a database with two tables, one with a large CHAR(8000) field and one with a smaller VARCHAR(100) field. Both tables use an INT IDENTITY column for their primary key. Since we’ll be inserting rows sequentially, we will see page latch contention when multiple threads attempt to insert.
We ran some initial tests with SQLQueryStress to create some page latch contention and resolved an odd problem causing connection delays.
We’ll use these two tables and test several different approaches to reduce page latch contention.
Jared shows the results for a variety of different tests and even has an embedded Excel spreadsheet, which is how you know he’s done his homework.