Lots of people are using the SSIS catalog database, SSISDB, for SSIS packages.
Actually, using the SSIS catalog is best practice but there are still some shops that use File System Packages. These shops should really consider migrating to the SSIS catalog. Some benefits are:
One note of caution with regards to enabling logging… Be careful to only log those things that you really need. Otherwise, you may end up with a SSISDB that is quite large.
There are 4 logging levels that can be implemented at the server, job and package execution levels: None, Basic, Performance & Verbose.
There is a performance hit if you use the Performance or Verbose logging levels, so use them with caution.
Maintenance of the data in SSISDB also needs to be performed regularly and carefully. It is common that while purging old data from SSISDB for there to be package timeouts so plan a good time to run the ‘SSIS Server Maintenance Job’ that is installed by default to help clean up old records.
Make sure that you are only retaining the history that you need. Check your retention settings to make sure you don’t still have the default value or 365 days of history being kept.
A little bit of thought for the care of your SSISDB database and settings will assure that you will have an SSIS environment that will hum along.
For more information about blog posts, concepts and definitions, further explanations, or questions you may have…please contact us at SQLRx@sqlrx.com. We will be happy to help! Leave a comment and feel free to track back to us. Visit us at www.sqlrx.com!