{"id":3706,"date":"2012-09-10T18:54:26","date_gmt":"2012-09-10T17:54:26","guid":{"rendered":"http:\/\/blog.capdata.fr\/?p=3706"},"modified":"2019-09-13T14:16:12","modified_gmt":"2019-09-13T13:16:12","slug":"le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/","title":{"rendered":"Param\u00e8tres de la semaine: access check cache bucket count, access check cache quota"},"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%2F3706&#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%2F3706&#038;title=Param%C3%A8tres%20de%20la%20semaine%3A%20access%20check%20cache%20bucket%20count%2C%20access%20check%20cache%20quota\" 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=Param%C3%A8tres%20de%20la%20semaine%3A%20access%20check%20cache%20bucket%20count%2C%20access%20check%20cache%20quota&#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%2F3706\" 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>Pour cette nouvelle s\u00e9rie d&#8217;articles, on se propose d&#8217;\u00e9voquer les param\u00e8tres configuration un peu obscurs de SQL Server. Cette semaine, on prend la liste par le haut : <em>access check cache bucket count<\/em> &amp; <em>access check cache quota<\/em><\/p>\n<h2>Historique:<\/h2>\n<p>Ces deux param\u00e8tres trouvent leur origine dans un probl\u00e8me de surconsommation d&#8217;un user store en SQL Server 20005 RTM et SP1, en l\u2019occurrence <em>TokenAndPermUserStore<\/em>. Ce dernier a \u00e9t\u00e9 ajout\u00e9 lors des grandes man\u0153uvres de refonte de la gestion m\u00e9moire de 2005 pour permettre de conserver en cache les derniers checks de permissions sur les objets, avec un quota par d\u00e9faut sans limite sinon par la m\u00e9moire physique. Dans les premiers builds de la 2005 x64, sur de grosses plateformes avec beaucoup d&#8217;utilisateurs diff\u00e9rents ex\u00e9cutant beaucoup de requ\u00eates ad-hoc, on constatait que ce user store avait tendance \u00e0 grossir rapidement dans sys.dm_os_memory_clerks \/ sys.dm_os_memory_cache_entries.<\/p>\n<p>Afin de contourner le probl\u00e8me, deux traceflags avaient \u00e9t\u00e9 ajout\u00e9s en SQL 2005 SP2 (TF4610 \/TF4618) et SP3 (TF4621) pour fixer le nombre d&#8217;entr\u00e9es maximum dans le <em>TokenAndPermUserStore<\/em>. Et \u00e0 la sortie de SQL Server 2008, deux nouveaux param\u00e8tres de configuration: <em>access check cache bucket count<\/em> et <em>access check cache quota<\/em>.<\/p>\n<h2>Utilisation:<\/h2>\n<p>Chaque param\u00e8tre est dynamique est poss\u00e8de une valeur par d\u00e9faut qui est \u00e9tablie en fonction de l&#8217;architecture:<\/p>\n<pre name=\"code\" class=\"sql\">select name, value, minimum, maximum, value_in_use, is_dynamic \r\nfrom sys.configurations \r\nwhere name in ('access check cache bucket count','access check cache quota') \r\n\r\nname \t\t\t\tvalue \tminimum maximum \tvalue_in_use is_dynamic \r\n------------------------------- ------- ------- --------------- -------------- ------------- \r\naccess check cache bucket count 0 \t0 \t16384 \t\t0 \t\t1 \r\naccess check cache quota \t0 \t0 \t2147483647 \t0 \t\t1<\/pre>\n<p><em>&#8211;<strong> access check cache bucket count<\/strong><\/em> limite le nombre de hash buckets utilis\u00e9s pour localiser les entr\u00e9es dans le cache. Sur x86, la valeur par d\u00e9faut est de <strong>256<\/strong>, et sur x64, la valeur est de <strong>2048<\/strong> hash buckets.<\/p>\n<p>Chaque bucket sert \u00e0 stocker une \u00e0 plusieurs entr\u00e9es. Le m\u00eame principe est utilis\u00e9 dans de nombreux CACHESTOREs et USERSTOREs dans SQL Server (par exemple CACHESTORE_SQLCP, CACHESTORE_OBJCP, USERSTORE_DBMETADATA, etc&#8230; ). Dans le cas de <em>TokenAndPermUserStore<\/em>, <em><\/em>les entr\u00e9es peuvent \u00eatre de plusieurs types: LoginToken, SecContextToken, TokenAccessResult, TokenPerm, UserToken&#8230; et chaque type poss\u00e8de diff\u00e9rentes classes et sous- classes. La r\u00e9partition de ces classes est visible dans <em>sys.dm_os_memory_cache_entries<\/em>:<\/p>\n<pre name=\"code\" class=\"sql\">SELECT COUNT(*) as TokenCount, *\r\nFROM\r\n(SELECT\r\n       x.value('(\/\/@name)[1]', 'varchar (100)') AS [Token Name],\r\n       x.value('(\/\/@class)[1]', 'bigint') AS [Class],\r\n       x.value('(\/\/@subclass)[1]', 'int') AS [SubClass]\r\nFROM\r\n\r\n      (SELECT CAST (entry_data as xml)\r\n       FROM sys.dm_os_memory_cache_entries\r\n       WHERE type = 'USERSTORE_TOKENPERM')\r\n              AS R(x)\r\n       ) a GROUP BY [Token Name],[Class],[SubClass]\r\n\r\nTokenCount\tToken Name\t\tClass\tSubClass\r\n--------------- ----------------------- ------- ---------\r\n14\t\tLoginToken\t\t21\t0\r\n30\t\tSecContextToken\t\t21\t0\r\n42\t\tTokenAccessResult\t0\t22\r\n16\t\tTokenAccessResult\t1\t2\r\n1860\t\tTokenAccessResult\t1\t22\r\n20\t\tTokenAccessResult\t19\t22\r\n8\t\tTokenAccessResult\t20\t22\r\n129\t\tTokenAccessResult\t65535\t0\r\n38\t\tTokenPerm\t\t0\t22\r\n1976\t\tTokenPerm\t\t1\t2\r\n11\t\tTokenPerm\t\t19\t22\r\n8\t\tTokenPerm\t\t20\t22\r\n149\t\tUserToken\t\t7\t0<\/pre>\n<p>Chaque type d&#8217;entr\u00e9e g\u00e8re un besoin diff\u00e9rent. Les entr\u00e9es de type<em> TokenAccessResult<\/em> g\u00e8rent le contr\u00f4le des permissions cumul\u00e9es sur les objets notamment pour les jointures (cf <a href=\"http:\/\/support.microsoft.com\/default.aspx?scid=kb;EN-US;927396\">KB<\/a>).<\/p>\n<p>&#8211; <strong><em>access check cache quota<\/em><\/strong> limite quant \u00e0 lui\u00a0 le nombre d&#8217;entr\u00e9es pour tout le cache. Sur x86, le nombre d&#8217;entr\u00e9es est limit\u00e9 \u00e0 <strong>2048<\/strong> et sur x64 \u00e0 <strong>8192<\/strong>.<\/p>\n<p>Vous ne devriez pas avoir \u00e0 modifier ces valeurs par d\u00e9faut sauf sur l&#8217;avis du support. <\/p>\n<p>A suivre un autre param\u00e8tre obscur&#8230;<\/p>\n<p>A+ David B.<\/p>\n<h2>R\u00e9f\u00e9rence:<\/h2>\n<p>&#8211; <a href=\"http:\/\/support.microsoft.com\/default.aspx?scid=kb;EN-US;959823\">http:\/\/support.microsoft.com\/default.aspx?scid=kb;EN-US;959823<\/a><br \/>\n&#8211; <a href=\"http:\/\/blogs.msdn.com\/b\/psssql\/archive\/2008\/06\/16\/query-performance-issues-associated-with-a-large-sized-security-cache.aspx\">http:\/\/blogs.msdn.com\/b\/psssql\/archive\/2008\/06\/16\/query-performance-issues-associated-with-a-large-sized-security-cache.aspx<\/a><br \/>\n&#8211; <a href=\"http:\/\/support.microsoft.com\/kb\/955644\/en-us\">http:\/\/support.microsoft.com\/kb\/955644\/en-us<\/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%2F3706&#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%2F3706&#038;title=Param%C3%A8tres%20de%20la%20semaine%3A%20access%20check%20cache%20bucket%20count%2C%20access%20check%20cache%20quota\" 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=Param%C3%A8tres%20de%20la%20semaine%3A%20access%20check%20cache%20bucket%20count%2C%20access%20check%20cache%20quota&#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%2F3706\" 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>Pour cette nouvelle s\u00e9rie d&#8217;articles, on se propose d&#8217;\u00e9voquer les param\u00e8tres configuration un peu obscurs de SQL Server. Cette semaine, on prend la liste par le haut : access check cache bucket count &amp; access check cache quota Historique: Ces&hellip; <a href=\"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/\" class=\"more-link\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":7878,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[224],"class_list":["post-3706","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqlserver","tag-parametre-de-la-semaine"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Param\u00e8tres de la semaine: access check cache bucket count, access check cache quota - 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\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Param\u00e8tres de la semaine: access check cache bucket count, access check cache quota - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"Pour cette nouvelle s\u00e9rie d&#8217;articles, on se propose d&#8217;\u00e9voquer les param\u00e8tres configuration un peu obscurs de SQL Server. Cette semaine, on prend la liste par le haut : access check cache bucket count &amp; access check cache quota Historique: Ces&hellip; Continuer la lecture &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2012-09-10T17:54:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-13T13:16:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2012\/09\/bucketcount.png\" \/>\n\t<meta property=\"og:image:width\" content=\"657\" \/>\n\t<meta property=\"og:image:height\" content=\"237\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"3 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\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/\"},\"author\":{\"name\":\"David Baffaleuf\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf\"},\"headline\":\"Param\u00e8tres de la semaine: access check cache bucket count, access check cache quota\",\"datePublished\":\"2012-09-10T17:54:26+00:00\",\"dateModified\":\"2019-09-13T13:16:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/\"},\"wordCount\":478,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"param\u00e8tre de la semaine\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/\",\"name\":\"Param\u00e8tres de la semaine: access check cache bucket count, access check cache quota - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2012-09-10T17:54:26+00:00\",\"dateModified\":\"2019-09-13T13:16:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Param\u00e8tres de la semaine: access check cache bucket count, access check cache quota\"}]},{\"@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":"Param\u00e8tres de la semaine: access check cache bucket count, access check cache quota - 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\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/","og_locale":"fr_FR","og_type":"article","og_title":"Param\u00e8tres de la semaine: access check cache bucket count, access check cache quota - Capdata TECH BLOG","og_description":"Pour cette nouvelle s\u00e9rie d&#8217;articles, on se propose d&#8217;\u00e9voquer les param\u00e8tres configuration un peu obscurs de SQL Server. Cette semaine, on prend la liste par le haut : access check cache bucket count &amp; access check cache quota Historique: Ces&hellip; Continuer la lecture &rarr;","og_url":"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2012-09-10T17:54:26+00:00","article_modified_time":"2019-09-13T13:16:12+00:00","og_image":[{"width":657,"height":237,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2012\/09\/bucketcount.png","type":"image\/png"}],"author":"David Baffaleuf","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"David Baffaleuf","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/"},"author":{"name":"David Baffaleuf","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf"},"headline":"Param\u00e8tres de la semaine: access check cache bucket count, access check cache quota","datePublished":"2012-09-10T17:54:26+00:00","dateModified":"2019-09-13T13:16:12+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/"},"wordCount":478,"commentCount":0,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["param\u00e8tre de la semaine"],"articleSection":["SQL Server"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/","url":"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/","name":"Param\u00e8tres de la semaine: access check cache bucket count, access check cache quota - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2012-09-10T17:54:26+00:00","dateModified":"2019-09-13T13:16:12+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/le-parametre-de-la-semaine-access-check-cache-bucket-count-access-check-cache-quota\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"Param\u00e8tres de la semaine: access check cache bucket count, access check cache quota"}]},{"@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\/3706","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=3706"}],"version-history":[{"count":87,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/3706\/revisions"}],"predecessor-version":[{"id":3794,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/3706\/revisions\/3794"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/7878"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=3706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=3706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=3706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}