Created
August 27, 2015 09:49
-
-
Save matt40k/fe08bf529ce38dc52470 to your computer and use it in GitHub Desktop.
Reduce the retention and max project versions kept to help reduce the SSISDB size. Check the settings
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Make a note of the before | |
-- Tempted to add into to preserve the before | |
select * from catalog.catalog_properties | |
-- Change the settings | |
exec catalog.configure_catalog retention_window, 30 | |
exec catalog.configure_catalog max_project_versions, 2 | |
-- Check the settings have stuck | |
select * from catalog.catalog_properties | |
-- Run the cleanup | |
exec internal.cleanup_server_retention_window |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Ref - https://www.mssqltips.com/sqlservertip/3307/managing-the-size-of-the-sql-server-ssis-catalog-database/