We have a question regarding our SQL server within the VMWARE in VSphere ESXi enviroment.. We have been experiencing some performance issues in the last 2 days with the SQL server. In our VMware ESXi 5.5 environment. The server is provisioned for 585GB and has 422 GB used.
Wednesday night the server seemed to be stuck in a ''Remove snapshot" task that took over 24 hours. Thursday morning we tried consolidate virtual machine disks at 9:00am usually this process doesn't take very long but at this time it seems to move 1% every 15-40 minutes. The process is currently at 66%. I tried to remote into the server around 5/1/2020 at 12am and I found that the system process had the CPU was pegged at 94-97%. I tried to see if I could kill any non-SQL Process and or try to shut it down and unfortunately I was booted from the remote session. We also tried to console into the server via the VMWARE Vsphere client and we are unable to. We are not able to even shut down or reboot the SQL sever since our options are greyed out.
Since this is still running at 66% at consolidating virtual disk files, we have no choice but to let the process run its course OR we put the ESXI host that the SQL server is on into Maintenance mode and then shutdown the host to see if the server can gracefully shutdown. We 're not sure if this would cause more problems at this point and want to now if you have any suggestions.
Datastore resides on an ISCI drive.