BIG SSISDB

• vsamantha35

  SSChampion

  Points: 11551

  More actions

  September 26, 2019 at 8:10 am

  #3683528

  Hi Experts,

  We are using SSIS in our environment. Observed that SSISDB is grown to a size of 76 GB now.

  Have a couple of questions:

  1. is there a way to reduce the db size ?

  2. is getting stored in the system db location? I think sql server is treating SSIS db as one of the system databases. Can we move this database to a different drive? any implications doing so?

  Microsoft SQL Server 2016 (SP2) EE.

  

  Thanks,

  Sam

• Andrey

  SSC Eights!

  Points: 840

  More actions

  September 26, 2019 at 8:31 am

  #3683532

  hi Sam

  check best practices for SSISDB first

  https://www.mssqltips.com/sqlservertip/4811/sql-server-integration-services-catalog-best-practices/

  better purge job

  https://www.timmitchell.net/post/2018/12/30/a-better-way-to-clean-up-the-ssis-catalog-database/

  It is possible to move SSISDB like other databases.

   

• frederico_fonseca

  SSCoach

  Points: 16162

  More actions

  September 26, 2019 at 8:33 am

  #3683533

  sometimes a google search does answer

  https://www.mssqltips.com/sqlservertip/3307/managing-the-size-of-the-sql-server-ssis-catalog-database/

  Note that with that size and depending on whether the correct indexes are inplace you may have issues - not sure now which ones but some indexes may be required if you bump into timeouts when trying to cleanup that db - again google has the answer and I have no time just now to find out those (off to work!!)