When it comes to building software, our end users are the key to what we build. Most developers and project managers will focus on the use cases are for their software. So whatever is done, it is seen from the eye of the user. Likewise, when a database professional gets deployed into a customer location, they may hear comments from […]
Read More
Disk contention occurs when multiple processes try to access the same physical disk simultaneously. Learn how to avoid disk contention.
Read More
Hot blocks are a common cause of cache buffers chains latch contention and can significantly impact performance. Learn some workarounds for this.
Read More
Contentions for the shared pool and library cache latches are mainly due to intense hard parsing. Learn mroe about how this impacts performance.
Read More
Running SQL Server in a virtualized environment can introduce both good contention and bad contention, and it’s critical to understand how this can impact performance.
Read More
Use of SQL Server tempdb as temporary storage makes it likely to contain a disproportionate amount of creation and destruction of many small objects, which can lead to latch contention.
Read More
Higher than normal wait stats does not in and of itself indicate a contention problem. You should look for the proportion of wait stats compared to others, and compare this to the throughput being achieved.
Read More
It’s important to recognize SQL Server latch and spinlock contention, and to be able to measure contention to determine the best possible tuning.
Read More
If your transactions per second figure is dropping as you enable extra processor threads, and your average latch waits are increasing at a rate greater than the throughput, you may have latch contention.
Read More