This post is in response to a question asked via a comment on my Diagnosing Spinlock Problems By Doing The Math post. As a general rule of thumb spinlock activity should be investigated when: CPU utilization is […]
In this post I will look at the parallel insert in whole and in particular the affect that bulk extent allocation can have. Here are the key takeaway points from the series so far: Takeaway […]
In this blog post I’m going to outline a very simple technique for working out whether spin lock activity is the cause of excessive CPU consumption. What is A Spinlock ? A spinlock synchronizes access […]
This post is continues the series on how I hope to squeeze every last ounce of performance out of my hardware when using SQL Server’s parallel insert feature. Given that my ioDrive and SanDisk SSDs have […]
