Home Forums SQL Server 2008 SQL Server Newbies INSERT running slow in SQL 2016 RE: INSERT running slow in SQL 2016
January 29, 2018 at 9:24 am
Grant Fritchey - Thursday, January 25, 2018 8:58 AMcoolchaitu - Wednesday, January 24, 2018 11:24 PMGood Morning Experts,
We had a database on SQL Server 2012. INSERTS were running fine. We migrated this database to 2016 and noticed same INSERTS taking very very long time. Could it be due to different settings on SQL 2016? Please help
Lots more details. Just an INSERT or an INSERT with a SELECT? Statistics? Execution Plan? Structures?
There is no way in the world for someone to give you enough information to begin to troubleshoot your problem when you define the problem as "taking a very long time." It could be anything. You have to provide some information for us to even start to make educated guesses.
Only INSERT