{"id":7479,"date":"2019-05-09T17:02:53","date_gmt":"2019-05-09T16:02:53","guid":{"rendered":"http:\/\/blog.capdata.fr\/?p=7479"},"modified":"2022-11-21T16:54:26","modified_gmt":"2022-11-21T15:54:26","slug":"determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/","title":{"rendered":"D\u00e9terminer la fr\u00e9quence horaire d’ex\u00e9cution d’une proc\u00e9dure stock\u00e9e sous SQL Server"},"content":{"rendered":"\"twitter\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>

Pour des raisons purement m\u00e9tier, il m’a \u00e9t\u00e9 demand\u00e9 le nombre d’ex\u00e9cutions horaires d’une proc\u00e9dure stock\u00e9e “m\u00e9tier”. Le but \u00e9tait d’identifier les variations d’utilisation de la plateforme, sans se reposer sur des indicateurs trop techniques (charge CPU, batch request\/sec , concurrent sessions, etc…)<\/p>\n

Il y a diff\u00e9rents moyens qui peuvent \u00eatre plus ou moins fiables, dans certaines DMV ou avec le Data Collection, mais rien ne me convenait en terme de fiabilit\u00e9 et d’\u00e9l\u00e9gance.<\/p>\n

Et puis j’ai repens\u00e9 \u00e0 quelque chose que j’utilise encore trop peu : les Evenements Etendus (Extended Events). Je m’en sers peu car, par habitude, la bonne vieille TRACE (et son outil d\u00e9di\u00e9, le SQL Profiler) me conviennent pour la plupart des cas. Mais la Trace a un impact en terme de performance sup\u00e9rieur aux Extended Events. Et puis pour des comptages, il aurait fallu faire une usine \u00e0 gaz, o\u00f9 on aurait stock\u00e9 en table, puis ex\u00e9cut\u00e9 un job qui aurait identifi\u00e9 les ex\u00e9cution de la proc\u00e9dure stock\u00e9e, et ins\u00e9rer dans une table le r\u00e9sultat du comptage… Bref : pas \u00e9l\u00e9gant.<\/p>\n

Les Extended Events ont beaucoup progress\u00e9 depuis leur cr\u00e9ation, au point de couvrir l’int\u00e9gralit\u00e9 du p\u00e9rim\u00e8tre de ce que peut faire une Trace, sur les derni\u00e8res version de SQL Server. Et bien plus encore !<\/p>\n

Les Extended Events travaillent \u00e0 bas niveau, et n’impactent pas autant le moteur en terme de performance. On peut aussi d\u00e9cider facilement de la destination de l’Extended Events : une table, un fichier, un ring buffer (pour consommation imm\u00e9diate)… Mais aussi un compteur !<\/p>\n

Nous voila donc \u00e0 faire la man\u0153uvre suivante :<\/p>\n

\r\n\r\nCREATE EVENT SESSION [MySpCounter] ON SERVER\r\nADD EVENT sqlserver.sql_batch_completed(SET collect_batch_text=(1)\r\nACTION(sqlserver.database_name,sqlserver.sql_text)\r\nWHERE ([sqlserver].[like_i_sql_unicode_string]([sqlserver].[sql_text],N'%exec dbo.GetUserByReput%')))\r\nADD TARGET package0.event_counter\r\nWITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 SECONDS,MAX_EVENT_SIZE=0 KB, MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=OFF,STARTUP_STATE=ON)\r\nGO\r\nALTER EVENT SESSION MySpCounter ON SERVER STATE = START ; \r\n\r\n<\/pre>\n
Ici, je trace donc sur le serveur l’ex\u00e9cution de la proc\u00e9dure dbo.GetUserByRep (suivi d’un % pour r\u00e9cup\u00e9rer tout ce qui pourrait \u00eatre plac\u00e9 en param\u00e8tre).<\/p>\n
Pour pouvoir exploiter le r\u00e9sultat de cette Extended Events, j’ai besoin d’une petite table qui contiendra les informations :<\/p>\n
\r\n\r\nCREATE TABLE [dbo].[MySPCounter](\r\n[id] [int] IDENTITY(1,1) NOT NULL,\r\n[measure_date] [datetime] NOT NULL,\r\n[value] [int] NOT NULL )\r\n\r\n<\/pre>\n
Celle-ci contient donc un identifiant (au cas o\u00f9…), une date de mesure de l’Extended Event, et la valeur du compteur.<\/p>\n
Ensuite, je fais un job dans l’agent qui ira lire la valeur de ce compteur, l\u2019ins\u00e9rera dans la table et remet enfin le compteur \u00e0 z\u00e9ro. Ici, je ne mettrai pas le code de cr\u00e9ation du job, mais juste de son contenu :<\/p>\n
\r\n\r\ndeclare @MyValue int\r\nselect @MyValue = execution_count FROM sys.dm_xe_session_targets AS xet\r\nJOIN sys.dm_xe_sessions AS xe\r\nON (xe.address = xet.event_session_address)\r\nWHERE xe.name = 'MySpCounter' and target_name = 'event_counter'\r\n\r\nINSERT INTO msdb.dbo.MySPCounter values (getdate(), @MyValue)\r\n\r\nalter event session MySpCounter ON server STATE = STOP ;\r\nalter event session MySpCounter ON server STATE = START;\r\n\r\n<\/pre>\n
On retrouvera donc une table o\u00f9 \u00e0 intervalle r\u00e9gulier, on aura le nombre d’ex\u00e9cution de notre proc\u00e9dure stock\u00e9e ! Il n’y a plus qu’\u00e0 connecter un Excel, un PowerBI ou l’outil que vous pr\u00e9f\u00e9rez, et vous pourrez faire de jolis graphiques qui raviront vos responsables m\u00e9tiers.<\/p>\n
\"\"<\/p>\n
 <\/p>\n\"twitter\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>","protected":false},"excerpt":{"rendered":"
Pour des raisons purement m\u00e9tier, il m’a \u00e9t\u00e9 demand\u00e9 le nombre d’ex\u00e9cutions horaires d’une proc\u00e9dure stock\u00e9e “m\u00e9tier”. Le but \u00e9tait d’identifier les variations d’utilisation de la plateforme, sans se reposer sur des indicateurs trop techniques (charge CPU, batch request\/sec ,… Continuer la lecture →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":7506,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[322,323,319,318,320,321],"class_list":["post-7479","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqlserver","tag-comptage","tag-compter","tag-evenements-etendus","tag-extended-events","tag-procedure-stockees","tag-stored-procedures"],"yoast_head":"\nD\u00e9terminer la fr\u00e9quence horaire d'ex\u00e9cution d'une proc\u00e9dure stock\u00e9e sous SQL Server - 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\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"D\u00e9terminer la fr\u00e9quence horaire d'ex\u00e9cution d'une proc\u00e9dure stock\u00e9e sous SQL Server - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"Pour des raisons purement m\u00e9tier, il m’a \u00e9t\u00e9 demand\u00e9 le nombre d’ex\u00e9cutions horaires d’une proc\u00e9dure stock\u00e9e “m\u00e9tier”. Le but \u00e9tait d’identifier les variations d’utilisation de la plateforme, sans se reposer sur des indicateurs trop techniques (charge CPU, batch request\/sec ,… Continuer la lecture →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-09T16:02:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-21T15:54:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2019\/05\/graphs_appels_SP.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"816\" \/>\n\t<meta property=\"og:image:height\" content=\"431\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Capdata team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Capdata team\" \/>\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\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/\"},\"author\":{\"name\":\"Capdata team\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9\"},\"headline\":\"D\u00e9terminer la fr\u00e9quence horaire d’ex\u00e9cution d’une proc\u00e9dure stock\u00e9e sous SQL Server\",\"datePublished\":\"2019-05-09T16:02:53+00:00\",\"dateModified\":\"2022-11-21T15:54:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/\"},\"wordCount\":628,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"comptage\",\"compter\",\"\u00e9venements \u00e9tendus\",\"extended events\",\"proc\u00e9dure stock\u00e9es\",\"stored procedures\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/\",\"name\":\"D\u00e9terminer la fr\u00e9quence horaire d'ex\u00e9cution d'une proc\u00e9dure stock\u00e9e sous SQL Server - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2019-05-09T16:02:53+00:00\",\"dateModified\":\"2022-11-21T15:54:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"D\u00e9terminer la fr\u00e9quence horaire d’ex\u00e9cution d’une proc\u00e9dure stock\u00e9e sous SQL Server\"}]},{\"@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\/bfd9395c8ba4fa125792a543377035e9\",\"name\":\"Capdata team\",\"sameAs\":[\"https:\/\/www.capdata.fr\"],\"url\":\"https:\/\/blog.capdata.fr\/index.php\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"D\u00e9terminer la fr\u00e9quence horaire d'ex\u00e9cution d'une proc\u00e9dure stock\u00e9e sous SQL Server - 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\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/","og_locale":"fr_FR","og_type":"article","og_title":"D\u00e9terminer la fr\u00e9quence horaire d'ex\u00e9cution d'une proc\u00e9dure stock\u00e9e sous SQL Server - Capdata TECH BLOG","og_description":"Pour des raisons purement m\u00e9tier, il m’a \u00e9t\u00e9 demand\u00e9 le nombre d’ex\u00e9cutions horaires d’une proc\u00e9dure stock\u00e9e “m\u00e9tier”. Le but \u00e9tait d’identifier les variations d’utilisation de la plateforme, sans se reposer sur des indicateurs trop techniques (charge CPU, batch request\/sec ,… Continuer la lecture →","og_url":"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2019-05-09T16:02:53+00:00","article_modified_time":"2022-11-21T15:54:26+00:00","og_image":[{"width":816,"height":431,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2019\/05\/graphs_appels_SP.jpg","type":"image\/jpeg"}],"author":"Capdata team","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Capdata team","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/"},"author":{"name":"Capdata team","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9"},"headline":"D\u00e9terminer la fr\u00e9quence horaire d’ex\u00e9cution d’une proc\u00e9dure stock\u00e9e sous SQL Server","datePublished":"2019-05-09T16:02:53+00:00","dateModified":"2022-11-21T15:54:26+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/"},"wordCount":628,"commentCount":0,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["comptage","compter","\u00e9venements \u00e9tendus","extended events","proc\u00e9dure stock\u00e9es","stored procedures"],"articleSection":["SQL Server"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/","url":"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/","name":"D\u00e9terminer la fr\u00e9quence horaire d'ex\u00e9cution d'une proc\u00e9dure stock\u00e9e sous SQL Server - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2019-05-09T16:02:53+00:00","dateModified":"2022-11-21T15:54:26+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/determiner-la-frequence-horaire-dexecution-dune-procedure-stockee-sous-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"D\u00e9terminer la fr\u00e9quence horaire d’ex\u00e9cution d’une proc\u00e9dure stock\u00e9e sous SQL Server"}]},{"@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\/bfd9395c8ba4fa125792a543377035e9","name":"Capdata team","sameAs":["https:\/\/www.capdata.fr"],"url":"https:\/\/blog.capdata.fr\/index.php\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/7479","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=7479"}],"version-history":[{"count":6,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/7479\/revisions"}],"predecessor-version":[{"id":9511,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/7479\/revisions\/9511"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/7506"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=7479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=7479"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=7479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}