{"id":2165,"date":"2016-09-29T09:03:27","date_gmt":"2016-09-29T07:03:27","guid":{"rendered":"http:\/\/lestfrexgn.cluster020.hosting.ovh.net\/?p=2165"},"modified":"2016-09-27T22:27:13","modified_gmt":"2016-09-27T20:27:13","slug":"sccm-problemes-de-performance-avec-sql-server-2014-et-2016","status":"publish","type":"post","link":"https:\/\/les2t.fr\/fr_fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/","title":{"rendered":"SCCM \u2013 Probl\u00e8mes de performance avec SQL Server 2014 et 2016"},"content":{"rendered":"<p><a href=\"https:\/\/les2t.fr\/wp-content\/uploads\/2015\/12\/sccmlogo.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1620 aligncenter\" src=\"https:\/\/les2t.fr\/wp-content\/uploads\/2015\/12\/sccmlogo.png\" alt=\"sccmlogo\" width=\"274\" height=\"167\" \/><\/a><br \/>\nDes probl\u00e8mes de performance ont \u00e9t\u00e9 constat\u00e9s entre ConfigMgr \u00e0 partir de la version 2012 et SQL server 2014 et 2016.Microsoft annonce investiguer le probl\u00e8me.<br \/>\nIl semblerait que des requ\u00eates RBAC soient en cause. Ce probl\u00e8me pourrait intervenir que vous ayez une nouvelle installation ou que vous ayez mis \u00e0 jour votre infrastructure SQL.<\/p>\n<p><!--more--><br \/>\nDans les log SQL vous pourrez trouver la pr\u00e9sence de ces erreurs :<\/p>\n<p>[pastacode lang=\u00a0\u00bbmarkup\u00a0\u00bb manual=\u00a0\u00bbA%20possible%20infinite%20recompile%20was%20detected%20for%20SQLHANDLE%200x02000000E3EDE72EEAAB71F42BF86292BFA974C43DAADD720000000000000000000000000000000000000000%2C%20PlanHandle%200x06000800E3EDE72EF0660E370200000001000000000000000000000000000000000000000000000000000000%2C%20starting%20offset%200%2C%20ending%20offset%202676.%20The%20last%20recompile%20reason%20was%202.\u00a0\u00bb message=\u00a0\u00bb\u00a0\u00bb highlight=\u00a0\u00bb\u00a0\u00bb provider=\u00a0\u00bbmanual\u00a0\u00bb\/]<\/p>\n<p>Si c\u2019est le cas vous pouvez passer votre base de donn\u00e9 en niveau de compatibilit\u00e9 SQL Server 2012 via la commande :<\/p>\n<p>[pastacode lang=\u00a0\u00bbc\u00a0\u00bb manual=\u00a0\u00bbALTER%20DATABASE%20DBNAME%20SET%20COMPATIBILITY_LEVEL%3D110%3B%0AGO\u00a0\u00bb message=\u00a0\u00bb\u00a0\u00bb highlight=\u00a0\u00bb\u00a0\u00bb provider=\u00a0\u00bbmanual\u00a0\u00bb\/]<\/p>\n<p>Ou via SQL management Studio de mani\u00e8re graphique dans les propri\u00e9t\u00e9s de vos bases.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Des probl\u00e8mes de performance ont \u00e9t\u00e9 constat\u00e9s entre ConfigMgr \u00e0 partir de la version 2012 et SQL server 2014 et 2016.Microsoft annonce investiguer le probl\u00e8me. Il semblerait que des requ\u00eates RBAC soient en cause. Ce probl\u00e8me pourrait intervenir que vous ayez une nouvelle installation ou que vous ayez mis \u00e0 jour votre infrastructure SQL.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[198],"tags":[113,193,14,36,164,107,129,22],"class_list":["post-2165","post","type-post","status-publish","format-standard","hentry","category-sccm","tag-configmgr","tag-configmgr-1511","tag-configmgr-2012","tag-microsoft","tag-sccm-2012","tag-sql-server-2014","tag-sql-server-2016","tag-system-center-configuration-manager"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.3.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SCCM \u2013 Probl\u00e8mes de performance avec SQL Server 2014 et 2016 - Les2T<\/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:\/\/les2t.fr\/fr_fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SCCM \u2013 Probl\u00e8mes de performance avec SQL Server 2014 et 2016 - Les2T\" \/>\n<meta property=\"og:description\" content=\"Des probl\u00e8mes de performance ont \u00e9t\u00e9 constat\u00e9s entre ConfigMgr \u00e0 partir de la version 2012 et SQL server 2014 et 2016.Microsoft annonce investiguer le probl\u00e8me. Il semblerait que des requ\u00eates RBAC soient en cause. Ce probl\u00e8me pourrait intervenir que vous ayez une nouvelle installation ou que vous ayez mis \u00e0 jour votre infrastructure SQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/les2t.fr\/fr_fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/\" \/>\n<meta property=\"og:site_name\" content=\"Les2T\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-29T07:03:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/les2t.fr\/wp-content\/uploads\/2015\/12\/sccmlogo.png\" \/>\n<meta name=\"author\" content=\"TRARBACH Jean-Yves\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"TRARBACH Jean-Yves\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/les2t.fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/\",\"url\":\"https:\/\/les2t.fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/\",\"name\":\"SCCM \u2013 Probl\u00e8mes de performance avec SQL Server 2014 et 2016 - Les2T\",\"isPartOf\":{\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/les2t.fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/les2t.fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2015\/12\/sccmlogo.png\",\"datePublished\":\"2016-09-29T07:03:27+00:00\",\"author\":{\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/d96bb4f512f9aeb12dc923def245768e\"},\"breadcrumb\":{\"@id\":\"https:\/\/les2t.fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/les2t.fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/les2t.fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/#primaryimage\",\"url\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2015\/12\/sccmlogo.png\",\"contentUrl\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2015\/12\/sccmlogo.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/les2t.fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/les2t.fr\/fr_fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SCCM \u2013 Probl\u00e8mes de performance avec SQL Server 2014 et 2016\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#website\",\"url\":\"https:\/\/les2t.fr\/fr_fr\/\",\"name\":\"Les2T\",\"description\":\"| BLOG  IT |\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/les2t.fr\/fr_fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/d96bb4f512f9aeb12dc923def245768e\",\"name\":\"TRARBACH Jean-Yves\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2023\/02\/JeanYvestrarbach-96x96.jpg\",\"contentUrl\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2023\/02\/JeanYvestrarbach-96x96.jpg\",\"caption\":\"TRARBACH Jean-Yves\"},\"description\":\"Head Of Modern Workplace Metsys MVP Windows &amp; devices For IT\",\"sameAs\":[\"https:\/\/les2t.fr\/jean-yves-trarbach\/\"],\"url\":\"https:\/\/les2t.fr\/fr_fr\/author\/kounac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SCCM \u2013 Probl\u00e8mes de performance avec SQL Server 2014 et 2016 - Les2T","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:\/\/les2t.fr\/fr_fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/","og_locale":"fr_FR","og_type":"article","og_title":"SCCM \u2013 Probl\u00e8mes de performance avec SQL Server 2014 et 2016 - Les2T","og_description":"Des probl\u00e8mes de performance ont \u00e9t\u00e9 constat\u00e9s entre ConfigMgr \u00e0 partir de la version 2012 et SQL server 2014 et 2016.Microsoft annonce investiguer le probl\u00e8me. Il semblerait que des requ\u00eates RBAC soient en cause. Ce probl\u00e8me pourrait intervenir que vous ayez une nouvelle installation ou que vous ayez mis \u00e0 jour votre infrastructure SQL.","og_url":"https:\/\/les2t.fr\/fr_fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/","og_site_name":"Les2T","article_published_time":"2016-09-29T07:03:27+00:00","og_image":[{"url":"https:\/\/les2t.fr\/wp-content\/uploads\/2015\/12\/sccmlogo.png","type":"","width":"","height":""}],"author":"TRARBACH Jean-Yves","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"TRARBACH Jean-Yves","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/les2t.fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/","url":"https:\/\/les2t.fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/","name":"SCCM \u2013 Probl\u00e8mes de performance avec SQL Server 2014 et 2016 - Les2T","isPartOf":{"@id":"https:\/\/les2t.fr\/fr_fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/les2t.fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/#primaryimage"},"image":{"@id":"https:\/\/les2t.fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/les2t.fr\/wp-content\/uploads\/2015\/12\/sccmlogo.png","datePublished":"2016-09-29T07:03:27+00:00","author":{"@id":"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/d96bb4f512f9aeb12dc923def245768e"},"breadcrumb":{"@id":"https:\/\/les2t.fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/les2t.fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/les2t.fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/#primaryimage","url":"https:\/\/les2t.fr\/wp-content\/uploads\/2015\/12\/sccmlogo.png","contentUrl":"https:\/\/les2t.fr\/wp-content\/uploads\/2015\/12\/sccmlogo.png"},{"@type":"BreadcrumbList","@id":"https:\/\/les2t.fr\/sccm-problemes-de-performance-avec-sql-server-2014-et-2016\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/les2t.fr\/fr_fr\/"},{"@type":"ListItem","position":2,"name":"SCCM \u2013 Probl\u00e8mes de performance avec SQL Server 2014 et 2016"}]},{"@type":"WebSite","@id":"https:\/\/les2t.fr\/fr_fr\/#website","url":"https:\/\/les2t.fr\/fr_fr\/","name":"Les2T","description":"| BLOG  IT |","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/les2t.fr\/fr_fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/d96bb4f512f9aeb12dc923def245768e","name":"TRARBACH Jean-Yves","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/image\/","url":"https:\/\/les2t.fr\/wp-content\/uploads\/2023\/02\/JeanYvestrarbach-96x96.jpg","contentUrl":"https:\/\/les2t.fr\/wp-content\/uploads\/2023\/02\/JeanYvestrarbach-96x96.jpg","caption":"TRARBACH Jean-Yves"},"description":"Head Of Modern Workplace Metsys MVP Windows &amp; devices For IT","sameAs":["https:\/\/les2t.fr\/jean-yves-trarbach\/"],"url":"https:\/\/les2t.fr\/fr_fr\/author\/kounac\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/posts\/2165","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/comments?post=2165"}],"version-history":[{"count":0,"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/posts\/2165\/revisions"}],"wp:attachment":[{"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/media?parent=2165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/categories?post=2165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/tags?post=2165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}