We're having a few issues with integration services packages taking a long time to run on our new SQL Server 2016 server. Has anyone come up against issues where SSIS jobs hang indefinitely at the pre-execute phase?
Do you have any recommendations on what we can do optimise performance for SQL Server 2016 please? Is it worth setting maximum server memory for SQL for example?