Forum Discussion
Facing Slowness issue after migrating from sql server 2008(old server) to sql server 2016(new server
We have a RDP server which is running in 2008 version of SSMS and OS. Recently we migrated this server to 2016 version, both the OS(2016) and SSMS(2016). Configured new machine(with ssms2016) is sa...
prashantagrawalbangalo325 I have been facing the same issue before and solved by enabling query optimizer fix at the database level.
How to steps:-
Right-click on database level then select properties then options then scroll down under database scoped configurations then select "Query Optimizer Fixes" change it to be "ON"
Or by running below:-
USE [DatabaseName]
GO
ALTER DATABASE SCOPED CONFIGURATION SET QUERY_OPTIMIZER_HOTFIXES = On;
GO
I hope that helps you.
Thanks,