{"id":2466,"date":"2015-01-11T13:18:16","date_gmt":"2015-01-11T12:18:16","guid":{"rendered":"http:\/\/www.teamvidia.com\/?p=2466"},"modified":"2015-07-18T18:18:54","modified_gmt":"2015-07-18T17:18:54","slug":"performance","status":"publish","type":"post","link":"https:\/\/www.teamvidia.com\/?p=2466","title":{"rendered":"(SQL Server) Performance"},"content":{"rendered":"<p>- Cot\u00e9 Production : Industrialisation des plans de maintenances<br \/>\n- Sur le projet1, optimisation des performances (56 fois plus rapide) sur une base de donn\u00e9es de pr\u00e8s de 700 Go avec une augmentation de pr\u00e8s de 40 Go par mois. Mise en place de Mirroring et Log Shipping<\/p>\n<p>- Sur le proje2, en 6 jours ont \u00e9t\u00e9 r\u00e9alis\u00e9 la reconstruction de la Base en respectant les \u00ab Best Practices \u00bb Microsoft, am\u00e9lioration des performance (10 fois plus rapide) am\u00e9lioration des traitements Batch (de 1h40 \u00e0 moins de 10 minutes)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>- Cot\u00e9 Production : Industrialisation des plans de maintenances - Sur le projet1, optimisation des performances (56 fois plus rapide) sur une base de donn\u00e9es de pr\u00e8s de 700 Go avec une augmentation de pr\u00e8s de 40 Go par mois. Mise en place de Mirroring et Log Shipping - Sur le proje2, en 6 jours &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53],"tags":[],"class_list":["post-2466","post","type-post","status-publish","format-standard","hentry","category-realisations","no-thumb"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\r\n<title>Performance et Tuning<\/title>\r\n<meta name=\"description\" content=\"Performance et Tuning\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.teamvidia.com\/?p=2466\" \/>\r\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Performance et Tuning\" \/>\r\n<meta property=\"og:description\" content=\"Performance et Tuning\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.teamvidia.com\/?p=2466\" \/>\r\n<meta property=\"og:site_name\" content=\"TEAMVIDIA\" \/>\r\n<meta property=\"article:published_time\" content=\"2015-01-11T12:18:16+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2015-07-18T17:18:54+00:00\" \/>\r\n<meta name=\"author\" content=\"teamvidia\" \/>\r\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"teamvidia\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=2466#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=2466\"},\"author\":{\"name\":\"teamvidia\",\"@id\":\"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96\"},\"headline\":\"(SQL Server) Performance\",\"datePublished\":\"2015-01-11T12:18:16+00:00\",\"dateModified\":\"2015-07-18T17:18:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=2466\"},\"wordCount\":88,\"articleSection\":[\"R\u00e9alisations\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=2466\",\"url\":\"https:\/\/www.teamvidia.com\/?p=2466\",\"name\":\"Performance et Tuning\",\"isPartOf\":{\"@id\":\"https:\/\/www.teamvidia.com\/#website\"},\"datePublished\":\"2015-01-11T12:18:16+00:00\",\"dateModified\":\"2015-07-18T17:18:54+00:00\",\"author\":{\"@id\":\"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96\"},\"description\":\"Performance et Tuning\",\"breadcrumb\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=2466#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.teamvidia.com\/?p=2466\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=2466#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.teamvidia.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"(SQL Server) Performance\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.teamvidia.com\/#website\",\"url\":\"https:\/\/www.teamvidia.com\/\",\"name\":\"TEAMVIDIA\",\"description\":\"Experts Base de Donn\u00e9es\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.teamvidia.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96\",\"name\":\"teamvidia\",\"url\":\"https:\/\/www.teamvidia.com\/?author=1\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Performance et Tuning","description":"Performance et Tuning","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.teamvidia.com\/?p=2466","og_locale":"fr_FR","og_type":"article","og_title":"Performance et Tuning","og_description":"Performance et Tuning","og_url":"https:\/\/www.teamvidia.com\/?p=2466","og_site_name":"TEAMVIDIA","article_published_time":"2015-01-11T12:18:16+00:00","article_modified_time":"2015-07-18T17:18:54+00:00","author":"teamvidia","twitter_misc":{"\u00c9crit par":"teamvidia"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamvidia.com\/?p=2466#article","isPartOf":{"@id":"https:\/\/www.teamvidia.com\/?p=2466"},"author":{"name":"teamvidia","@id":"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96"},"headline":"(SQL Server) Performance","datePublished":"2015-01-11T12:18:16+00:00","dateModified":"2015-07-18T17:18:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamvidia.com\/?p=2466"},"wordCount":88,"articleSection":["R\u00e9alisations"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/www.teamvidia.com\/?p=2466","url":"https:\/\/www.teamvidia.com\/?p=2466","name":"Performance et Tuning","isPartOf":{"@id":"https:\/\/www.teamvidia.com\/#website"},"datePublished":"2015-01-11T12:18:16+00:00","dateModified":"2015-07-18T17:18:54+00:00","author":{"@id":"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96"},"description":"Performance et Tuning","breadcrumb":{"@id":"https:\/\/www.teamvidia.com\/?p=2466#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamvidia.com\/?p=2466"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamvidia.com\/?p=2466#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.teamvidia.com\/"},{"@type":"ListItem","position":2,"name":"(SQL Server) Performance"}]},{"@type":"WebSite","@id":"https:\/\/www.teamvidia.com\/#website","url":"https:\/\/www.teamvidia.com\/","name":"TEAMVIDIA","description":"Experts Base de Donn\u00e9es","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamvidia.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96","name":"teamvidia","url":"https:\/\/www.teamvidia.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts\/2466","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2466"}],"version-history":[{"count":2,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts\/2466\/revisions"}],"predecessor-version":[{"id":2858,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts\/2466\/revisions\/2858"}],"wp:attachment":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}