I've posted two blogs on testing methods of reducing page latch contention. I set up some tables for testing here (www.sqljared.com/blog/page-la...), then tested several approaches and provided results here (www.sqljared.com/blog/page-la...). #sqlfamily #sqlblog
sqljared.com
Page Latch Testing - sqljared
I want to test some methods for eliminating page latch waits. Let's set up a test environment with a few tables and make sure we get the waits we expect.