I have some SQL servers running on Nutanix without using ‘Flash’ mode for those. I am facing disk latency alerts for vmdisks on those SQL server VMs. Is there any way to identify if the VM disks are on HDD or SSD?
Best answer by ddubuqueView original
You can click on VM, select I/O Metrics, scroll down and look at Read Source.
Going to the VM and looking at the I/O metrics will give you a lot of information pertaining to Read/Write distribution on disk, as well as the type of writes. If doesn’t give long term I/O metrics, but if you’re seeing alerts, you can watch this and get an idea of what’s going on.
Few recommendations as we run numerous MS-SQL servers on AHV and ESX clusters on hybrid clusters.
The Wait is Over: AHV Turbo is Here! | Nutanix Community
SQL Server Index Architecture and Design Guide - SQL Server | Microsoft Docs
Thank you mikkisse and ddubuque, I appreciate your responses and the details provided. I will check this.