SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
494 questions
after upgrading sql server 2014 to 2019 Views become slow
![](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(64, 94%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
sohel rana
1
Reputation point
after upgrading sql server 2014 to 2019 Views become slow but without view query run very fast
{count} votes
-
CathyJi-MSFT 21,091 Reputation points Microsoft Vendor2021-04-02T02:45:54.697+00:00 Hi @sohel rana ,
Suggest you sharing us the result of the execution plan about the slow query from views, this will help us to troubleshoot this issue. Refer to the blog Execution Plans in SQL Server.
Sign in to comment