{"id":4656,"date":"2023-04-25T11:01:42","date_gmt":"2023-04-25T09:01:42","guid":{"rendered":"https:\/\/www.dbi-services.com\/courses\/microsoft-sql-server-performance-tuning-2\/"},"modified":"2025-07-31T15:19:12","modified_gmt":"2025-07-31T13:19:12","slug":"microsoft-sql-server-performance-tuning","status":"publish","type":"courses","link":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/","title":{"rendered":"Microsoft SQL Server Performance Tuning"},"content":{"rendered":"\n\n<section id=\"\" class=\"post-section   \"><div class=\"section-wrapper\"><div class=\"content-section\">\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"1024\" src=\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-Performance-Tuning-Training-3-1-1024x1024.png\" alt=\"\" class=\"wp-image-7972\" style=\"object-fit:cover;width:502px;height:502px\" srcset=\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-Performance-Tuning-Training-3-1-1024x1024.png 1024w, https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-Performance-Tuning-Training-3-1-300x300.png 300w, https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-Performance-Tuning-Training-3-1-150x150.png 150w, https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-Performance-Tuning-Training-3-1-768x768.png 768w, https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-Performance-Tuning-Training-3-1.png 1200w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Comment la ma\u00eetrise de l&rsquo;optimisation des performances de SQL Server am\u00e9liore-t-elle l&rsquo;efficacit\u00e9 du serveur ?<\/strong><br>Les participants acquerront les aptitudes n\u00e9cessaires pour utiliser les outils standard de SQL Server. Ces outils incluent Perfmon, Extended Events, Query Store et DMVs. De plus, ils apprendront \u00e0 interpr\u00e9ter les plans d&rsquo;ex\u00e9cution. <\/p>\n\n\n\n<p><strong>Quelles aptitudes sont acquises pour identifier et r\u00e9soudre les probl\u00e8mes d&rsquo;efficience?<\/strong><br>Les participants assimileront les comp\u00e9tences utiles pour utiliser les outils standard de SQL Server. Ces outils incluent Perfmon, Extended Events, Query Store et DMVs. Ils sauront aussi interpr\u00e9ter les plans d&rsquo;ex\u00e9cution.<\/p>\n\n\n\n<p><strong>Comment ce cours renforce t-il la confiance et le savoir-faire des DBA et autres administrateurs ?<br><\/strong>En apprenant les techniques d&rsquo;optimisation et de d\u00e9pannage, les inscrits seront mieux pr\u00e9par\u00e9s. Ils pourront g\u00e9rer et optimiser des environnements SQL Server complexes. De plus, ils pourront r\u00e9pondre avec plus de facilit\u00e9 aux tickets de leurs clients sur la lenteur des serveurs.<br><strong><br>Ces aptitudes offrent aux personnes inscrites une meilleur gestion des bases de donn\u00e9es SQL Server. Aussi, ils tireront avantages de syst\u00e8mes plus rapides, plus fiables et plus efficaces. Saisissez cette opportunit\u00e9 pour am\u00e9liorer votre savoir-faire et le rendement de vos bases de donn\u00e9es SQL Server.<\/strong><\/p>\n\n<\/div><\/div><\/section>\n\n<section id=\"objectifs\" class=\"post-section   \"><div class=\"section-wrapper\"><h2>Objectifs<\/h2><div class=\"content-section\">\n\n<h2><\/h2><ul><li>Comprendre comment SQL Server utilise les ressources syst\u00e8me (CPU, I\/O, m\u00e9moire, r\u00e9seau) et ce qu\u2019il faut rechercher lors de la configuration.<\/li><li>Apprendre comment le Query Optimizer calcule le chemin des donn\u00e9es.<\/li><li>Ma\u00eetriser les plans d\u2019ex\u00e9cution et les op\u00e9rateurs les plus importants (acc\u00e8s aux index, tris, parall\u00e9lisme, etc.).<\/li><li>Suivre les performances avec les outils standard de SQL Server (Perfmon, Extended Events, Query Store, DMVs).<\/li><li>Comprendre les types de wait les plus courants de SQL Server.<\/li><\/ul>\n\n<\/div><\/div><\/section>\n\n<section id=\"mthode\" class=\"post-section   \"><div class=\"section-wrapper\"><h2>M\u00e9thode<\/h2><div class=\"content-section\">\n\n<h2><\/h2><ul><li>Pr\u00e9sentations, exercices pratiques, \u00e9tudes de cas et d\u00e9monstrations orient\u00e9es en fonction des questions<\/li><li>Discussion et networking durant les pauses et le repas de midi (inclus)<\/li><\/ul>\n\n<\/div><\/div><\/section>\n\n<section id=\"cibles\" class=\"post-section   \"><div class=\"section-wrapper\"><h2>Cibles<\/h2><div class=\"content-section\">\n\n<h2><\/h2><ul><li>La formation Microsoft SQL Server Performance Tuning s\u2019adresse aux administrateurs de bases de donn\u00e9es (DBA) et aux administrateurs r\u00e9seaux\/syst\u00e8mes\/applications responsables des bases de donn\u00e9es SQL Server ou de leur support.<\/li><\/ul>\n\n<\/div><\/div><\/section>\n\n<section id=\"prrequis\" class=\"post-section   \"><div class=\"section-wrapper\"><h2>Pr\u00e9requis<\/h2><div class=\"content-section\">\n\n<h2><\/h2><ul><li>Bonne exp\u00e9rience et connaissance des bases de donn\u00e9es SQL Server.<\/li><li>Id\u00e9alement, vous avez d\u00e9j\u00e0 suivi la formation SQL Server DBA essentials.<\/li><\/ul>\n\n<\/div><\/div><\/section>\n\n<section id=\"avantages\" class=\"post-section   \"><div class=\"section-wrapper\"><h2>Avantages<\/h2><p>Le cours d&rsquo;optimisation des performances de Microsoft SQL Server offre de nombreux avantages techniques aux utilisateurs :<\/p><div class=\"content-section\">\n\n<h2><\/h2><ul><li><strong>Am\u00e9lioration des performances de SQL Server<\/strong> : Les participants comprendront comment SQL Server utilise les ressources syst\u00e8me (CPU, I\/O, m\u00e9moire, r\u00e9seau) et apprendront \u00e0 optimiser ces ressources. Cela r\u00e9duit les temps de r\u00e9ponse des requ\u00eates et am\u00e9liore g\u00e9n\u00e9ralement les performances des applications utilisant SQL Server.<br><\/li><li><strong>Capacit\u00e9 \u00e0 diagnostiquer et r\u00e9soudre les probl\u00e8mes de performance<\/strong> : Les participants acquerront des comp\u00e9tences pour utiliser les outils standard de SQL Server (Perfmon, Extended Events, Query Store, DMVs) afin de surveiller et diagnostiquer les probl\u00e8mes de performance. Ils apprendront \u00e0 interpr\u00e9ter les plans d&rsquo;ex\u00e9cution et les types d&rsquo;attente les plus courants, ce qui leur permettra d&rsquo;identifier et de r\u00e9soudre efficacement les goulets d&rsquo;\u00e9tranglement.<br><\/li><li><strong>Confiance accrue et comp\u00e9tences pour les DBA et autres administrateurs<\/strong> : En ma\u00eetrisant les techniques d&rsquo;optimisation et de d\u00e9pannage, les participants seront mieux \u00e9quip\u00e9s pour g\u00e9rer et optimiser des environnements SQL Server complexes. Cela augmentera leur confiance professionnelle et les rendra plus pr\u00e9cieux pour leur organisation. De plus, ils seront en mesure de r\u00e9pondre plus efficacement aux plaintes des utilisateurs concernant la lenteur des services.<\/li><\/ul>\n\n\n\n<p>Les personnes inscrites \u00e0 ce workshop recevront une formation pratique et experte sur l&rsquo;optimisation des performances de Microsoft SQL Server, boostant ainsi leur capacit\u00e9 \u00e0 g\u00e9rer les syst\u00e8mes de bases de donn\u00e9es. Ils seront adeptes de l&rsquo;usage des fonctions de Microsoft SQL Server, telles que les groupes de disponibilit\u00e9 Always On pour une haute disponibilit\u00e9, le partitionnement et le sharding pour l&rsquo;adaptabilit\u00e9. De plus, les personnes inscrites auront acc\u00e8s aux ressources et aux conseils de nos coll\u00e8gues experts via <a href=\"https:\/\/www.dbi-services.com\/blog\/category\/sql-server\/\"><strong>des blogs et des discussions ax\u00e9s sur Microsoft SQL Server.<\/strong><\/a><\/p>\n\n\n\n<p>Pour des informations, consultez les ressources disponible de<strong> <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/sql-server\/?view=sql-server-ver16\">Microsoft SQL Server.<\/a><\/strong><\/p>\n\n<\/div><\/div><\/section>\n\n<section id=\"\" class=\"post-section   \"><div class=\"section-wrapper\"><p><strong>R\u00e9duction de 5% pour les membres du SOUG, du SwissPUG et de la DOAG.<\/strong><\/p><\/div><\/section>","protected":false},"author":5,"featured_media":0,"template":"","meta":{"_acf_changed":false},"categories":[35,38],"location":[20,22,23],"class_list":["post-4656","courses","type-courses","status-publish","hentry","category-database","category-microsoft","location-bale","location-berne","location-zurich"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Microsoft SQL Server Performance Tuning - dbi services<\/title>\n<meta name=\"description\" content=\"D\u00e9couvrez tout ce qu&#039;il faut savoir sur le tuning et le troubleshooting sur SQL Server dans notre formation Microsoft SQL Server Performance.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft SQL Server Performance Tuning\" \/>\n<meta property=\"og:description\" content=\"D\u00e9couvrez tout ce qu&#039;il faut savoir sur le tuning et le troubleshooting sur SQL Server dans notre formation Microsoft SQL Server Performance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-31T13:19:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-Performance-Tuning-Training-3-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"1200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/\",\"url\":\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/\",\"name\":\"Microsoft SQL Server Performance Tuning - dbi services\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-Performance-Tuning-Training-3-1-1024x1024.png\",\"datePublished\":\"2023-04-25T09:01:42+00:00\",\"dateModified\":\"2025-07-31T13:19:12+00:00\",\"description\":\"D\u00e9couvrez tout ce qu'il faut savoir sur le tuning et le troubleshooting sur SQL Server dans notre formation Microsoft SQL Server Performance.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-Performance-Tuning-Training-3-1-1024x1024.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-Performance-Tuning-Training-3-1-1024x1024.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dbi-services.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formations\",\"item\":\"https:\/\/www.dbi-services.com\/fr\/formations\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft SQL Server Performance Tuning\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/fr\/\",\"name\":\"dbi services\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi services\",\"url\":\"https:\/\/www.dbi-services.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png\",\"width\":3230,\"height\":1100,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/dbiservices\/\",\"https:\/\/x.com\/dbiservices\",\"https:\/\/www.linkedin.com\/company\/dbi-services\/\",\"https:\/\/www.youtube.com\/user\/dbiservices\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Microsoft SQL Server Performance Tuning - dbi services","description":"D\u00e9couvrez tout ce qu'il faut savoir sur le tuning et le troubleshooting sur SQL Server dans notre formation Microsoft SQL Server Performance.","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.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/","og_locale":"fr_FR","og_type":"article","og_title":"Microsoft SQL Server Performance Tuning","og_description":"D\u00e9couvrez tout ce qu'il faut savoir sur le tuning et le troubleshooting sur SQL Server dans notre formation Microsoft SQL Server Performance.","og_url":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/","og_site_name":"dbi services","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_modified_time":"2025-07-31T13:19:12+00:00","og_image":[{"width":1200,"height":1200,"url":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-Performance-Tuning-Training-3-1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@dbiservices","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/","url":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/","name":"Microsoft SQL Server Performance Tuning - dbi services","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-Performance-Tuning-Training-3-1-1024x1024.png","datePublished":"2023-04-25T09:01:42+00:00","dateModified":"2025-07-31T13:19:12+00:00","description":"D\u00e9couvrez tout ce qu'il faut savoir sur le tuning et le troubleshooting sur SQL Server dans notre formation Microsoft SQL Server Performance.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/#primaryimage","url":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-Performance-Tuning-Training-3-1-1024x1024.png","contentUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/Microsoft-SQL-Server-Performance-Tuning-Training-3-1-1024x1024.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/fr\/formations\/microsoft-sql-server-performance-tuning\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Formations","item":"https:\/\/www.dbi-services.com\/fr\/formations\/"},{"@type":"ListItem","position":3,"name":"Microsoft SQL Server Performance Tuning"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/fr\/#website","url":"https:\/\/www.dbi-services.com\/fr\/","name":"dbi services","description":"","publisher":{"@id":"https:\/\/www.dbi-services.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/fr\/#organization","name":"dbi services","alternateName":"dbi services","url":"https:\/\/www.dbi-services.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png","contentUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png","width":3230,"height":1100,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"]}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/courses\/4656","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/courses"}],"about":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/types\/courses"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/users\/5"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/media?parent=4656"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/categories?post=4656"},{"taxonomy":"location","embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/location?post=4656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}