{"id":3251,"date":"2017-02-05T18:47:28","date_gmt":"2017-02-05T17:47:28","guid":{"rendered":"http:\/\/www.teamvidia.com\/?p=3251"},"modified":"2017-02-05T18:47:28","modified_gmt":"2017-02-05T17:47:28","slug":"fnac-com","status":"publish","type":"post","link":"https:\/\/www.teamvidia.com\/?p=3251","title":{"rendered":"FNAC.COM"},"content":{"rendered":"<p><a href=\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logofnac_400x400.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-2869\" src=\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logofnac_400x400.png\" alt=\"\" width=\"173\" height=\"173\" srcset=\"https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logofnac_400x400.png 400w, https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logofnac_400x400-150x150.png 150w, https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logofnac_400x400-300x300.png 300w\" sizes=\"auto, (max-width: 173px) 100vw, 173px\" \/><\/a><\/p>\n<ul class=\"missions\">\n<li class=\"mission\">Un des leader du ecommerce francais.\n<p>Environnement technique : \u00c9quipe de 2 DBA SQL Server N3<br \/>\n- Sql 2005,2008,2008r2, 2012, 2014.<br \/>\n- 50 r\u00e9plications transactionnelles, log shipping, clustering (5 clusters de 2a 3 noeuds)<br \/>\n- 420 bases<br \/>\n- 34 TB dont 2 bases de plus de 3.5TB<br \/>\n- une plateforme BI de 13TB.<br \/>\n- 28 instances FNAC.COM + 100 instances de FNAC SA prod<\/li>\n<li class=\"mission\">Exploitation:<br \/>\n- r\u00e9tablissement d'un partitionnement n\u00e9glig\u00e9 (3.5to) avec un minimum d'interruption de service<br \/>\n- performance des serveurs (lockpage In Memory, tempdb \u00e9quilibr\u00e9, ...)<br \/>\n- Comparaison des clusters par script (patching Windows et SQL)<br \/>\n- audit et pr\u00e9conisation serveur par serveur (PAL, ClearTrace)<br \/>\n- encadrement n1 et n2<br \/>\n- conseil aux \u00e9quipes de dev<br \/>\n- optimisation des plans de maintenances ( indexes, statistics, ...)<br \/>\n- Audits r\u00e9guliers sur les serveurs de production (PAL, Perfmon, ...), Performance stockage.<br \/>\n- stabilisation de la croissance de stockage<br \/>\n- suppression de 1tb d indexes inutiles<br \/>\n- Compression des bases de donn\u00e9es n\u00e9cessaires suite \u00e0 un changement de facturation de l'espace de stockage<br \/>\n- D\u00e9ploiement de FogLight DELL pour SQL Server \/ MySQL<br \/>\n- Partitionnement de plusieurs tables de tailles importante avec processus de purge ou d'archivage.<br \/>\n- Foglight<\/li>\n<li class=\"mission\">Projet Termin\u00e9e: (Suite \u00e0 mes propositions, r\u00e9duction des couts)<br \/>\n- fin des sql 2005.<br \/>\n- d\u00e9commisionnement des serveurs inutiles et consolidation (-7 instances\/28 licenses)<br \/>\n- base dba datawarehouse avec des donn\u00e9es de DMV pour du reporting, historiser les performances ( historisation des tailles de table, dbcc, backup, derive de perf de proc,....)<br \/>\n- Envoie de rapport avec la base DBA (limite des Ints, CHECKDB, BACKUP, ls plus grand WAIT, Suppression et creation d'indexes, place disque, fichier tempdb diff\u00e9rent, nombre de VLOG, ... sur l'ensemble du parc)<br \/>\n- Architecture d'un cluster SQL Server 2014 pour N\u00e9olane<br \/>\n- Etude de march\u00e9 sur des outils d'historisations et de capacity planning SQL Server (FogLight de Dell), D\u00e9ploiement de Foglight et param\u00e9trage de report similaire \u00e0 PAL<br \/>\n- automatisation et report des sortie de sp_blitzcache (Brent Ozar),<br \/>\n- d\u00e9clenchement automatique des sp_whoisactive sur CPU &gt; 66%<br \/>\n- Traces Xevent sur le code &gt; 1 min.<br \/>\n- Changement de Collation d'une base user. (reprise des indexes, PK, et FK).<br \/>\n- Optimisation des vitesses de restauration SQL Server (x3).<br \/>\n- Optimisation des r\u00e9plications transactionnelles (x4 en performance)<br \/>\n- Remplacement des jobs de l'infog\u00e9rant, suite \u00e0 des soucis d'upgrade de statistics et checkdb trop lent et trop volumineux dans tempdb, par d'autres scripts de maintenance plus fin<\/li>\n<li class=\"mission\">Projet en cours: (Suite \u00e0 mes propositions)<br \/>\n- architecture partitionn\u00e9e pour neolane v6 avec job de purge par switch de table<br \/>\n- Etude de SQL Server 2016 en vue de migration sur cette version, migration des miroirs en alwayson pour 2017<br \/>\n- Etude sur la virtualisation du stockage en production et environnement Dev et Recette.<br \/>\n- Mise en place du mirroring SQL 2008 sur la BI avec les bases op\u00e9rationnelles (objectif: limit\u00e9 les flux BI \/10 sur l'op\u00e9rationnel, arret des restaurations full tous les soirs, fraicheur des donn\u00e9es) avec rafrachissement de snapshot<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Un des leader du ecommerce francais. Environnement technique : \u00c9quipe de 2 DBA SQL Server N3 - Sql 2005,2008,2008r2, 2012, 2014. - 50 r\u00e9plications transactionnelles, log shipping, clustering (5 clusters de 2a 3 noeuds) - 420 bases - 34 TB dont 2 bases de plus de 3.5TB - une plateforme BI de 13TB. - 28 &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[69],"tags":[],"class_list":["post-3251","post","type-post","status-publish","format-standard","hentry","category-clients","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>FNAC.COM - TEAMVIDIA<\/title>\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=3251\" \/>\r\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"FNAC.COM - TEAMVIDIA\" \/>\r\n<meta property=\"og:description\" content=\"Un des leader du ecommerce francais. Environnement technique : \u00c9quipe de 2 DBA SQL Server N3 - Sql 2005,2008,2008r2, 2012, 2014. - 50 r\u00e9plications transactionnelles, log shipping, clustering (5 clusters de 2a 3 noeuds) - 420 bases - 34 TB dont 2 bases de plus de 3.5TB - une plateforme BI de 13TB. - 28 &hellip;\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.teamvidia.com\/?p=3251\" \/>\r\n<meta property=\"og:site_name\" content=\"TEAMVIDIA\" \/>\r\n<meta property=\"article:published_time\" content=\"2017-02-05T17:47:28+00:00\" \/>\r\n<meta property=\"og:image\" content=\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logofnac_400x400.png\" \/>\r\n<meta name=\"author\" content=\"teamvidia\" \/>\r\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"teamvidia\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=3251#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3251\"},\"author\":{\"name\":\"teamvidia\",\"@id\":\"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96\"},\"headline\":\"FNAC.COM\",\"datePublished\":\"2017-02-05T17:47:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3251\"},\"wordCount\":493,\"image\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3251#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logofnac_400x400.png\",\"articleSection\":[\"clients\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=3251\",\"url\":\"https:\/\/www.teamvidia.com\/?p=3251\",\"name\":\"FNAC.COM - TEAMVIDIA\",\"isPartOf\":{\"@id\":\"https:\/\/www.teamvidia.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3251#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3251#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logofnac_400x400.png\",\"datePublished\":\"2017-02-05T17:47:28+00:00\",\"author\":{\"@id\":\"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3251#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.teamvidia.com\/?p=3251\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=3251#primaryimage\",\"url\":\"https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logofnac_400x400.png\",\"contentUrl\":\"https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logofnac_400x400.png\",\"width\":400,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=3251#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.teamvidia.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"FNAC.COM\"}]},{\"@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":"FNAC.COM - TEAMVIDIA","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=3251","og_locale":"fr_FR","og_type":"article","og_title":"FNAC.COM - TEAMVIDIA","og_description":"Un des leader du ecommerce francais. Environnement technique : \u00c9quipe de 2 DBA SQL Server N3 - Sql 2005,2008,2008r2, 2012, 2014. - 50 r\u00e9plications transactionnelles, log shipping, clustering (5 clusters de 2a 3 noeuds) - 420 bases - 34 TB dont 2 bases de plus de 3.5TB - une plateforme BI de 13TB. - 28 &hellip;","og_url":"https:\/\/www.teamvidia.com\/?p=3251","og_site_name":"TEAMVIDIA","article_published_time":"2017-02-05T17:47:28+00:00","og_image":[{"url":"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logofnac_400x400.png","type":"","width":"","height":""}],"author":"teamvidia","twitter_misc":{"\u00c9crit par":"teamvidia","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamvidia.com\/?p=3251#article","isPartOf":{"@id":"https:\/\/www.teamvidia.com\/?p=3251"},"author":{"name":"teamvidia","@id":"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96"},"headline":"FNAC.COM","datePublished":"2017-02-05T17:47:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamvidia.com\/?p=3251"},"wordCount":493,"image":{"@id":"https:\/\/www.teamvidia.com\/?p=3251#primaryimage"},"thumbnailUrl":"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logofnac_400x400.png","articleSection":["clients"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/www.teamvidia.com\/?p=3251","url":"https:\/\/www.teamvidia.com\/?p=3251","name":"FNAC.COM - TEAMVIDIA","isPartOf":{"@id":"https:\/\/www.teamvidia.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.teamvidia.com\/?p=3251#primaryimage"},"image":{"@id":"https:\/\/www.teamvidia.com\/?p=3251#primaryimage"},"thumbnailUrl":"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logofnac_400x400.png","datePublished":"2017-02-05T17:47:28+00:00","author":{"@id":"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96"},"breadcrumb":{"@id":"https:\/\/www.teamvidia.com\/?p=3251#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamvidia.com\/?p=3251"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.teamvidia.com\/?p=3251#primaryimage","url":"https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logofnac_400x400.png","contentUrl":"https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logofnac_400x400.png","width":400,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamvidia.com\/?p=3251#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.teamvidia.com\/"},{"@type":"ListItem","position":2,"name":"FNAC.COM"}]},{"@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\/3251","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=3251"}],"version-history":[{"count":1,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts\/3251\/revisions"}],"predecessor-version":[{"id":3252,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts\/3251\/revisions\/3252"}],"wp:attachment":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}