{"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"],"_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}]}}