{"id":1985,"date":"2015-01-11T21:02:20","date_gmt":"2015-01-12T02:02:20","guid":{"rendered":"http:\/\/blogs.devhorizon.com\/reza\/?p=1985"},"modified":"2015-05-11T16:15:58","modified_gmt":"2015-05-11T21:15:58","slug":"a-tip-to-keep-your-sharepoint_config-database-under-control","status":"publish","type":"post","link":"https:\/\/blogs.devhorizon.com\/reza\/2015\/01\/11\/a-tip-to-keep-your-sharepoint_config-database-under-control\/","title":{"rendered":"A tip to keep your SharePoint_config database under control"},"content":{"rendered":"<p>Every once in a while, the situation comes about where a developer or administrator notices that their SharePoint_Config database has grown extremely large in size.\u00a0 This is not a newly documented issue and you can find the detailed steps from the blog post link below. What&#8217;s happening here is the timer job &#8220;Delete Job History&#8221; at some point has to many records stored in SQL for it to be able to complete before it times out or runs out of memory.<\/p>\n<p>My tip here is that if you&#8217;re creating a new environment or once you&#8217;ve cleaned up your existing environment, is to change the &#8220;Delete Job History&#8221; schedule from once a week to once a day. This will help to keep the timer job in a\u00a0state that it&#8217;s able to complete its\u00a0work and have\u00a0the database size under control.<\/p>\n<p><a href=\"http:\/\/www.techgrowingpains.com\/2012\/01\/out-of-control-sharepoint_config-database\/\">Out of control SharePoint_Config Database\u00a0<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Every once in a while, the situation comes about where a developer or administrator notices that their SharePoint_Config database has grown extremely large in size.\u00a0 This is not a newly documented issue and you can find the detailed steps from the blog post link below. What&#8217;s happening here is the timer job &#8220;Delete Job History&#8221; [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42,37],"tags":[],"class_list":["post-1985","post","type-post","status-publish","format-standard","hentry","category-general","category-sharepoint-2013"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>A tip to keep your SharePoint_config database under control - Reza Alirezaei&#039;s Blog %<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blogs.devhorizon.com\/reza\/2015\/01\/11\/a-tip-to-keep-your-sharepoint_config-database-under-control\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Reza Alirezaei\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2015\\\/01\\\/11\\\/a-tip-to-keep-your-sharepoint_config-database-under-control\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2015\\\/01\\\/11\\\/a-tip-to-keep-your-sharepoint_config-database-under-control\\\/\"},\"author\":{\"name\":\"Reza Alirezaei\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\"},\"headline\":\"A tip to keep your SharePoint_config database under control\",\"datePublished\":\"2015-01-12T02:02:20+00:00\",\"dateModified\":\"2015-05-11T21:15:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2015\\\/01\\\/11\\\/a-tip-to-keep-your-sharepoint_config-database-under-control\\\/\"},\"wordCount\":162,\"commentCount\":0,\"articleSection\":[\"General\",\"SharePoint 2013\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2015\\\/01\\\/11\\\/a-tip-to-keep-your-sharepoint_config-database-under-control\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2015\\\/01\\\/11\\\/a-tip-to-keep-your-sharepoint_config-database-under-control\\\/\",\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2015\\\/01\\\/11\\\/a-tip-to-keep-your-sharepoint_config-database-under-control\\\/\",\"name\":\"A tip to keep your SharePoint_config database under control - Reza Alirezaei's Blog %\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#website\"},\"datePublished\":\"2015-01-12T02:02:20+00:00\",\"dateModified\":\"2015-05-11T21:15:58+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2015\\\/01\\\/11\\\/a-tip-to-keep-your-sharepoint_config-database-under-control\\\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#website\",\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/\",\"name\":\"Reza Alirezaei's Blog\",\"description\":\"Blogging from the field!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\",\"name\":\"Reza Alirezaei\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"caption\":\"Reza Alirezaei\"},\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/author\\\/rezaa\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"A tip to keep your SharePoint_config database under control - Reza Alirezaei's Blog %","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:\/\/blogs.devhorizon.com\/reza\/2015\/01\/11\/a-tip-to-keep-your-sharepoint_config-database-under-control\/","twitter_misc":{"Written by":"Reza Alirezaei","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blogs.devhorizon.com\/reza\/2015\/01\/11\/a-tip-to-keep-your-sharepoint_config-database-under-control\/#article","isPartOf":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/2015\/01\/11\/a-tip-to-keep-your-sharepoint_config-database-under-control\/"},"author":{"name":"Reza Alirezaei","@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938"},"headline":"A tip to keep your SharePoint_config database under control","datePublished":"2015-01-12T02:02:20+00:00","dateModified":"2015-05-11T21:15:58+00:00","mainEntityOfPage":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/2015\/01\/11\/a-tip-to-keep-your-sharepoint_config-database-under-control\/"},"wordCount":162,"commentCount":0,"articleSection":["General","SharePoint 2013"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blogs.devhorizon.com\/reza\/2015\/01\/11\/a-tip-to-keep-your-sharepoint_config-database-under-control\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blogs.devhorizon.com\/reza\/2015\/01\/11\/a-tip-to-keep-your-sharepoint_config-database-under-control\/","url":"https:\/\/blogs.devhorizon.com\/reza\/2015\/01\/11\/a-tip-to-keep-your-sharepoint_config-database-under-control\/","name":"A tip to keep your SharePoint_config database under control - Reza Alirezaei's Blog %","isPartOf":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/#website"},"datePublished":"2015-01-12T02:02:20+00:00","dateModified":"2015-05-11T21:15:58+00:00","author":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blogs.devhorizon.com\/reza\/2015\/01\/11\/a-tip-to-keep-your-sharepoint_config-database-under-control\/"]}]},{"@type":"WebSite","@id":"https:\/\/blogs.devhorizon.com\/reza\/#website","url":"https:\/\/blogs.devhorizon.com\/reza\/","name":"Reza Alirezaei's Blog","description":"Blogging from the field!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blogs.devhorizon.com\/reza\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938","name":"Reza Alirezaei","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","caption":"Reza Alirezaei"},"url":"https:\/\/blogs.devhorizon.com\/reza\/author\/rezaa\/"}]}},"_links":{"self":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts\/1985","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/comments?post=1985"}],"version-history":[{"count":3,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts\/1985\/revisions"}],"predecessor-version":[{"id":1994,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts\/1985\/revisions\/1994"}],"wp:attachment":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/media?parent=1985"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/categories?post=1985"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/tags?post=1985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}