SSIS Server Maintenance Job has become slow

• Siten0308

  SSCarpal Tunnel

  Points: 4404

  More actions

  August 1, 2019 at 3:18 pm

  #3667938

  Hello,

  just recently our SQL Server job: SSIS Server Maintenance Job has been running and taking 7+ hours... i researched it and found this article:

  https://support.microsoft.com/en-us/help/2829948/fix-slow-performance-when-you-run-the-ssis-server-maintenance-job-to-r

  but the problem is, we are on SQL server 2016, below is the detail information of our SQL server:

  Microsoft SQL Server 2016 (SP2-CU1) (KB4135048) - 13.0.5149.0 (X64) May 19 2018 09:41:57 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 R2 Datacenter 6.3 <X64> (Build 9600: ) (Hypervisor)

  wondering if there is a CU for the 2016 or if this has already been applied to 2016? is there a manual fix? any info will help.

  thanks in advance

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  August 2, 2019 at 4:10 pm

  #3668310

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.