Step 3 – Logon to the VM to identify the issues.Ī glance at the Virtual Machine we can see that the SQL Server Service is consuming almost all the available RAM. The highlighted instance is our SQL Server, and we can see that it is maxed out on memory. So, if none of my VM’s are running away and my CPU looks fine what’s next. We have ordered more RAM to solve this issue. What it means is that we are oversubscribed and cannot perform automated maintenance like Cluster Aware Updating because there isn’t enough memory to move over to the other nodes. Note: We do have one issue which is the Percent of RAM 74.2% is not good for this 2 x Node S2D Configuration. What I noticed right away is that my CPU looks fine only 16 % utilized and none of my VM’s appear to be running away.

Step 1 – Open Windows Admin Center and browse the Virtual Machine Summary Tab.

We had a call come in from a customer today that their SQL Server in production was running a bit sluggish on our all flash (NVME) S2D Cluster.

Today, I wanted to write a very quick post showing how you can use Windows Admin Center to quickly diagnose issues with poorly performing Virtual Machines on a Storage Spaces Direct Cluster.

Windows live admin center