You can change your clustered primary key to Non-clustered Primary Key and can get the benefit of performance by reducing Pagelatch_EX.
I was working with a DBA and he asked me question if thee any way to Add Folder Paths to the Windows Path Variable for Easy Access.
One of the things which we cover in my Comprehensive Database Performance Health Check is how to do Load Testing or Stress Testing with oStress.
I have personally implemented the solution suggested of resolving contention about creating an index with OPTIMIZE_FOR_SEQUENTIAL_KEY at my client’s place.
Today’s goal is to understand what is the Last Page Insert PAGELATCH_EX Contention Due to Primary Key. Let us start understanding it together.
Today we will talk about the Tecovery Model on Insert Workload Stress Test and Wait Statistics. I had earlier consulted for during Health Check.
It seems my blog post about oStress has got lots of popularity. Recently I got the question about Wait Statistics Generated by oStress Insert Workload.