This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 54%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
hi all,
I have one issue asking for help. We had Windows 2019 SQL server with KVM or vmware 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
Is that one single query that is running slower, and all other queries have retained their execution times? In such case, it more sounds to me that there has been a change of query plans, than an effect of that you are now in Hyper-V.
Do you have Query Store enabled on this database? And if you have, did you have it enabled before the migration?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @Partha Goswami
Here is a document for troubleshooting sql server queries running slowly: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-slow-running-queries, you can use it as a reference.
Hope this helps you.
Best regards,
Aniya
