You can change your clustered primary key to Non-clustered Primary Key and can get the benefit of performance by reducing Pagelatch_EX.
SQL SERVER – Last Page Insert PAGELATCH_EX Contention Due to Identity Column
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.
SQL SERVER – Impact of Recovery Model on Insert Workload Stress Test and Wait Statistics
Today we will talk about the Tecovery Model on Insert Workload Stress Test and Wait Statistics. I had earlier consulted for during Health Check.
SQL SERVER – Wait Statistics Generated by oStress – Insert Workload
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.
SQL SERVER – Performance Test – sqlcmd vs SSMS
I have received an email from my clients of Comprehensive Database Performance Health Check. The question was about Performance Test – sqlcmd vs SSMS.
SQL SERVER – Performance Test – oStress vs SSMS
The senior DBA there wanted to know what would be the performance improvement if they use oStress vs SSMS. Let us learn today.
SQL SERVER – Stress Testing with oStress – Load Testing
Today, we will be discussing the scenario where I did Stress Testing with oStress. Let us learn about that in today’s blog post.