Which Processes are waiting on a Spinlock?

Spinlock contention is always a real headache to deal with. I recently saw an issue when spinlock contention on SOS_CACHESTORE was making the server virtually unresponsive. The issue was very intermittent with no obvious pattern but the assumption is that it was caused by a particular process in the application. Finding what that process was... Continue Reading →

Inspector 2.1 now available

As always all updates can be found on our Github repo Breaking changes (Powershell collection): We only test the powershell collection against 2-3 servers so please test carefully before rolling out changes especially if you are centralising more servers than we do. Unlike the SQL based agent collections we would recommend running the powershell collection... Continue Reading →

What if it all grows out?!

The other day I got thinking about what would happen if all databases on a single instance grew out, every single one of them! but not just once, what if they all grew out three, four or fives times overnight - what would things look like? Well I know the likelihood may be slim but... Continue Reading →

Create a website or blog at WordPress.com

Up ↑