{"id":5469,"date":"2016-05-16T09:39:51","date_gmt":"2016-05-16T08:39:51","guid":{"rendered":"http:\/\/blog.capdata.fr\/?p=5469"},"modified":"2019-09-13T13:09:35","modified_gmt":"2019-09-13T12:09:35","slug":"mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/","title":{"rendered":"Mythe : ASYNC_IO_COMPLETION indique-t-il toujours une attente sur une IO asynchrone ?"},"content":{"rendered":"<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F5469&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F5469&#038;title=Mythe%20%3A%20ASYNC_IO_COMPLETION%20indique-t-il%20toujours%20une%20attente%20sur%20une%20IO%20asynchrone%20%3F\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=Mythe%20%3A%20ASYNC_IO_COMPLETION%20indique-t-il%20toujours%20une%20attente%20sur%20une%20IO%20asynchrone%20%3F&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F5469\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a><p>Ceux qui pensent que oui l\u00e8vent la main&#8230; Perdu \ud83d\ude42<\/p>\n<p>Pour rappel, ASYNC_IO_COMPLETION est un \u00e9v\u00e8nement d&#8217;attente utilis\u00e9 pour marquer les attentes li\u00e9es \u00e0 des IO asynchrones hors activit\u00e9 buffer pool (qui elles sont marqu\u00e9es avec PAGEIOLATCH_*). L&#8217;exemple le plus connu est le checkpoint, qui \u00e9crit en faisant appel \u00e0 WriteFileGather et des IO asynchrones. Un moins connu est la lecture des fichiers de donn\u00e9es pendant un backup.<\/p>\n<p>Son oppos\u00e9 est IO_COMPLETION qui lui marque les attentes li\u00e9es \u00e0 des IO synchrones. Pour la diff\u00e9rence entre les deux, retourner \u00e0 l&#8217;article sur les\u00a0<a href=\"http:\/\/blog.capdata.fr\/index.php\/io-asynchrones-episode-1\/\">IO asynchrones<\/a>.<\/p>\n<p>Or nous avons vu dans l&#8217;article que ce n&#8217;est pas parce qu&#8217;on poste une IO\u00a0asynchrone qu&#8217;on a la garantie qu&#8217;elle sera bien asynchrone. C&#8217;est la raison pour laquelle on teste toujours\u00a0<a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/windows\/desktop\/ms681382(v=vs.85).aspx\">le code retour<\/a>\u00a0de WriteFileGather ou ReadFileScatter :<\/p>\n<p>&#8211; Si getlasterror retourne ERROR_IO_PENDING (997) : il s&#8217;agit bien d&#8217;une IO asynchrone.<br \/>\n&#8211; Si getlasterror retourne ERROR_SUCCESS (0) : il s&#8217;agit d&#8217;une IO synchrone.<\/p>\n<p>Qu&#8217;est -ce qui pourrait bien causer la conversion d&#8217;une IO asynchrone en synchrone ? Comme l&#8217;indique Raymond Chen sur son\u00a0<a href=\"https:\/\/blogs.msdn.microsoft.com\/oldnewthing\/20110923-00\/?p=9563\">blog<\/a>, par exemple lorsqu&#8217;une \u00e9criture dans un fichier d\u00e9clenche une extension sur disque, ou lorsqu&#8217;on \u00e9crit sur un filesystem compress\u00e9 ou encrypt\u00e9. Un plus grand nombre de causes sont list\u00e9es dans un\u00a0<a href=\"https:\/\/support.microsoft.com\/en-us\/kb\/156932\">KB<\/a>.<\/p>\n<p>Or comme l\u2019\u00e9v\u00e9nement d&#8217;attente au niveau du code de SQL Server est d\u00e9termin\u00e9 avant de poster l&#8217;IO, que celle-ci soit asynchrone ou non ne changera pas la nature de l&#8217;attente vue par SQL Server. Donc ne pas s&#8217;y fier absolument.<\/p>\n<p>On en profite pour rappeler que Paul Randal a publi\u00e9 la semaine derni\u00e8re son r\u00e9f\u00e9rentiel des\u00a0<a href=\"https:\/\/www.sqlskills.com\/help\/waits\/\">\u00e9v\u00e8nements d&#8217;attente<\/a>.<\/p>\n<p><i><b>Update 2016\/07\/01:<\/b> Bob Dorr nous remonte une autre cause de blocage des IO asynchrones: lorsque le journal de transactions est zero-initialis\u00e9, certains syst\u00e8mes de stockage r\u00e9cup\u00e8rent l&#8217;espace car cela peut s&#8217;apparenter \u00e0 du thin provisionning. SQL Server doit r\u00e9initialiser l&#8217;espace \u00e0 nouveau et l&#8217;IO sera post\u00e9e en synchrone. SQL 2016 initialise avec 0xC0 \u00e0 la place de 0x00 pour \u00e9viter ce probl\u00e8me. Cf : <a href=\"https:\/\/blogs.msdn.microsoft.com\/bobsql\/2016\/06\/03\/sql-2016-it-just-runs-faster-ldf-stamped\/\">https:\/\/blogs.msdn.microsoft.com\/bobsql\/2016\/06\/03\/sql-2016-it-just-runs-faster-ldf-stamped\/<\/a><\/i><\/p>\n<p>A+<\/p>\n<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F5469&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F5469&#038;title=Mythe%20%3A%20ASYNC_IO_COMPLETION%20indique-t-il%20toujours%20une%20attente%20sur%20une%20IO%20asynchrone%20%3F\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=Mythe%20%3A%20ASYNC_IO_COMPLETION%20indique-t-il%20toujours%20une%20attente%20sur%20une%20IO%20asynchrone%20%3F&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F5469\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a>","protected":false},"excerpt":{"rendered":"<p>Ceux qui pensent que oui l\u00e8vent la main&#8230; Perdu \ud83d\ude42 Pour rappel, ASYNC_IO_COMPLETION est un \u00e9v\u00e8nement d&#8217;attente utilis\u00e9 pour marquer les attentes li\u00e9es \u00e0 des IO asynchrones hors activit\u00e9 buffer pool (qui elles sont marqu\u00e9es avec PAGEIOLATCH_*). L&#8217;exemple le plus&hellip; <a href=\"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/\" class=\"more-link\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":7825,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[265,174],"class_list":["post-5469","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqlserver","tag-waits","tag-win32"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Mythe : ASYNC_IO_COMPLETION indique-t-il toujours une attente sur une IO asynchrone ? - Capdata TECH BLOG<\/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:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mythe : ASYNC_IO_COMPLETION indique-t-il toujours une attente sur une IO asynchrone ? - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"Ceux qui pensent que oui l\u00e8vent la main&#8230; Perdu \ud83d\ude42 Pour rappel, ASYNC_IO_COMPLETION est un \u00e9v\u00e8nement d&#8217;attente utilis\u00e9 pour marquer les attentes li\u00e9es \u00e0 des IO asynchrones hors activit\u00e9 buffer pool (qui elles sont marqu\u00e9es avec PAGEIOLATCH_*). L&#8217;exemple le plus&hellip; Continuer la lecture &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2016-05-16T08:39:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-13T12:09:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2016\/05\/waiting.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"668\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"David Baffaleuf\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"David Baffaleuf\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/\"},\"author\":{\"name\":\"David Baffaleuf\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf\"},\"headline\":\"Mythe : ASYNC_IO_COMPLETION indique-t-il toujours une attente sur une IO asynchrone ?\",\"datePublished\":\"2016-05-16T08:39:51+00:00\",\"dateModified\":\"2019-09-13T12:09:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/\"},\"wordCount\":367,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"waits\",\"win32\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/\",\"name\":\"Mythe : ASYNC_IO_COMPLETION indique-t-il toujours une attente sur une IO asynchrone ? - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2016-05-16T08:39:51+00:00\",\"dateModified\":\"2019-09-13T12:09:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mythe : ASYNC_IO_COMPLETION indique-t-il toujours une attente sur une IO asynchrone ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.capdata.fr\/#website\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"name\":\"Capdata TECH BLOG\",\"description\":\"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting\",\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.capdata.fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.capdata.fr\/#organization\",\"name\":\"Capdata TECH BLOG\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"contentUrl\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"width\":800,\"height\":254,\"caption\":\"Capdata TECH BLOG\"},\"image\":{\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf\",\"name\":\"David Baffaleuf\",\"sameAs\":[\"http:\/\/www.capdata.fr\"],\"url\":\"https:\/\/blog.capdata.fr\/index.php\/author\/dbaffaleuf\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mythe : ASYNC_IO_COMPLETION indique-t-il toujours une attente sur une IO asynchrone ? - Capdata TECH BLOG","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:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/","og_locale":"fr_FR","og_type":"article","og_title":"Mythe : ASYNC_IO_COMPLETION indique-t-il toujours une attente sur une IO asynchrone ? - Capdata TECH BLOG","og_description":"Ceux qui pensent que oui l\u00e8vent la main&#8230; Perdu \ud83d\ude42 Pour rappel, ASYNC_IO_COMPLETION est un \u00e9v\u00e8nement d&#8217;attente utilis\u00e9 pour marquer les attentes li\u00e9es \u00e0 des IO asynchrones hors activit\u00e9 buffer pool (qui elles sont marqu\u00e9es avec PAGEIOLATCH_*). L&#8217;exemple le plus&hellip; Continuer la lecture &rarr;","og_url":"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2016-05-16T08:39:51+00:00","article_modified_time":"2019-09-13T12:09:35+00:00","og_image":[{"width":1000,"height":668,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2016\/05\/waiting.jpg","type":"image\/jpeg"}],"author":"David Baffaleuf","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"David Baffaleuf","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/"},"author":{"name":"David Baffaleuf","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf"},"headline":"Mythe : ASYNC_IO_COMPLETION indique-t-il toujours une attente sur une IO asynchrone ?","datePublished":"2016-05-16T08:39:51+00:00","dateModified":"2019-09-13T12:09:35+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/"},"wordCount":367,"commentCount":0,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["waits","win32"],"articleSection":["SQL Server"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/","url":"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/","name":"Mythe : ASYNC_IO_COMPLETION indique-t-il toujours une attente sur une IO asynchrone ? - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2016-05-16T08:39:51+00:00","dateModified":"2019-09-13T12:09:35+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/mythe-async_io_completion-indique-t-il-toujours-une-attente-sur-une-io-asynchrone-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"Mythe : ASYNC_IO_COMPLETION indique-t-il toujours une attente sur une IO asynchrone ?"}]},{"@type":"WebSite","@id":"https:\/\/blog.capdata.fr\/#website","url":"https:\/\/blog.capdata.fr\/","name":"Capdata TECH BLOG","description":"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting","publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.capdata.fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/blog.capdata.fr\/#organization","name":"Capdata TECH BLOG","url":"https:\/\/blog.capdata.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/","url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","contentUrl":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","width":800,"height":254,"caption":"Capdata TECH BLOG"},"image":{"@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/"]},{"@type":"Person","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf","name":"David Baffaleuf","sameAs":["http:\/\/www.capdata.fr"],"url":"https:\/\/blog.capdata.fr\/index.php\/author\/dbaffaleuf\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/5469","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=5469"}],"version-history":[{"count":11,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/5469\/revisions"}],"predecessor-version":[{"id":7826,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/5469\/revisions\/7826"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/7825"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=5469"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=5469"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=5469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}