{"id":556,"date":"2010-12-08T22:53:00","date_gmt":"2010-12-08T22:53:00","guid":{"rendered":"\/blogs\/jonathan\/post\/An-XEvent-a-Day-(8-of-31)-Targets-Week-synchronous_event_counter.aspx"},"modified":"2017-04-13T12:18:35","modified_gmt":"2017-04-13T16:18:35","slug":"an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/","title":{"rendered":"An XEvent a Day (8 of 31) – Targets Week – synchronous_event_counter"},"content":{"rendered":"

Yesterday\u2019s post, Targets Week – Bucketizers<\/a>, looked at the bucketizer Targets in Extended Events and how they can be used to simplify analysis and perform more targeted analysis based on their output.  Today\u2019s post will be fairly short, by comparison to the previous posts, while we look at the synchronous_event_counter target, which can be used to test the impact of an Event Session without actually incurring the cost of Event collection.<\/p>\n

What is the synchronous_event_counter?<\/h2>\n

The synchronous_event_count simply put, is a Target that counts the number of Events that fire for a given Event Session.  It can be used to test whether or not the defined Predicates on Events in an Event Session perform the level of filtering expected, without having to actually perform full Event collection using one of the raw Event data targets like the ring_buffer or asynchronous_file_target.  The Target is synchronous however, due to the fact that it only counts the number of times each Event fires, its impact is minimized in comparison to the other synchronous targets available.  Like the ring_buffer and bucketizer, the synchronous_event_counter Target is a memory resident Target that holds event data in memory while the Event Session is active on the SQL Server.  When the Event Session is stopped, the memory buffers allocated to the synchronous_event_counter target are freed and any information contained in the target is lost. <\/p>\n

Configuration Options<\/h2>\n

There are no configuration options for the synchronous_event_counter Target. (see I said this was going to be a short post comparatively).<\/p>\n

\n
 -- Target Configurable Fields\r\n<\/span>SELECT \r\n   <\/span>oc.<\/span>name AS <\/span>column_name,\r\n   <\/span>oc.<\/span>column_id,\r\n   <\/span>oc.<\/span>type_name<\/span>,\r\n   <\/span>oc.<\/span>capabilities_desc,\r\n   <\/span>oc.<\/span>description\r\nFROM <\/span>sys<\/span>.<\/span>dm_xe_packages <\/span>AS <\/span>p\r\nJOIN <\/span>sys<\/span>.<\/span>dm_xe_objects <\/span>AS <\/span>o \r\n    ON <\/span>p.<\/span>guid <\/span>= <\/span>o.<\/span>package_guid\r\nJOIN <\/span>sys<\/span>.<\/span>dm_xe_object_columns <\/span>AS <\/span>oc \r\n    ON <\/span>o.<\/span>name = <\/span>oc.<\/span>OBJECT_NAME \r\n   <\/span>AND <\/span>o.<\/span>package_guid = <\/span>oc.<\/span>object_package_guid\r\nWHERE<\/span>(<\/span>p.<\/span>capabilities IS NULL OR <\/span>p.<\/span>capabilities & <\/span>1 = <\/span>0)\r\n  AND (<\/span>o.<\/span>capabilities IS NULL OR <\/span>o.<\/span>capabilities & <\/span>1 = <\/span>0)\r\n  AND <\/span>o.<\/span>object_type = <\/span>'target'\r\n  <\/span>AND <\/span>o.<\/span>name = <\/span>'synchronous_event_counter'<\/span><\/pre>\n
  <\/a><\/a><\/p><\/blockquote>\n
\"image\"<\/a> <\/p>\n
Understanding the Target Data Format<\/h2>\n
Like the ring_buffer and bucketizer Targets, the synchronous_event_counter Target returns its information by querying the sys.dm_xe_session_targets DMV, and it returns the Target data in an XML format that is not schema bound, but that has a standardized format.  The synchronous_event_counter Target has a very simple XML document, much like the bucketizer Targets.  The root node of the XML is the <CounterTarget> node which has a child node <Packages> which has a child <Package> node for each package that identifies the package using an @name attribute.  Each <Package> node will have one or more <Event> nodes based on the number of Events defined in the Event Session for that particular package.  The <Event> nodes each will contain two attributes, the name of the event and the count for its occurrence since the Event Session started.  A simplified representation of the XML output by the synchronous_event_counter Target is below:<\/p>\n
\n
<<\/span>CounterTarget <\/span>truncated<\/span>=<\/span>"">\r\n  <<\/span>Packages<\/span>>\r\n    <<\/span>Package <\/span>name<\/span>=<\/span>"">\r\n      <<\/span>Event <\/span>name<\/span>=<\/span>"" count<\/span>=<\/span>"" \/>\r\n    <\/<\/span>Package<\/span>>\r\n  <\/<\/span>Packages<\/span>>\r\n<\/<\/span>CounterTarget<\/span>><\/span><\/pre>\n
  <\/a><\/p><\/blockquote>\n
Querying\/Parsing the Target Data<\/h2>\n
Like the other memory resident Targets in Extended Events, the synchronous_event_counter Target data is only exposed by querying the sys.dm_xe_session_targets DMV.  The following example will demonstrate how the synchronous_event_counter can be used to test the number of Events that an Event Session will generate:<\/p>\n
<\/blockquote>\n
\n
-- Create an Event Session to Track Recompiles\r\n<\/span>IF <\/span>EXISTS(<\/span>SELECT <\/span>* <\/span>FROM <\/span>sys<\/span>.<\/span>server_event_sessions <\/span>WHERE <\/span>name=<\/span>'CounterTargetDemo'<\/span>)\r\n    <\/span>DROP EVENT SESSION <\/span>[CounterTargetDemo] ON SERVER<\/span>;\r\n<\/span>CREATE EVENT SESSION <\/span>[CounterTargetDemo]\r\nON SERVER\r\nADD EVENT <\/span>sqlserver.<\/span>sql_statement_starting,\r\n<\/span>ADD EVENT <\/span>sqlos.<\/span>wait_info\r\n(    <\/span>WHERE <\/span>(<\/span>duration > <\/span>0))\r\n<\/span>ADD TARGET <\/span>package0.<\/span>synchronous_event_counter\r\nGO\r\n\r\n<\/span>-- Start the Event Session\r\n<\/span>ALTER EVENT SESSION <\/span>[CounterTargetDemo]\r\nON SERVER\r\nSTATE<\/span>=<\/span>STOP\r\nGO\r\n\r\n<\/span>-- Wait for Events to generate and then Query Target\r\n\r\n-- Query the Target\r\n<\/span>SELECT \r\n    <\/span>n.<\/span>value(<\/span>'..\/@name[1]'<\/span>, <\/span>'varchar(50)'<\/span>) <\/span>as <\/span>PackageName,\r\n    <\/span>n.<\/span>value(<\/span>'@name[1]'<\/span>, <\/span>'varchar(50)'<\/span>) <\/span>as <\/span>EventName,\r\n    <\/span>n.<\/span>value(<\/span>'@count[1]'<\/span>, <\/span>'int'<\/span>) <\/span>as <\/span>Occurence\r\nFROM\r\n<\/span>(\r\n<\/span>SELECT <\/span>CAST<\/span>(<\/span>target_data AS XML<\/span>) <\/span>as <\/span>target_data\r\nFROM <\/span>sys<\/span>.<\/span>dm_xe_sessions <\/span>AS <\/span>s \r\nJOIN <\/span>sys<\/span>.<\/span>dm_xe_session_targets <\/span>AS <\/span>t \r\n    ON <\/span>t.<\/span>event_session_address = <\/span>s.<\/span>address\r\nWHERE <\/span>s.<\/span>name = <\/span>'CounterTargetDemo'\r\n  <\/span>AND <\/span>t.<\/span>target_name = <\/span>'synchronous_event_counter'\r\n<\/span>) <\/span>as <\/span>tab\r\nCROSS APPLY <\/span>target_data.<\/span>nodes(<\/span>'CounterTarget\/Packages\/Package\/Event'<\/span>) <\/span>as <\/span>q(<\/span>n)\r\n\r\n<\/span>-- Drop the Event Session\r\n<\/span>IF <\/span>EXISTS(<\/span>SELECT <\/span>* <\/span>FROM <\/span>sys<\/span>.<\/span>server_event_sessions <\/span>WHERE <\/span>name=<\/span>'CounterTargetDemo'<\/span>)\r\n    <\/span>DROP EVENT SESSION <\/span>[CounterTargetDemo] ON SERVER<\/span>;<\/span><\/pre>\n
  <\/a><\/p><\/blockquote>\n
This session on one of my test servers generated the following output while running for less than five seconds:<\/p>\n
\"image\"<\/a> <\/p>\n
Based on this number of Events being fired, it may be determined that the predicates for the session need to provide further filtering of the Events, or if it is determined that the Predicates are filtering the Events as intended, this at least lets us know that the number of Events firing will require the use of the asynchronous_file_target, if the plan is to look at the Events raw data.<\/p>\n
Considerations for Usage<\/h2>\n
The only real consideration associated with the synchronous_event_counter Target is that it is an synchronous Target.  However, since it is only counting the occurrences of the Events defined in the Event Session and is not actually buffering the data for dispatch its impact is not generally a concern.<\/p>\n
What\u2019s next?<\/h2>\n
Now that we have looked at the ring_buffer, asynchronous_file_target, bucketizers, and synchronous_file_target Targets, in the next post we\u2019ll look at the pair_matching Target, which can be used to match up related Events based on specific criteria to discard the matched pairs, leaving unmatched and potentially problematic Events for analysis.  <\/p>\n","protected":false},"excerpt":{"rendered":"
Yesterday\u2019s post, Targets Week – Bucketizers, looked at the bucketizer Targets in Extended Events and how they can be used to simplify analysis and perform more targeted analysis based on their output.  Today\u2019s post will be fairly short, by comparison to the previous posts, while we look at the synchronous_event_counter target, which can be used […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,38,45],"tags":[],"class_list":["post-556","post","type-post","status-publish","format-standard","hentry","category-extended-events","category-sql-server-2008","category-xevent-a-day-series"],"yoast_head":"\nAn XEvent a Day (8 of 31) - Targets Week - synchronous_event_counter - Jonathan Kehayias<\/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:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"An XEvent a Day (8 of 31) - Targets Week - synchronous_event_counter - Jonathan Kehayias\" \/>\n<meta property=\"og:description\" content=\"Yesterday\u2019s post, Targets Week – Bucketizers, looked at the bucketizer Targets in Extended Events and how they can be used to simplify analysis and perform more targeted analysis based on their output.  Today\u2019s post will be fairly short, by comparison to the previous posts, while we look at the synchronous_event_counter target, which can be used […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/\" \/>\n<meta property=\"og:site_name\" content=\"Jonathan Kehayias\" \/>\n<meta property=\"article:published_time\" content=\"2010-12-08T22:53:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T16:18:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windowslivewriter\/anxeventaday8of31targetsweeksynchronous_\/766790d7\/image_thumb.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=\"5 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\\\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\\\/\"},\"author\":{\"name\":\"Jonathan Kehayias\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"headline\":\"An XEvent a Day (8 of 31) – Targets Week – synchronous_event_counter\",\"datePublished\":\"2010-12-08T22:53:00+00:00\",\"dateModified\":\"2017-04-13T16:18:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\\\/\"},\"wordCount\":714,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.SQLskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windowslivewriter\\\/anxeventaday8of31targetsweeksynchronous_\\\/766790d7\\\/image_thumb.png\",\"articleSection\":[\"Extended Events\",\"SQL Server 2008\",\"XEvent a Day Series\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\\\/\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\\\/\",\"name\":\"An XEvent a Day (8 of 31) - Targets Week - synchronous_event_counter - Jonathan Kehayias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.SQLskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windowslivewriter\\\/anxeventaday8of31targetsweeksynchronous_\\\/766790d7\\\/image_thumb.png\",\"datePublished\":\"2010-12-08T22:53:00+00:00\",\"dateModified\":\"2017-04-13T16:18:35+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.SQLskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windowslivewriter\\\/anxeventaday8of31targetsweeksynchronous_\\\/766790d7\\\/image_thumb.png\",\"contentUrl\":\"https:\\\/\\\/www.SQLskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windowslivewriter\\\/anxeventaday8of31targetsweeksynchronous_\\\/766790d7\\\/image_thumb.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Extended Events\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/category\\\/extended-events\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"An XEvent a Day (8 of 31) – Targets Week – synchronous_event_counter\"}]},{\"@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":"An XEvent a Day (8 of 31) - Targets Week - synchronous_event_counter - Jonathan Kehayias","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\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/","og_locale":"en_US","og_type":"article","og_title":"An XEvent a Day (8 of 31) - Targets Week - synchronous_event_counter - Jonathan Kehayias","og_description":"Yesterday\u2019s post, Targets Week – Bucketizers, looked at the bucketizer Targets in Extended Events and how they can be used to simplify analysis and perform more targeted analysis based on their output.  Today\u2019s post will be fairly short, by comparison to the previous posts, while we look at the synchronous_event_counter target, which can be used […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/","og_site_name":"Jonathan Kehayias","article_published_time":"2010-12-08T22:53:00+00:00","article_modified_time":"2017-04-13T16:18:35+00:00","og_image":[{"url":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windowslivewriter\/anxeventaday8of31targetsweeksynchronous_\/766790d7\/image_thumb.png","type":"","width":"","height":""}],"author":"Jonathan Kehayias","twitter_misc":{"Written by":"Jonathan Kehayias","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/#article","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/"},"author":{"name":"Jonathan Kehayias","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"headline":"An XEvent a Day (8 of 31) – Targets Week – synchronous_event_counter","datePublished":"2010-12-08T22:53:00+00:00","dateModified":"2017-04-13T16:18:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/"},"wordCount":714,"commentCount":1,"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/#primaryimage"},"thumbnailUrl":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windowslivewriter\/anxeventaday8of31targetsweeksynchronous_\/766790d7\/image_thumb.png","articleSection":["Extended Events","SQL Server 2008","XEvent a Day Series"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/","name":"An XEvent a Day (8 of 31) - Targets Week - synchronous_event_counter - Jonathan Kehayias","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/#primaryimage"},"thumbnailUrl":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windowslivewriter\/anxeventaday8of31targetsweeksynchronous_\/766790d7\/image_thumb.png","datePublished":"2010-12-08T22:53:00+00:00","dateModified":"2017-04-13T16:18:35+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/#primaryimage","url":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windowslivewriter\/anxeventaday8of31targetsweeksynchronous_\/766790d7\/image_thumb.png","contentUrl":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windowslivewriter\/anxeventaday8of31targetsweeksynchronous_\/766790d7\/image_thumb.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-8-of-31-targets-week-synchronous_event_counter\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/"},{"@type":"ListItem","position":2,"name":"Extended Events","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/category\/extended-events\/"},{"@type":"ListItem","position":3,"name":"An XEvent a Day (8 of 31) – Targets Week – synchronous_event_counter"}]},{"@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\/556","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=556"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/556\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/media?parent=556"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/categories?post=556"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/tags?post=556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}