HyperV Sql issue

Question

hi all,

I have one issue asking for help. We had Windows 2019 SQL server with KVM and when I was running any Query it was taking time 13 sec around, Now we have moved the VM to HyperV 2022 and when i run query of the same table its executing 32 sec with same or higher configuation of the VM, Kindly help what I can do so that it will be fixed ?

Thanks

Answer 1

Hello there,

How is the networking performance on the host?

We might need more information to move further with the troubleshooting steps.

Can you share the exact error message or Event ID you are getting?

If you cannot find anything in Event Viewer I would suggest you use tools like Procmon to find the root cause for this behaviour.

Any checkpoints on them? These will not help latency

Your virtualized desktop, you have a VDA licence for that right?

You have also checked the switch they connect to?

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer–