I came across an oddity in the transaction log when I was testing Availability Group backup scenarios which really had me confused.   It required some help from my colleague Denzil and a few others to figure out what was going on.   This adventure ...read more

Resource Governor is an extremely cool and powerful feature that, when implemented, can manage the consumption of CPU and memory resources.   I will not be going into the details of Resource Governor, or even how to set it up as this is extensively ...read more

High CPU Troubleshooting with DMV Queries Scenario: Recently, a customer called Microsoft Support with a critical performance issue that I worked on. Their SQL Server instance had 100% CPU utilization for a period, but the problem stopped without ...read more

With the more recent releases of SQL 2012 and Windows 2012, we are seeing the landscape of available options for SQL HA/DR specific architectures is improving significantly. Below is a summary of the high availability and disaster recovery solutions available ...read more

We have been troubleshooting a customer’s case and uncovered a GC behavior with SQL Server CPU affinity that is worth sharing here in a blog. Problem Customer reported that they had two instances of SQL Server 2008 running on a two-node cluster.  ...read more