DBInsight's Blog

Archive for VMware

VMware Snapshot Kills Availability Group Cluster

Recently I was requested to investigate the Cluster failures underlying a SQL Server 2012 Always On Availability Group. The topology was a two node Windows 2012 cluster with a file share tie breaker as part of the Majority Node and File share Quorum model. The cluster servers were VMware 5.1 Guests and SQL Server 2012 […]

Continue Reading →

Posted in: Availability Group, Cluster, High Availability, VMware

Leave a Comment (2) →

Host vs VM Guest Performance Counters, which is right?

I thought it would useful to highlight to readers that there can be differences in what a VM Guest performance counters show verses similar counters presented by the VMware performance charts. The following articles provide an insight into some of the discrepancies you may face. The first article Virtualization resource consumption counters lie to you […]

Continue Reading →

Posted in: Performance, SQL Server Monitoring, VMware

Leave a Comment (0) →

Is your SQL Server VM sluggish? Then Check out the VMWare CPU Ready %

On numerous occasions I’ve had customers complain about intermittent SQL Server performance only to find that the root cause was not the workload generated by the SQL Server VM but that the VMware environment was oversubscribed and was not providing sufficient CPU resources to the SQL Server when required. In most cases I was able […]

Continue Reading →

Posted in: Performance, SQL Server Monitoring, VMware

Leave a Comment (0) →