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(169.60000000000002, 21%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
we have sql server 2017 RTM on windows server 2012
we migrated to SQL SERVER 2017 RTM on windows server 2019
our queries started running slow .. did run update stats with full scan, rebuilded the indexes, tweaked MAX DOP and COST of threshold , Tempdb are same based on CPU, autogrwoth is same too for all dBs, added more memory , added more CPU to windows server 2019
tried sp with recompile- did not help
the same query run fast in sql server 2017 RTM on windows server 2012 but SLOW in SQL SERVER 2017 RTM on windows server 2019
Any idea experts ? please help
First, what does "SELECT @@version" return on both machines?
What is the compatibility level on the two databases? (I'm assuming that you have the old install around.)
Did you happen to have Query Store enabled before you migrated? In such case, you have a wealth of material to make your investigate your queries.
If you have a sample query, can you share execution plans?
![](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(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @NickK,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Hi @NickK ,
In order to benefit all community members who are having this similar issue, please choose an answer to accept or vote for the answer you think is useful to you. Your contribution is highly appreciated.
Best regards,
Seeya
![](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(307.2, 78%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZB%3C/text%3E%3C/svg%3E)
Hi NickK,
We will highly appreciate your feedback.
Thanks.
Hi @NickKhoo-7526 ,
Since you are using SQL Server 2017 RTM, you can try to install the latest cumulative update (CU31).
https://www.microsoft.com/en-us/download/details.aspx?id=56128
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Hi NickK,
Till now what I have explored, there is nothing to do with SQL server version. Windows 2019 server has some known performance issues.
According to a friend of mine, use latest type of Hard drives i.e. NVME & secondly you may have to change file system configurations. If its a VM you may have to play with VM configurations.
Here is a link just to get an idea of windows 2019 issues & solutions:
Regards,