{"id":505,"date":"2011-11-22T00:14:00","date_gmt":"2011-11-22T00:14:00","guid":{"rendered":"\/blogs\/jonathan\/post\/New-AlwaysOn_health-Extended-Events-Session-in-SQL-Server-2012-RC0.aspx"},"modified":"2011-11-22T00:14:00","modified_gmt":"2011-11-22T00:14:00","slug":"new-alwayson_health-extended-events-session-in-sql-server-2012-rc0","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\/","title":{"rendered":"New AlwaysOn_health Extended Events Session in SQL Server 2012 RC0"},"content":{"rendered":"

\nWhile setting up my new Availability Group using SQL Server 2012 RC0 tonight, I noticed an interesting new addition to Extended Events associated with Availability Group configuration in the Release Candidate.  When you setup an Availability Group in RC0, another default Event Session is created on the servers that participate in the Availability Group to provide monitoring of the health of the Availability Group overall.  The definition of the monitoring session is as follows:\n<\/p>\n

\n

\n\tCREATE EVENT SESSION [AlwaysOn_health] ON SERVER
\n\tADD EVENT sqlserver.alwayson_ddl_executed,
\n\tADD EVENT sqlserver.availability_group_lease_expired,
\n\tADD EVENT sqlserver.availability_replica_automatic_failover_validation,
\n\tADD EVENT sqlserver.availability_replica_manager_state_change,
\n\tADD EVENT sqlserver.availability_replica_state_change,
\n\tADD EVENT sqlserver.error_reported(
\n\t    WHERE ([error_number]=(9691) OR [error_number]=(35204) OR [error_number]=(9693) OR [error_number]=(26024) OR [error_number]=(28047) OR [error_number]=(26023) OR [error_number]=(9692) OR [error_number]=(28034) OR [error_number]=(28036) OR [error_number]=(28048) OR [error_number]=(28080) OR [error_number]=(28091) OR [error_number]=(26022) OR [error_number]=(9642) OR [error_number]=(35201) OR [error_number]=(35202) OR [error_number]=(35206) OR [error_number]=(35207) OR [error_number]=(26069) OR [error_number]=(26070) OR [error_number]>(41047) AND [error_number]<(41056) OR [error_number]=(41142) OR [error_number]=(41144) OR [error_number]=(1480) OR [error_number]=(823) OR [error_number]=(824) OR [error_number]=(829) OR [error_number]=(35264) OR [error_number]=(35265))),
\n\tADD EVENT sqlserver.lock_redo_blocked
\n\tADD TARGET package0.event_file(SET filename=N'AlwaysOn_health.xel',max_file_size=(5),max_rollover_files=(4))
\n\tWITH (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)
\n\tGO\n\t<\/p>\n<\/blockquote>\n

\nThis Extended Event Session monitors a number of critical events in the system but one of the problems with figuring out what exactly this Event Session is monitoring is to figure out what all the predicate values on the sqlserver.error_reported event are actually firing on.  To that aspect of things, we can do a quick reuse of the predicate on this event be doing a replace SSMS on the [error_number] value with a replace for an alias to a query to sys.messages, on the message_id column from the DMV as follows:\n<\/p>\n

\n

\n\tSELECT message_id, severity, is_event_logged, text
\n\tFROM sys.messages AS m
\n\tWHERE m.language_id = SERVERPROPERTY('LCID')
\n\t  AND  (m.message_id=(9691)
\n\t        OR m.message_id=(35204)
\n\t        OR m.message_id=(9693)
\n\t        OR m.message_id=(26024)
\n\t        OR m.message_id=(28047)
\n\t        OR m.message_id=(26023)
\n\t        OR m.message_id=(9692)
\n\t        OR m.message_id=(28034)
\n\t        OR m.message_id=(28036)
\n\t        OR m.message_id=(28048)
\n\t        OR m.message_id=(28080)
\n\t        OR m.message_id=(28091)
\n\t        OR m.message_id=(26022)
\n\t        OR m.message_id=(9642)
\n\t        OR m.message_id=(35201)
\n\t        OR m.message_id=(35202)
\n\t        OR m.message_id=(35206)
\n\t        OR m.message_id=(35207)
\n\t        OR m.message_id=(26069)
\n\t        OR m.message_id=(26070)
\n\t        OR m.message_id>(41047)
\n\t        AND m.message_id<(41056)
\n\t        OR m.message_id=(41142)
\n\t        OR m.message_id=(41144)
\n\t        OR m.message_id=(1480)
\n\t        OR m.message_id=(823)
\n\t        OR m.message_id=(824)
\n\t        OR m.message_id=(829)
\n\t        OR m.message_id=(35264)
\n\t        OR m.message_id=(35265)
\n\t)\n\t<\/p>\n<\/blockquote>\n

\nThis will give us a list of the error messages that the Event Session will actually fire events for:\n<\/p>\n

<\/font><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

\n\t\t\tmessage_id<\/font><\/strong>\n\t\t\t<\/p>\n<\/td>\n

severity<\/font><\/strong><\/td>\nis_event_logged<\/font><\/strong><\/td>\ntext<\/font><\/strong><\/td>\n<\/tr>\n
823<\/font><\/td>\n24<\/font><\/td>\n1<\/font><\/td>\nThe operating system returned error %ls to SQL Server during a %S_MSG at offset %#016I64x in file '%ls'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.<\/font><\/td>\n<\/tr>\n
824<\/font><\/td>\n24<\/font><\/td>\n1<\/font><\/td>\nSQL Server detected a logical consistency-based I\/O error: %ls. It occurred during a %S_MSG of page %S_PGID in database ID %d at offset %#016I64x in file '%ls'.  <\/span>Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.<\/font><\/td>\n<\/tr>\n
829<\/font><\/td>\n21<\/font><\/td>\n1<\/font><\/td>\nDatabase ID %d, Page %S_PGID is marked RestorePending, which may indicate disk corruption. To recover from this state, perform a restore.<\/font><\/td>\n<\/tr>\n
1480<\/font><\/td>\n10<\/font><\/td>\n0<\/font><\/td>\nThe %S_MSG database "%.*ls" is changing roles from "%ls" to "%ls" because the mirroring session or availability group failed over due to %S_MSG. This is an informational message only. No user action is required.<\/font><\/td>\n<\/tr>\n
9642<\/font><\/td>\n16<\/font><\/td>\n0<\/font><\/td>\nAn error occurred in a Service Broker\/Database Mirroring transport connection endpoint, Error: %i, State: %i. (Near endpoint role: %S_MSG, far endpoint address: '%.*hs')<\/font><\/td>\n<\/tr>\n
9691<\/font><\/td>\n10<\/font><\/td>\n0<\/font><\/td>\nThe %S_MSG endpoint has stopped listening for connections.<\/font><\/td>\n<\/tr>\n
9692<\/font><\/td>\n16<\/font><\/td>\n0<\/font><\/td>\nThe %S_MSG endpoint cannot listen on port %d because it is in use by another process.<\/font><\/td>\n<\/tr>\n
9693<\/font><\/td>\n16<\/font><\/td>\n0<\/font><\/td>\nThe %S_MSG endpoint cannot listen for connections due to the following error: '%.*ls'.<\/font><\/td>\n<\/tr>\n
26022<\/font><\/td>\n10<\/font><\/td>\n1<\/font><\/td>\nServer is listening on [ %hs <%hs> %d].<\/font><\/td>\n<\/tr>\n
26023<\/font><\/td>\n16<\/font><\/td>\n1<\/font><\/td>\nServer TCP provider failed to listen on [ %hs <%hs> %d]. Tcp port is already in use.<\/font><\/td>\n<\/tr>\n
26024<\/font><\/td>\n16<\/font><\/td>\n1<\/font><\/td>\nServer failed to listen on %hs <%hs> %d. Error: %#x. To proceed, notify your system administrator.<\/font><\/td>\n<\/tr>\n
26069<\/font><\/td>\n10<\/font><\/td>\n1<\/font><\/td>\nStarted listening on virtual network name '%ls'. No user action is required.<\/font><\/td>\n<\/tr>\n
26070<\/font><\/td>\n10<\/font><\/td>\n1<\/font><\/td>\nStopped listening on virtual network name '%ls'. No user action is required.<\/font><\/td>\n<\/tr>\n
28034<\/font><\/td>\n10<\/font><\/td>\n0<\/font><\/td>\nConnection handshake failed. The login '%.*ls' does not have CONNECT permission on the endpoint. State %d.<\/font><\/td>\n<\/tr>\n
28036<\/font><\/td>\n10<\/font><\/td>\n0<\/font><\/td>\nConnection handshake failed. The certificate used by this endpoint was not found: %S_MSG. Use DBCC CHECKDB in master database to verify the metadata integrity of the endpoints. State %d.<\/font><\/td>\n<\/tr>\n
28047<\/font><\/td>\n10<\/font><\/td>\n1<\/font><\/td>\n%S_MSG login attempt failed with error: '%.*ls'. %.*ls<\/font><\/td>\n<\/tr>\n
28048<\/font><\/td>\n10<\/font><\/td>\n1<\/font><\/td>\n%S_MSG login attempt by user '%.*ls' failed with error: '%.*ls'. %.*ls<\/font><\/td>\n<\/tr>\n
28080<\/font><\/td>\n10<\/font><\/td>\n0<\/font><\/td>\nConnection handshake failed. The %S_MSG endpoint is not configured. State %d.<\/font><\/td>\n<\/tr>\n
28091<\/font><\/td>\n10<\/font><\/td>\n0<\/font><\/td>\n <\/span>Starting endpoint for %S_MSG with no authentication is not supported.<\/font><\/td>\n<\/tr>\n
35201<\/font><\/td>\n10<\/font><\/td>\n0<\/font><\/td>\nA connection timeout has occurred while attempting to establish a connection to availability replica '%ls' with id [%ls]. Either a networking or firewall issue exists, or the endpoint address provided for the replica is not the database mirroring endpoint of the host server instance.<\/font><\/td>\n<\/tr>\n
35202<\/font><\/td>\n10<\/font><\/td>\n0<\/font><\/td>\nA connection for availability group '%ls' from availability replica '%ls' with id  <\/span>[%ls] to '%ls' with id [%ls] has been successfully established.  <\/span>This is an informational message only. No user action is required.<\/font><\/td>\n<\/tr>\n
35204<\/font><\/td>\n10<\/font><\/td>\n0<\/font><\/td>\nThe connection between server instances '%ls' with id [%ls] and '%ls' with id [%ls] has been disabled because the database mirroring endpoint was either disabled or stopped. Restart the endpoint by using the ALTER ENDPOINT Transact-SQL statement with STATE = STARTED.<\/font><\/td>\n<\/tr>\n
35206<\/font><\/td>\n10<\/font><\/td>\n0<\/font><\/td>\nA connection timeout has occurred on a previously established connection to availability replica '%ls' with id [%ls].  <\/span>Either a networking or a firewall issue exists or the availability replica has transitioned to the resolving role.<\/font><\/td>\n<\/tr>\n
35207<\/font><\/td>\n16<\/font><\/td>\n0<\/font><\/td>\nConnection attempt on availability group id '%ls' from replica id '%ls' to replica id '%ls' failed because of error %d, severity %d, state %d.<\/font><\/td>\n<\/tr>\n
35264<\/font><\/td>\n10<\/font><\/td>\n0<\/font><\/td>\nAlwaysOn Availability Groups data movement for database '%.*ls' has been suspended for the following reason: "%S_MSG" (Source ID %d; Source string: '%.*ls'). To resume data movement on the database, you will need to resume the database manually. For information about how to resume an availability database, see SQL Server Books Online.<\/font><\/td>\n<\/tr>\n
35265<\/font><\/td>\n10<\/font><\/td>\n0<\/font><\/td>\nAlwaysOn Availability Groups data movement for database '%.*ls' has been resumed. This is an informational message only. No user action is required.<\/font><\/td>\n<\/tr>\n
41048<\/font><\/td>\n10<\/font><\/td>\n1<\/font><\/td>\nAlwaysOn Availability Groups: Local Windows Server Failover Clustering service has become unavailable. This is an informational message only. No user action is required.<\/font><\/td>\n<\/tr>\n
41049<\/font><\/td>\n10<\/font><\/td>\n1<\/font><\/td>\nAlwaysOn Availability Groups: Local Windows Server Failover Clustering node is no longer online. This is an informational message only. No user action is required.<\/font><\/td>\n<\/tr>\n
41050<\/font><\/td>\n10<\/font><\/td>\n1<\/font><\/td>\nAlwaysOn Availability Groups: Waiting for local Windows Server Failover Clustering service to start. This is an informational message only. No user action is required.<\/font><\/td>\n<\/tr>\n
41051<\/font><\/td>\n10<\/font><\/td>\n1<\/font><\/td>\nAlwaysOn Availability Groups: Local Windows Server Failover Clustering service started. This is an informational message only. No user action is required.<\/font><\/td>\n<\/tr>\n
41052<\/font><\/td>\n10<\/font><\/td>\n1<\/font><\/td>\nAlwaysOn Availability Groups: Waiting for local Windows Server Failover Clustering node to start. This is an informational message only. No user action is required.<\/font><\/td>\n<\/tr>\n
41053<\/font><\/td>\n10<\/font><\/td>\n1<\/font><\/td>\nAlwaysOn Availability Groups: Local Windows Server Failover Clustering node started. This is an informational message only. No user action is required.<\/font><\/td>\n<\/tr>\n
41054<\/font><\/td>\n10<\/font><\/td>\n1<\/font><\/td>\nAlwaysOn Availability Groups: Waiting for local Windows Server Failover Clustering node to come online. This is an informational message only. No user action is required.<\/font><\/td>\n<\/tr>\n
41055<\/font><\/td>\n10<\/font><\/td>\n1<\/font><\/td>\nAlwaysOn Availability Groups: Local Windows Server Failover Clustering node is online. This is an informational message only. No user action is required.<\/font><\/td>\n<\/tr>\n
41142<\/font><\/td>\n16<\/font><\/td>\n0<\/font><\/td>\nThe availability replica for availability group '%.*ls' on this instance of SQL Server cannot become the primary replica. One or more databases are not synchronized or have not joined the availability group, or the WSFC cluster was started in Force Quorum mode. If the cluster was started in Force Quorum mode or the availability replica uses the asynchronous-commit mode, consider performing a forced manual failover (with possible data loss). Otherwise, once all local secondary databases are joined and synchronized, you can perform a planned manual failover to this secondary replica (without data loss). For more information, see SQL Server Books Online.<\/font><\/td>\n<\/tr>\n
41144<\/font><\/td>\n16<\/font><\/td>\n0<\/font><\/td>\nThe local availability replica of availability group '%.*ls' is in a failed state.  <\/span>The replica failed to read or update the persisted configuration data (SQL Server error: %d).  <\/span>To recover from this failure, either restart the local Windows Server Failover Clustering (WSFC) service or restart the local instance of SQL Server.<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\nBased on this output, and the output of the following query:\n<\/p>\n

\n

\n\tSELECT name, description
\n\tFROM sys.dm_xe_objects
\n\tWHERE NAME IN (
\n\t'alwayson_ddl_executed',
\n\t'availability_group_lease_expired',
\n\t'availability_replica_automatic_failover_validation',
\n\t'availability_replica_manager_state_change',
\n\t'availability_replica_state_change',
\n\t'error_reported',
\n\t'lock_redo_blocked')\n\t<\/p>\n<\/blockquote>\n

\nWe can deduce the following about the Event Session:\n<\/p>\n

\n

\n\tCREATE EVENT SESSION [AlwaysOn_health] ON SERVER
\n\t–Occurs when AlwaysOn DDL is executed including CREATE, ALTER or DROP
\n\tADD EVENT sqlserver.alwayson_ddl_executed,
\n\t–Occurs when there is a connectivity issue between the cluster and the Availability Group resulting
\n\t–in a failure to renew the lease
\n\tADD EVENT sqlserver.availability_group_lease_expired,
\n\t–Occurs when the failover validates the readiness of replica as a primary. For instance, the failover
\n\t–validation will return false when not all databases are synchronized or not joined
\n\tADD EVENT sqlserver.availability_replica_automatic_failover_validation,
\n\t–Occurs when the state of the Availability Replica Manager has changed.
\n\tADD EVENT sqlserver.availability_replica_manager_state_change,
\n\t–Occurs when the state of the Availability Replica has changed.
\n\tADD EVENT sqlserver.availability_replica_state_change,
\n\t–Occurs when an error is reported based on the previously listed table
\n\tADD EVENT sqlserver.error_reported(
\n\t    WHERE ([error_number]=(9691) OR [error_number]=(35204) OR [error_number]=(9693) OR [error_number]=(26024) OR [error_number]=(28047) OR [error_number]=(26023) OR [error_number]=(9692) OR [error_number]=(28034) OR [error_number]=(28036) OR [error_number]=(28048) OR [error_number]=(28080) OR [error_number]=(28091) OR [error_number]=(26022) OR [error_number]=(9642) OR [error_number]=(35201) OR [error_number]=(35202) OR [error_number]=(35206) OR [error_number]=(35207) OR [error_number]=(26069) OR [error_number]=(26070) OR [error_number]>(41047) AND [error_number]<(41056) OR [error_number]=(41142) OR [error_number]=(41144) OR [error_number]=(1480) OR [error_number]=(823) OR [error_number]=(824) OR [error_number]=(829) OR [error_number]=(35264) OR [error_number]=(35265))),
\n\t–Occurs when the redo thread blocks when trying to acquire a lock.
\n\tADD EVENT sqlserver.lock_redo_blocked
\n\t–Writes to the file target for persistence in the system beyond failovers and service restarts
\n\tADD TARGET package0.event_file(SET filename=N'AlwaysOn_health.xel',max_file_size=(5),max_rollover_files=(4))
\n\tWITH (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)
\n\tGO\n\t<\/p>\n<\/blockquote>\n

\nWhat is really cool is that this Event Session is used by the Availability Groups Dashboard to provide an overall status of the health of the Availability Group in Management Studio.<\/p>\n","protected":false},"excerpt":{"rendered":"

While setting up my new Availability Group using SQL Server 2012 RC0 tonight, I noticed an interesting new addition to Extended Events associated with Availability Group configuration in the Release Candidate.  When you setup an Availability Group in RC0, another default Event Session is created on the servers that participate in the Availability Group to […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,23,25,39,40],"tags":[],"class_list":["post-505","post","type-post","status-publish","format-standard","hentry","category-availability-groups","category-extended-events","category-general","category-sql-server-2012","category-sql-server-denali"],"yoast_head":"\nNew AlwaysOn_health Extended Events Session in SQL Server 2012 RC0 - 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\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New AlwaysOn_health Extended Events Session in SQL Server 2012 RC0 - Jonathan Kehayias\" \/>\n<meta property=\"og:description\" content=\"While setting up my new Availability Group using SQL Server 2012 RC0 tonight, I noticed an interesting new addition to Extended Events associated with Availability Group configuration in the Release Candidate.  When you setup an Availability Group in RC0, another default Event Session is created on the servers that participate in the Availability Group to […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\/\" \/>\n<meta property=\"og:site_name\" content=\"Jonathan Kehayias\" \/>\n<meta property=\"article:published_time\" content=\"2011-11-22T00:14:00+00:00\" \/>\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=\"11 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\\\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\\\/\"},\"author\":{\"name\":\"Jonathan Kehayias\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"headline\":\"New AlwaysOn_health Extended Events Session in SQL Server 2012 RC0\",\"datePublished\":\"2011-11-22T00:14:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\\\/\"},\"wordCount\":2201,\"commentCount\":0,\"articleSection\":[\"Availability Groups\",\"Extended Events\",\"General\",\"SQL Server 2012\",\"SQL Server Denali\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\\\/\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\\\/\",\"name\":\"New AlwaysOn_health Extended Events Session in SQL Server 2012 RC0 - Jonathan Kehayias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\"},\"datePublished\":\"2011-11-22T00:14:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Availability Groups\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/category\\\/availability-groups\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"New AlwaysOn_health Extended Events Session in SQL Server 2012 RC0\"}]},{\"@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":"New AlwaysOn_health Extended Events Session in SQL Server 2012 RC0 - 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\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\/","og_locale":"en_US","og_type":"article","og_title":"New AlwaysOn_health Extended Events Session in SQL Server 2012 RC0 - Jonathan Kehayias","og_description":"While setting up my new Availability Group using SQL Server 2012 RC0 tonight, I noticed an interesting new addition to Extended Events associated with Availability Group configuration in the Release Candidate.  When you setup an Availability Group in RC0, another default Event Session is created on the servers that participate in the Availability Group to […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\/","og_site_name":"Jonathan Kehayias","article_published_time":"2011-11-22T00:14:00+00:00","author":"Jonathan Kehayias","twitter_misc":{"Written by":"Jonathan Kehayias","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\/#article","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\/"},"author":{"name":"Jonathan Kehayias","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"headline":"New AlwaysOn_health Extended Events Session in SQL Server 2012 RC0","datePublished":"2011-11-22T00:14:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\/"},"wordCount":2201,"commentCount":0,"articleSection":["Availability Groups","Extended Events","General","SQL Server 2012","SQL Server Denali"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\/","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\/","name":"New AlwaysOn_health Extended Events Session in SQL Server 2012 RC0 - Jonathan Kehayias","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website"},"datePublished":"2011-11-22T00:14:00+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/"},{"@type":"ListItem","position":2,"name":"Availability Groups","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/category\/availability-groups\/"},{"@type":"ListItem","position":3,"name":"New AlwaysOn_health Extended Events Session in SQL Server 2012 RC0"}]},{"@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\/505","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=505"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/505\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/media?parent=505"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/categories?post=505"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/tags?post=505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}