{"id":709,"date":"2015-03-06T09:03:35","date_gmt":"2015-03-06T08:03:35","guid":{"rendered":"http:\/\/lestfrexgn.cluster020.hosting.ovh.net\/?p=709"},"modified":"2015-03-06T09:03:35","modified_gmt":"2015-03-06T08:03:35","slug":"sccm-2007-problemes-de-performance","status":"publish","type":"post","link":"https:\/\/les2t.fr\/en_us\/sccm-2007-problemes-de-performance\/","title":{"rendered":"SCCM 2007 – probl\u00e8mes de performance"},"content":{"rendered":"

\"sccm2007\"<\/a><\/p>\n

Dans un article sur des probl\u00e8mes de performance sur SCCM 2007 concernant les requ\u00eates WQL des collections, Fran\u00e7ois Fickenstahler nous propose d\u2019identifier celles qui posent probl\u00e8me.<\/p>\n


\nEn effet, si le cycle de calcul est trop important, les performances de SCCM vont se faire ressentir. Grace \u00e0 une requ\u00eate SQL, vous obtiendrez les temps de calcul et vous pourrez ainsi vous pencher sur sa r\u00e9solution.
\nVoici la requ\u00eate :<\/p>\n

[pastacode lang=\u00a0\u00bbsql\u00a0\u00bb message=\u00a0\u00bb\u00a0\u00bb highlight=\u00a0\u00bb\u00a0\u00bb provider=\u00a0\u00bbmanual\u00a0\u00bb]
\nSELECT
\nName as [Collection Name]
\n,v_Collection.CollectionID
\n,v_Collection.LastRefreshTime
\n,DATEDIFF(s, EvaluationStartTime, LastRefreshTime) AS [Time(sec)]
\nFROM
\nv_Collection
\nORDER BY [Time(sec)] DESC
\n<\/code><\/pre>\n

[\/pastacode]
\nLien vers l\u2019article original : ICI<\/a><\/p>","protected":false},"excerpt":{"rendered":"

Dans un article sur des probl\u00e8mes de performance sur SCCM 2007 concernant les requ\u00eates WQL des collections, Fran\u00e7ois Fickenstahler nous propose d\u2019identifier celles qui posent probl\u00e8me.<\/p>","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":[8],"tags":[15,36,22],"class_list":["post-709","post","type-post","status-publish","format-standard","hentry","category-sccm-2007","tag-configmgr-2007","tag-microsoft","tag-system-center-configuration-manager"],"yoast_head":"\nSCCM 2007 - probl\u00e8mes de performance - 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\/en_us\/sccm-2007-problemes-de-performance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SCCM 2007 - probl\u00e8mes de performance - Les2T\" \/>\n<meta property=\"og:description\" content=\"Dans un article sur des probl\u00e8mes de performance sur SCCM 2007 concernant les requ\u00eates WQL des collections, Fran\u00e7ois Fickenstahler nous propose d\u2019identifier celles qui posent probl\u00e8me.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/les2t.fr\/en_us\/sccm-2007-problemes-de-performance\/\" \/>\n<meta property=\"og:site_name\" content=\"Les2T\" \/>\n<meta property=\"article:published_time\" content=\"2015-03-06T08:03:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/les2t.fr\/wp-content\/uploads\/2014\/09\/sccm2007-300x69.jpg\" \/>\n<meta name=\"author\" content=\"TRARBACH Jean-Yves\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"TRARBACH Jean-Yves\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/les2t.fr\/sccm-2007-problemes-de-performance\/\",\"url\":\"https:\/\/les2t.fr\/sccm-2007-problemes-de-performance\/\",\"name\":\"SCCM 2007 - probl\u00e8mes de performance - Les2T\",\"isPartOf\":{\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/les2t.fr\/sccm-2007-problemes-de-performance\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/les2t.fr\/sccm-2007-problemes-de-performance\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2014\/09\/sccm2007-300x69.jpg\",\"datePublished\":\"2015-03-06T08:03:35+00:00\",\"author\":{\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/d96bb4f512f9aeb12dc923def245768e\"},\"breadcrumb\":{\"@id\":\"https:\/\/les2t.fr\/sccm-2007-problemes-de-performance\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/les2t.fr\/sccm-2007-problemes-de-performance\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/les2t.fr\/sccm-2007-problemes-de-performance\/#primaryimage\",\"url\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2014\/09\/sccm2007-300x69.jpg\",\"contentUrl\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2014\/09\/sccm2007-300x69.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/les2t.fr\/sccm-2007-problemes-de-performance\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/les2t.fr\/fr_fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SCCM 2007 – probl\u00e8mes de performance\"}]},{\"@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\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/d96bb4f512f9aeb12dc923def245768e\",\"name\":\"TRARBACH Jean-Yves\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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 & devices For IT\",\"sameAs\":[\"https:\/\/les2t.fr\/jean-yves-trarbach\/\"],\"url\":\"https:\/\/les2t.fr\/en_us\/author\/kounac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SCCM 2007 - probl\u00e8mes de performance - 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\/en_us\/sccm-2007-problemes-de-performance\/","og_locale":"en_US","og_type":"article","og_title":"SCCM 2007 - probl\u00e8mes de performance - Les2T","og_description":"Dans un article sur des probl\u00e8mes de performance sur SCCM 2007 concernant les requ\u00eates WQL des collections, Fran\u00e7ois Fickenstahler nous propose d\u2019identifier celles qui posent probl\u00e8me.","og_url":"https:\/\/les2t.fr\/en_us\/sccm-2007-problemes-de-performance\/","og_site_name":"Les2T","article_published_time":"2015-03-06T08:03:35+00:00","og_image":[{"url":"https:\/\/les2t.fr\/wp-content\/uploads\/2014\/09\/sccm2007-300x69.jpg","type":"","width":"","height":""}],"author":"TRARBACH Jean-Yves","twitter_card":"summary_large_image","twitter_misc":{"Written by":"TRARBACH Jean-Yves","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/les2t.fr\/sccm-2007-problemes-de-performance\/","url":"https:\/\/les2t.fr\/sccm-2007-problemes-de-performance\/","name":"SCCM 2007 - probl\u00e8mes de performance - Les2T","isPartOf":{"@id":"https:\/\/les2t.fr\/fr_fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/les2t.fr\/sccm-2007-problemes-de-performance\/#primaryimage"},"image":{"@id":"https:\/\/les2t.fr\/sccm-2007-problemes-de-performance\/#primaryimage"},"thumbnailUrl":"https:\/\/les2t.fr\/wp-content\/uploads\/2014\/09\/sccm2007-300x69.jpg","datePublished":"2015-03-06T08:03:35+00:00","author":{"@id":"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/d96bb4f512f9aeb12dc923def245768e"},"breadcrumb":{"@id":"https:\/\/les2t.fr\/sccm-2007-problemes-de-performance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/les2t.fr\/sccm-2007-problemes-de-performance\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/les2t.fr\/sccm-2007-problemes-de-performance\/#primaryimage","url":"https:\/\/les2t.fr\/wp-content\/uploads\/2014\/09\/sccm2007-300x69.jpg","contentUrl":"https:\/\/les2t.fr\/wp-content\/uploads\/2014\/09\/sccm2007-300x69.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/les2t.fr\/sccm-2007-problemes-de-performance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/les2t.fr\/fr_fr\/"},{"@type":"ListItem","position":2,"name":"SCCM 2007 – probl\u00e8mes de performance"}]},{"@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":"en-US"},{"@type":"Person","@id":"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/d96bb4f512f9aeb12dc923def245768e","name":"TRARBACH Jean-Yves","image":{"@type":"ImageObject","inLanguage":"en-US","@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 & devices For IT","sameAs":["https:\/\/les2t.fr\/jean-yves-trarbach\/"],"url":"https:\/\/les2t.fr\/en_us\/author\/kounac\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/posts\/709","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/comments?post=709"}],"version-history":[{"count":0,"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/posts\/709\/revisions"}],"wp:attachment":[{"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/media?parent=709"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/categories?post=709"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/les2t.fr\/en_us\/wp-json\/wp\/v2\/tags?post=709"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}