{"id":19719,"date":"2023-02-20T11:44:14","date_gmt":"2023-02-20T16:44:14","guid":{"rendered":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/?p=19719"},"modified":"2023-02-20T12:20:24","modified_gmt":"2023-02-20T17:20:24","slug":"sql-server-2022-measuring-extended-events-performance-impacts","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/","title":{"rendered":"SQL Server 2022: Measuring Extended Events Performance Impacts"},"content":{"rendered":"\n<p>Have you ever wondered if Extended Events is affecting the performance of your workload? I have written a lot about Extended Events and have been a huge promoter of why you should be using Extended Events instead of SQL Trace for longer than I have worked at SQLskills.com. While Extended Events provides a lot of benefits to data collection with minimal overhead, there are still cases where observation overheads exist when collecting data even with Extended Events.<\/p>\n\n\n\n<p><a href=\"https:\/\/sqlperformance.com\/2012\/10\/sql-trace\/observer-overhead-trace-extended-events\">Measuring \u201cObserver Overhead\u201d of SQL Trace vs. Extended Events &#8211; SQLPerformance.com<\/a><\/p>\n\n\n\n<p>SQL Server 2022 offers a new feature enhancement to Extended Events that allows it to now track the performance and publishing metrics of the events that have been enabled in an event session that is running on the server. Four new columns were added in the <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/system-dynamic-management-views\/sys-dm-xe-session-events-transact-sql?view=azuresqldb-current&amp;viewFallbackFrom=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">sys.dm_xe_session_events<\/a> DMV in SQL Server 2022 that provide additional information about the event publishing performance metrics when an event session is running:<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><th>Column name<\/th><th>Data type<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>event_fire_count<\/td><td><strong>bigint<\/strong><\/td><td>The number of times the event has fired (was published) since the session was started. Is not nullable. Applies to SQL Server 2022 (16.x) and later.<\/td><\/tr><tr><td>event_fire_average_time<\/td><td><strong>bigint<\/strong><\/td><td>The average time taken to publish the event, in microseconds. Is not nullable. Applies to SQL Server 2022 (16.x) and later.<\/td><\/tr><tr><td>event_fire_min_time<\/td><td><strong>bigint<\/strong><\/td><td>The minimum time taken to publish the event, in microseconds. Is not nullable. Applies to SQL Server 2022 (16.x) and later.<\/td><\/tr><tr><td>event_fire_max_time<\/td><td><strong>bigint<\/strong><\/td><td>The maximum time taken to publish the event, in microseconds. Is not nullable. Applies to SQL Server 2022 (16.x) and later.<\/td><\/tr><\/tbody><\/table><figcaption>New columns added to sys.dm_xe_session_events in SQL Server 2022<\/figcaption><\/figure>\n\n\n\n<p>Two of the new columns, event_fire_count and event_fire_average_time, require that you enable Trace Flag 9708 for collection, which is documented in the Books Online:<\/p>\n\n\n\n<p><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/t-sql\/database-console-commands\/dbcc-traceon-trace-flags-transact-sql?view=sql-server-ver16\">Trace Flags (Transact-SQL) &#8211; SQL Server | Microsoft Learn<\/a><\/p>\n\n\n\n<p>These columns will not be populated without the trace flag turned on. The trace flag is global only, so it must be enabled with DBCC TRACEON(9708, -1). I took a look at the output of the following query without the trace flag enabled, and then again with it turned on:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT s.name AS session_name, \n\tevent_name,\n\tevent_fire_count,\n\tevent_fire_average_time, \n\tevent_fire_min_time, \n\tevent_fire_max_time\nFROM sys.dm_xe_sessions AS s \nINNER JOIN sys.dm_xe_session_events AS xse\n\tON s.address = xse.event_session_address\nORDER BY event_fire_max_time DESC<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2023\/02\/image-3.png\"><img decoding=\"async\" src=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2023\/02\/image-3-1024x253.png\" alt=\"Output of default extended events performance metrics without Trace Flag 9708.\"\/><\/a><figcaption>Output of default extended events performance metrics without Trace Flag 9708.<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2023\/02\/image-4.png\"><img decoding=\"async\" src=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2023\/02\/image-4-1024x238.png\" alt=\"Output of default events with Trace Flag 9708.\"\/><\/a><figcaption>Output of default extended events performance metrics with Trace Flag 9708.<\/figcaption><\/figure>\n\n\n\n<p>The trace flag is global only, so it must be enabled with DBCC TRACEON(9708, -1). While this system doesn&#8217;t have a huge workload running against it constantly, it is good to see that the overall impact of the default event sessions is quite low.<\/p>\n\n\n\n<p>However, I wanted to play around and do something incredibly stupid with this trace flag, so I created an event session on the same server named CrazyEvents, and did a SELECT ALL in the UI and added every non-debug channel event to the session and started it. I won&#8217;t be including a script for this, it&#8217;s a stupid idea to do to begin with and you can easily reproduce the session in the UI if you want to join me in the nuthouse. Be prepared to wait a few seconds to minutes while it adds that many events to the session though. I will note that editing the event session definition later in SSMS was sufficient enough to turn my laptop fans on.<\/p>\n\n\n\n<p>I was a little surprised by the results of this on a relatively quiesced system where the only queries being executed were related to creating this blog post. I didn&#8217;t expect 4.5ms of fire time for the wait_info event to pop up as the longest firing event from a relatively quiesced system.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2023\/02\/image-1.png\"><img decoding=\"async\" src=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2023\/02\/image-1-1024x463.png\" alt=\"CrazyEvents session firing metrics\"\/><\/a><figcaption>CrazyEvents extended event session event firing performance metrics<\/figcaption><\/figure>\n\n\n\n<p>While I don&#8217;t know that I would actually need to turn on the trace flag for the additional two columns, I do think that it is amazing that Microsoft has continued to invest in enhancements to Extended Events that allow for better diagnostics of the performance impacts caused by certain event sessions and the events being collected. Prior to the inclusion of these enhancements, there was no definitive means of determining if an event was impacting performance negatively and by how much aside from observation of behaviors with and without the event session running. Now there is a definitive means of determining whether an event is impacting performance negatively.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Have you ever wondered if Extended Events is affecting the performance of your workload? I have written a lot about Extended Events and have been a huge promoter of why you should be using Extended Events instead of SQL Trace for longer than I have worked at SQLskills.com. While Extended Events provides a lot of [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,64],"tags":[],"class_list":["post-19719","post","type-post","status-publish","format-standard","hentry","category-extended-events","category-sql-server-2022"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server 2022: Measuring Extended Events Performance Impacts - Jonathan Kehayias<\/title>\n<meta name=\"description\" content=\"Find out whether Extended Events sessions are negatively affecting performance on SQL Server 2022 quick and easy.\" \/>\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.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2022: Measuring Extended Events Performance Impacts - Jonathan Kehayias\" \/>\n<meta property=\"og:description\" content=\"Find out whether Extended Events sessions are negatively affecting performance on SQL Server 2022 quick and easy.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/\" \/>\n<meta property=\"og:site_name\" content=\"Jonathan Kehayias\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-20T16:44:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-20T17:20:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2023\/02\/image-3-1024x253.png\" \/>\n<meta name=\"author\" content=\"Jonathan Kehayias\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathan Kehayias\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-server-2022-measuring-extended-events-performance-impacts\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-server-2022-measuring-extended-events-performance-impacts\\\/\"},\"author\":{\"name\":\"Jonathan Kehayias\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"headline\":\"SQL Server 2022: Measuring Extended Events Performance Impacts\",\"datePublished\":\"2023-02-20T16:44:14+00:00\",\"dateModified\":\"2023-02-20T17:20:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-server-2022-measuring-extended-events-performance-impacts\\\/\"},\"wordCount\":736,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-server-2022-measuring-extended-events-performance-impacts\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/image-3-1024x253.png\",\"articleSection\":[\"Extended Events\",\"SQL Server 2022\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-server-2022-measuring-extended-events-performance-impacts\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-server-2022-measuring-extended-events-performance-impacts\\\/\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-server-2022-measuring-extended-events-performance-impacts\\\/\",\"name\":\"SQL Server 2022: Measuring Extended Events Performance Impacts - Jonathan Kehayias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-server-2022-measuring-extended-events-performance-impacts\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-server-2022-measuring-extended-events-performance-impacts\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/image-3-1024x253.png\",\"datePublished\":\"2023-02-20T16:44:14+00:00\",\"dateModified\":\"2023-02-20T17:20:24+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"description\":\"Find out whether Extended Events sessions are negatively affecting performance on SQL Server 2022 quick and easy.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-server-2022-measuring-extended-events-performance-impacts\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-server-2022-measuring-extended-events-performance-impacts\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-server-2022-measuring-extended-events-performance-impacts\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/image-3.png\",\"contentUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/image-3.png\",\"width\":1259,\"height\":311},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/sql-server-2022-measuring-extended-events-performance-impacts\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2022\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/category\\\/sql-server-2022\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL Server 2022: Measuring Extended Events Performance Impacts\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\",\"name\":\"Jonathan Kehayias - The Rambling DBA\",\"description\":\"The Rambling DBA\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\",\"name\":\"Jonathan Kehayias\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"caption\":\"Jonathan Kehayias\"},\"sameAs\":[\"http:\\\/\\\/3.209.169.194\\\/blogs\\\/jonathan\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2022: Measuring Extended Events Performance Impacts - Jonathan Kehayias","description":"Find out whether Extended Events sessions are negatively affecting performance on SQL Server 2022 quick and easy.","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.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2022: Measuring Extended Events Performance Impacts - Jonathan Kehayias","og_description":"Find out whether Extended Events sessions are negatively affecting performance on SQL Server 2022 quick and easy.","og_url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/","og_site_name":"Jonathan Kehayias","article_published_time":"2023-02-20T16:44:14+00:00","article_modified_time":"2023-02-20T17:20:24+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2023\/02\/image-3-1024x253.png","type":"","width":"","height":""}],"author":"Jonathan Kehayias","twitter_misc":{"Written by":"Jonathan Kehayias","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/#article","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/"},"author":{"name":"Jonathan Kehayias","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"headline":"SQL Server 2022: Measuring Extended Events Performance Impacts","datePublished":"2023-02-20T16:44:14+00:00","dateModified":"2023-02-20T17:20:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/"},"wordCount":736,"commentCount":0,"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2023\/02\/image-3-1024x253.png","articleSection":["Extended Events","SQL Server 2022"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/","name":"SQL Server 2022: Measuring Extended Events Performance Impacts - Jonathan Kehayias","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2023\/02\/image-3-1024x253.png","datePublished":"2023-02-20T16:44:14+00:00","dateModified":"2023-02-20T17:20:24+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"description":"Find out whether Extended Events sessions are negatively affecting performance on SQL Server 2022 quick and easy.","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2023\/02\/image-3.png","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2023\/02\/image-3.png","width":1259,"height":311},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/sql-server-2022-measuring-extended-events-performance-impacts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2022","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/category\/sql-server-2022\/"},{"@type":"ListItem","position":3,"name":"SQL Server 2022: Measuring Extended Events Performance Impacts"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/","name":"Jonathan Kehayias - The Rambling DBA","description":"The Rambling DBA","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c","name":"Jonathan Kehayias","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","caption":"Jonathan Kehayias"},"sameAs":["http:\/\/3.209.169.194\/blogs\/jonathan"]}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/19719","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/comments?post=19719"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/19719\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/media?parent=19719"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/categories?post=19719"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/tags?post=19719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}