{"id":5812,"date":"2015-10-09T10:08:34","date_gmt":"2015-10-09T08:08:34","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/"},"modified":"2015-10-09T10:08:34","modified_gmt":"2015-10-09T08:08:34","slug":"ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/","title":{"rendered":"SSISDB is too big and it is not every time the retention period\u2019s fault!"},"content":{"rendered":"<p>In all blogs that I read, the solution is just to<em> change the retention period to a reasonable value<\/em>.<br \/>\nYes, it is true but in some case you need to go deeper in the analysis&#8230;<br \/>\nLike you, I changed the retention period, ran the cleanup but finally, I had always a big database&#8230; <em>Why, Why, Why?<\/em><br \/>\nMy first step for this analysis, is to see in the SSISDB, the Disk Usage by Table Reports from SSMS.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SSISDB_Size_01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4356 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SSISDB_Size_01.png\" alt=\"SSISDB_Size_01\" width=\"267\" height=\"300\" \/><\/a><br \/>\nI see that table internal.execution_component_phases is the biggest.<br \/>\nI select in this table what are the packages and how many entries per package I have in this table&#8230;<br \/>\nQuery used:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">select distinct package_name, count(*) as number_of_entry from internal.execution_component_phases group by package_name<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SSISDB_Size_02.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4357 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SSISDB_Size_02.png\" alt=\"SSISDB_Size_02\" width=\"300\" height=\"82\" \/><\/a><\/p>\n<p>In my case, the &#8220;Package1.dtsx&#8221; has 3756828 entries.<br \/>\nI go deeper with this package and search how many entries I have with my package per execution.<br \/>\nQuery used:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">select distinct execution_id, count(*) from internal.execution_component_phases where package_name='package1.dtsx' group by execution_id<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SSISDB_Size_03.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4358 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SSISDB_Size_03.png\" alt=\"SSISDB_Size_03\" width=\"300\" height=\"120\" \/><\/a><\/p>\n<p>It is for each execution almost the same.<br \/>\nI guess it comes from an execution parameter.<br \/>\nI select all parameters from one execution (id=719).<br \/>\nQuery used:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT * FROM catalog.execution_parameter_values where execution_id = 719<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SSISDB_Size_04.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4359 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SSISDB_Size_04.png\" alt=\"SSISDB_Size_04\" width=\"300\" height=\"133\" \/><\/a><\/p>\n<p>I see in my result, that the LOGGING_LEVEL is set to 2 and not 1 the default value&#8230;<\/p>\n<p>To confirm my theory, I check this parameter for all executions.<br \/>\nQuery used:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT distinct ecp.execution_id, epv.parameter_name,epv.parameter_value\nFROM catalog.execution_parameter_values epv inner join internal.execution_component_phases ecp\non ecp.execution_id=epv.execution_id where epv.parameter_name='LOGGING_LEVEL'<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SSISDB_Size_05.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4360 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SSISDB_Size_05.png\" alt=\"SSISDB_Size_05\" width=\"300\" height=\"220\" \/><\/a><\/p>\n<p>And as you can see, the LOGGING_LEVEL is always set to 2.<\/p>\n<p>What is the signification of a LOGGING_LEVEL=2?<br \/>\nI go directly to the msdn to read the logging level on \u201c<a title=\"Enable Logging for Package Execution on SSIS Server\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/hh231191.aspx\" target=\"_blank\">Enable Logging for Package Execution on the SSIS Server<\/a>\u201d<br \/>\nIn the documentation, you can read that the Logging Level \u201cPerformance\u201d is linked to the <a title=\"catalog.execution_component-phases\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/hh230981.aspx\" target=\"_blank\">catalog.execution_component_phases<\/a> and\u00a0 the start and end times for the data flow components are logged for each phase of an execution. But this view is also available for the logging level \u201cVerbose\u201d\u2026<br \/>\nIn this webpage, I haven\u2019t the match between the logging level and its number.<br \/>\nI find the match in the webpage from the \u201c<a title=\"catalog.set_execution_parameter_value\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ff877990.aspx\" target=\"_blank\">catalog.set_execution_parameter_value<\/a>\u201d and see that the 2 is the \u201cPerformance\u201d Logging level.<\/p>\n<p><strong>Conclusion:<\/strong> I contacted the package owner and explained him the case. I asked him why this level of logging and he said me that he thought that was to have performance\u2026 He didn\u2019t read correctly the documentation!<br \/>\nAfter the explanation of the logging level set to performance, he changed the logging level to Basic and the SSISDB grew normally again. \ud83d\ude09<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In all blogs that I read, the solution is just to change the retention period to a reasonable value. Yes, it is true but in some case you need to go deeper in the analysis&#8230; Like you, I changed the retention period, ran the cleanup but finally, I had always a big database&#8230; Why, Why,&hellip;&nbsp;<\/p>\n","protected":false},"author":15,"featured_media":5818,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[263,49,67,44],"class_list":["post-5812","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","tag-integration-services","tag-microsoft","tag-performance","tag-troubleshooting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SSISDB is too big and it is not every time the retention period\u2019s fault! - dbi services | Blog<\/title>\n<meta name=\"description\" content=\"SSISDB is too big and it is not every time the retention period\u2019s fault. Igo deeper in the analysis of this problem.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SSISDB is too big and it is not every time the retention period\u2019s fault!\" \/>\n<meta property=\"og:description\" content=\"SSISDB is too big and it is not every time the retention period\u2019s fault. Igo deeper in the analysis of this problem.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2015-10-09T08:08:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SSISDB_Size_01-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"767\" \/>\n\t<meta property=\"og:image:height\" content=\"863\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\"},\"headline\":\"SSISDB is too big and it is not every time the retention period\u2019s fault!\",\"datePublished\":\"2015-10-09T08:08:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\\\/\"},\"wordCount\":398,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/SSISDB_Size_01-1.png\",\"keywords\":[\"Integration services\",\"Microsoft\",\"Performance\",\"Troubleshooting\"],\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\\\/\",\"name\":\"SSISDB is too big and it is not every time the retention period\u2019s fault! - dbi services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/SSISDB_Size_01-1.png\",\"datePublished\":\"2015-10-09T08:08:34+00:00\",\"description\":\"SSISDB is too big and it is not every time the retention period\u2019s fault. Igo deeper in the analysis of this problem.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/SSISDB_Size_01-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/SSISDB_Size_01-1.png\",\"width\":767,\"height\":863},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSISDB is too big and it is not every time the retention period\u2019s fault!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SSISDB is too big and it is not every time the retention period\u2019s fault! - dbi services | Blog","description":"SSISDB is too big and it is not every time the retention period\u2019s fault. Igo deeper in the analysis of this problem.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/","og_locale":"en_US","og_type":"article","og_title":"SSISDB is too big and it is not every time the retention period\u2019s fault!","og_description":"SSISDB is too big and it is not every time the retention period\u2019s fault. Igo deeper in the analysis of this problem.","og_url":"https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2015-10-09T08:08:34+00:00","og_image":[{"width":767,"height":863,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SSISDB_Size_01-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a"},"headline":"SSISDB is too big and it is not every time the retention period\u2019s fault!","datePublished":"2015-10-09T08:08:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/"},"wordCount":398,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SSISDB_Size_01-1.png","keywords":["Integration services","Microsoft","Performance","Troubleshooting"],"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/","url":"https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/","name":"SSISDB is too big and it is not every time the retention period\u2019s fault! - dbi services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SSISDB_Size_01-1.png","datePublished":"2015-10-09T08:08:34+00:00","description":"SSISDB is too big and it is not every time the retention period\u2019s fault. Igo deeper in the analysis of this problem.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SSISDB_Size_01-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/SSISDB_Size_01-1.png","width":767,"height":863},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/ssisdb-is-too-big-and-it-is-not-every-time-the-retention-periods-fault\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSISDB is too big and it is not every time the retention period\u2019s fault!"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5812","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=5812"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5812\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/5818"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5812"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5812"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5812"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}