{"id":1062,"date":"2013-09-06T12:02:07","date_gmt":"2013-09-06T19:02:07","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/joe\/?p=1062"},"modified":"2013-09-06T12:33:25","modified_gmt":"2013-09-06T19:33:25","slug":"a-brief-tour-of-sql-sentrys-alwayson-monitoring","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/joe\/a-brief-tour-of-sql-sentrys-alwayson-monitoring\/","title":{"rendered":"A Brief Tour of SQL Sentry&rsquo;s &ldquo;AlwaysOn Monitoring&rdquo;"},"content":{"rendered":"<p>Now before I begin this post, a quick disclaimer\u2026<\/p>\n<p>SQLskills partners with <a href=\"http:\/\/www.sqlsentry.com\/\" target=\"_blank\" class=\"broken_link\">SQL Sentry<\/a> on a couple of things. We periodically write guest-posts on <a href=\"http:\/\/www.sqlperformance.com\/\" target=\"_blank\">SQLPerformance.com<\/a> and SQL Sentry also provides exclusive sponsorship of two of our Immersion Events. I am also a big fan of <a href=\"http:\/\/www.sqlsentry.net\/plan-explorer\/sql-server-query-view.asp\" target=\"_blank\">SQL Sentry Plan Explorer<\/a>, but that would have been the case regardless of the existing business relationships.<\/p>\n<p>With that said, I wanted to write a post about SQL Sentry\u2019s new \u201cAlwaysOn Monitoring\u201d functionality integrated into <a href=\"http:\/\/www.sqlsentry.net\/performance-advisor\/sql-server-performance.asp\" target=\"_blank\">SQL Sentry Performance Advisor<\/a> for SQL Server v7.5, highlighting a few areas that I think are useful after an initial, informal investigation.<\/p>\n<p>I explored this new functionality in a VMware environment with ten availability groups configured on a four node Windows Server Failover Cluster (WSFC) with four standalone SQL Server instances.<\/p>\n<p>Here were the top areas that stood out for me&#8230;<\/p>\n<h3>Get your bearings quickly<\/h3>\n<p>Let\u2019s say you\u2019re the new DBA on the team. Your SQL Server production environment is being monitored by SQL Sentry Performance Advisor and you want to get a quick look at the current availability group topologies\u2026<\/p>\n<p>Steps I performed to do this:<\/p>\n<ul>\n<li>Launched the SQL Sentry Client<\/li>\n<li>Right-clicked the Default Site and selected \u201cOpen AlwaysOn Management\u201d<\/li>\n<\/ul>\n<p>This is what I saw by-default:<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-8-55-33-AM.jpg\"><img fetchpriority=\"high\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"9-6-2013 8-55-33 AM\" alt=\"9-6-2013 8-55-33 AM\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-8-55-33-AM_thumb.jpg\" width=\"926\" height=\"522\" border=\"0\" \/><\/a><\/p>\n<p>The zoom-level for the availability group topology visualizations was set to 150% and the layout style was set to \u201cWSFC Node\/Group Matrix\u201d. Scrolling down I was able to see all ten availability groups defined on SQL Server instances hosted on the WSFC.<\/p>\n<p>There are various layout styles to choose from, including:<\/p>\n<ul>\n<li>\u201cWSFC Node \/ Group Matrix\u201d (what you saw in the earlier visual)<\/li>\n<li>\u201cWSFCs\u201d (showing the monitored WSFCs in your environment)<\/li>\n<li>\u201cWSFC Members\u201d (nodes associated with a specific WSFC)<\/li>\n<\/ul>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-19-12-AM.jpg\"><img decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"9-6-2013 10-19-12 AM\" alt=\"9-6-2013 10-19-12 AM\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-19-12-AM_thumb.jpg\" width=\"520\" height=\"511\" border=\"0\" \/><\/a><\/p>\n<ul>\n<li>\u201cInstance\/Group Matrix\u201d<\/li>\n<\/ul>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-20-35-AM.jpg\"><img decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"9-6-2013 10-20-35 AM\" alt=\"9-6-2013 10-20-35 AM\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-20-35-AM_thumb.jpg\" width=\"609\" height=\"450\" border=\"0\" \/><\/a><\/p>\n<ul>\n<li>\u201cInstances\u201d<\/li>\n<\/ul>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-22-20-AM.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"9-6-2013 10-22-20 AM\" alt=\"9-6-2013 10-22-20 AM\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-22-20-AM_thumb.jpg\" width=\"600\" height=\"461\" border=\"0\" \/><\/a><\/p>\n<ul>\n<li>\u00a0\u201cGroups\/Replicas\u201d<\/li>\n<\/ul>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-1-39-14-PM.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"9-6-2013 1-39-14 PM\" alt=\"9-6-2013 1-39-14 PM\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-1-39-14-PM_thumb.jpg\" width=\"714\" height=\"394\" border=\"0\" \/><\/a><\/p>\n<h3>Availability Group Configuration Visualizations<\/h3>\n<p>You can answer quite a few questions by just looking at the availability group animations. You\u2019re seeing static screen shots on this blog post\u00a0\u2013 but keep in mind that this view changes state dynamically. The image below shows me that \u201cAG-Test2\u201d has two replicas on two nodes out of the four node WSFC:<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/image.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"image\" alt=\"image\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/image_thumb.png\" width=\"725\" height=\"151\" border=\"0\" \/><\/a><\/p>\n<p>I can clearly see which replica is primary and which is secondary, and the spoke symbol (zoomed in below) lets me know which replicas are configured for automatic failover:<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-26-37-AM.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"9-6-2013 10-26-37 AM\" alt=\"9-6-2013 10-26-37 AM\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-26-37-AM_thumb.jpg\" width=\"302\" height=\"129\" border=\"0\" \/><\/a><\/p>\n<p>If a replica is set for read-only connection mode, we\u2019ll see the following symbol:<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-11-06-14-AM.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"9-6-2013 11-06-14 AM\" alt=\"9-6-2013 11-06-14 AM\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-11-06-14-AM_thumb2.jpg\" width=\"212\" height=\"132\" border=\"0\" \/><\/a><\/p>\n<p>Hovering over the read-only symbol will clarify if it is read-intent only (SQL Sentry uses the word \u201cSpecified\u201d for read-intent and just \u201cAll\u201d when read-intent is not used).<\/p>\n<p>If replicas are asynchronous, we\u2019ll see a double-pipe symbol by the associated replica (I put red boxes around them so you could see exactly what I\u2019m talking about):<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/SNAGHTMLa08656b2.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"SNAGHTMLa08656b\" alt=\"SNAGHTMLa08656b\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/SNAGHTMLa08656b_thumb1.png\" width=\"869\" height=\"148\" border=\"0\" \/><\/a><\/p>\n<p>The connecting pipelines also have inherent meaning. Let\u2019s say you\u2019ve heard about performance issues in the availability group topology and you want to narrow down quickly to the offending availability group, the bars within the pipeline will automatically be sized based on relative load of the other availability groups and you\u2019ll see the colors shift from green, to yellow to red for availability groups pushing more load:<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-36-54-AM1.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"9-6-2013 10-36-54 AM\" alt=\"9-6-2013 10-36-54 AM\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-36-54-AM_thumb1.jpg\" width=\"689\" height=\"364\" border=\"0\" \/><\/a><\/p>\n<p>Hovering over the pipelines will also provide information regarding KB to Replica\/Sec and the Recovery queue KB.<\/p>\n<h3>Tabular Data<\/h3>\n<p>If animated topology layouts aren\u2019t your thing, you have a series of tabs below the layout pane that are responsive to the objects you click in the layout area. Tabs cover WSFCs, WSFC Members, Instances, FCIs, Availability Groups, Replicas, Databases, Database Replica States and Availability Group Listener information. Below shows an example of database replica states information:<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-45-25-AM1.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"9-6-2013 10-45-25 AM\" alt=\"9-6-2013 10-45-25 AM\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-45-25-AM_thumb1.jpg\" width=\"732\" height=\"295\" border=\"0\" \/><\/a><\/p>\n<p>There is a significant amount of information exposed in the grid section and based on initial impressions, I think it would be likely that I would most often view the Availability Groups tab and Database Replica States tabs.<\/p>\n<p>Most of the grids are expandable. For example- expanding an availability group to see the availability databases and then clicking Replicas to see where they are hosted:<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-51-06-AM1.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"9-6-2013 10-51-06 AM\" alt=\"9-6-2013 10-51-06 AM\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-51-06-AM_thumb.jpg\" width=\"782\" height=\"276\" border=\"0\" \/><\/a><\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-51-54-AM.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"9-6-2013 10-51-54 AM\" alt=\"9-6-2013 10-51-54 AM\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-51-54-AM_thumb.jpg\" width=\"1049\" height=\"283\" border=\"0\" \/><\/a><\/p>\n<h3>Charts<\/h3>\n<p>In the upper-right hand pane you\u2019ll see dynamic chart graphics depending on where you\u2019ve clicked. For example, selecting a specific WSFC Member on the WSFC Members tab shows the following KB From Replica\/Sec data:<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-54-31-AM.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"9-6-2013 10-54-31 AM\" alt=\"9-6-2013 10-54-31 AM\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-10-54-31-AM_thumb.jpg\" width=\"608\" height=\"454\" border=\"0\" \/><\/a><\/p>\n<h3>Error Logs and Replica State Changes<\/h3>\n<p>In the same area as the Chart tab is an Error Log and Replica State Changes tab. This information isn\u2019t on by default, and you if you want this information you need to enable it explicitly (the interface makes this clear). The reason behind this is related to the monitoring noise that then gets added to the SQL Server Error Log, with an ongoing entry of \u201cUsing \u2018dbghelp.dll\u2019 version \u20184.0.5\u2019\u201d. For more information on this issue, see the Connect item \u201c<a href=\"http:\/\/connect.microsoft.com\/SQLServer\/feedback\/details\/789617\/xevents-selecting-system-health-information-records-using-dbghelp-dll-version-4-0-5-in-errorlog\">xEvents: selecting System Health information records Using &#8216;dbghelp.dll&#8217; version &#8216;4.0.5&#8217; in Errorlog<\/a>\u201d.<\/p>\n<p>But if you\u2019re okay with the additional noise in the SQL Server Error Log, these two information panes can be useful in order to see real-time availability group activity. For example \u2013 here is what we see after a controlled failover of an availability group for the Error Log:<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-11-02-40-AM.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"9-6-2013 11-02-40 AM\" alt=\"9-6-2013 11-02-40 AM\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-11-02-40-AM_thumb.jpg\" width=\"803\" height=\"270\" border=\"0\" \/><\/a><\/p>\n<p>And here is what we see for Replica State Changes:<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-11-03-32-AM.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"9-6-2013 11-03-32 AM\" alt=\"9-6-2013 11-03-32 AM\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-11-03-32-AM_thumb.jpg\" width=\"622\" height=\"174\" border=\"0\" \/><\/a><\/p>\n<p>And as an aside, the visualization of the availability group does dynamically change during a failover event \u2013 and you\u2019ll see a change in pipeline activity and also in the status color (the example below shows a red\/pink represent of an \u201cunhealthy\u201d availability group state).<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-11-01-50-AM.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"9-6-2013 11-01-50 AM\" alt=\"9-6-2013 11-01-50 AM\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-11-01-50-AM_thumb.jpg\" width=\"664\" height=\"103\" border=\"0\" \/><\/a><\/p>\n<h3>Wish List<\/h3>\n<p>I do have a few items on the wish list:<\/p>\n<ul>\n<li>A new name. \u201cAlwaysOn\u201d is a Microsoft marketing term that encompasses more than Availability Groups, so I think the name should be \u201cAvailability Group Monitoring.\u201d<\/li>\n<li>Dynamic auto-zoom based on the number of objects in a topology.<\/li>\n<li>I think some of the graphical elements could use some clarity \u2013 for example, adding a legend that translates the symbols for new users of this functionality.<\/li>\n<li>Have an easy\u00a0way to export out the tabular data from the various panes.<\/li>\n<\/ul>\n<p>My first impressions are very favorable and I do think this is a useful tool \u2013 particularly for environments that have numerous availability groups and higher complexity topologies.<\/p>\n<p>PS:\u00a0This product also provides\u00a0built-in alerting for health changes and failovers that isn&#8217;t provided natively by Microsoft, but I didn&#8217;t get a chance to investigate this yet.\u00a0 I do plan on testing this out in the future and will share any interesting findings accordingly.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Now before I begin this post, a quick disclaimer\u2026 SQLskills partners with SQL Sentry on a couple of things. We periodically write guest-posts on SQLPerformance.com and SQL Sentry also provides exclusive sponsorship of two of our Immersion Events. I am also a big fan of SQL Sentry Plan Explorer, but that would have been the [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[],"class_list":["post-1062","post","type-post","status-publish","format-standard","hentry","category-performance"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>A Brief Tour of SQL Sentry&rsquo;s &ldquo;AlwaysOn Monitoring&rdquo; - Joe Sack<\/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\/joe\/a-brief-tour-of-sql-sentrys-alwayson-monitoring\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A Brief Tour of SQL Sentry&rsquo;s &ldquo;AlwaysOn Monitoring&rdquo; - Joe Sack\" \/>\n<meta property=\"og:description\" content=\"Now before I begin this post, a quick disclaimer\u2026 SQLskills partners with SQL Sentry on a couple of things. We periodically write guest-posts on SQLPerformance.com and SQL Sentry also provides exclusive sponsorship of two of our Immersion Events. I am also a big fan of SQL Sentry Plan Explorer, but that would have been the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/joe\/a-brief-tour-of-sql-sentrys-alwayson-monitoring\/\" \/>\n<meta property=\"og:site_name\" content=\"Joe Sack\" \/>\n<meta property=\"article:published_time\" content=\"2013-09-06T19:02:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-09-06T19:33:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-8-55-33-AM_thumb.jpg\" \/>\n<meta name=\"author\" content=\"Joseph Sack\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Joseph Sack\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/a-brief-tour-of-sql-sentrys-alwayson-monitoring\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/a-brief-tour-of-sql-sentrys-alwayson-monitoring\/\",\"name\":\"A Brief Tour of SQL Sentry&rsquo;s &ldquo;AlwaysOn Monitoring&rdquo; - Joe Sack\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#website\"},\"datePublished\":\"2013-09-06T19:02:07+00:00\",\"dateModified\":\"2013-09-06T19:33:25+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/a-brief-tour-of-sql-sentrys-alwayson-monitoring\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/joe\/a-brief-tour-of-sql-sentrys-alwayson-monitoring\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/a-brief-tour-of-sql-sentrys-alwayson-monitoring\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Performance\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/category\/performance\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"A Brief Tour of SQL Sentry&rsquo;s &ldquo;AlwaysOn Monitoring&rdquo;\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/\",\"name\":\"Joe Sack\",\"description\":\"SQL Server Performance Tuning, High Availability and Disaster Recovery Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648\",\"name\":\"Joseph Sack\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g\",\"caption\":\"Joseph Sack\"},\"description\":\"Joe Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail and the real estate industry. Prior to joining SQLskills he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development and high-availability. In 2006 Joe earned the \u201cMicrosoft Certified Master: SQL Server 2005\u201d certification and in 2008 he earned the \u201cMicrosoft Certified Master: SQL Server 2008\u201d certification. In 2009 he took over responsibility for the entire SQL Server Microsoft Certified Master program and held that post until 2011. He was given the SQL Server MVP award in 2013.\",\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/joe\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/josephsack\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/author\/joe\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"A Brief Tour of SQL Sentry&rsquo;s &ldquo;AlwaysOn Monitoring&rdquo; - Joe Sack","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\/joe\/a-brief-tour-of-sql-sentrys-alwayson-monitoring\/","og_locale":"en_US","og_type":"article","og_title":"A Brief Tour of SQL Sentry&rsquo;s &ldquo;AlwaysOn Monitoring&rdquo; - Joe Sack","og_description":"Now before I begin this post, a quick disclaimer\u2026 SQLskills partners with SQL Sentry on a couple of things. We periodically write guest-posts on SQLPerformance.com and SQL Sentry also provides exclusive sponsorship of two of our Immersion Events. I am also a big fan of SQL Sentry Plan Explorer, but that would have been the [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/joe\/a-brief-tour-of-sql-sentrys-alwayson-monitoring\/","og_site_name":"Joe Sack","article_published_time":"2013-09-06T19:02:07+00:00","article_modified_time":"2013-09-06T19:33:25+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/2013\/09\/9-6-2013-8-55-33-AM_thumb.jpg"}],"author":"Joseph Sack","twitter_misc":{"Written by":"Joseph Sack","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/a-brief-tour-of-sql-sentrys-alwayson-monitoring\/","url":"https:\/\/www.sqlskills.com\/blogs\/joe\/a-brief-tour-of-sql-sentrys-alwayson-monitoring\/","name":"A Brief Tour of SQL Sentry&rsquo;s &ldquo;AlwaysOn Monitoring&rdquo; - Joe Sack","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#website"},"datePublished":"2013-09-06T19:02:07+00:00","dateModified":"2013-09-06T19:33:25+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/a-brief-tour-of-sql-sentrys-alwayson-monitoring\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/joe\/a-brief-tour-of-sql-sentrys-alwayson-monitoring\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/a-brief-tour-of-sql-sentrys-alwayson-monitoring\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/joe\/"},{"@type":"ListItem","position":2,"name":"Performance","item":"https:\/\/www.sqlskills.com\/blogs\/joe\/category\/performance\/"},{"@type":"ListItem","position":3,"name":"A Brief Tour of SQL Sentry&rsquo;s &ldquo;AlwaysOn Monitoring&rdquo;"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/joe\/","name":"Joe Sack","description":"SQL Server Performance Tuning, High Availability and Disaster Recovery Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/joe\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648","name":"Joseph Sack","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g","caption":"Joseph Sack"},"description":"Joe Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail and the real estate industry. Prior to joining SQLskills he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development and high-availability. In 2006 Joe earned the \u201cMicrosoft Certified Master: SQL Server 2005\u201d certification and in 2008 he earned the \u201cMicrosoft Certified Master: SQL Server 2008\u201d certification. In 2009 he took over responsibility for the entire SQL Server Microsoft Certified Master program and held that post until 2011. He was given the SQL Server MVP award in 2013.","sameAs":["http:\/\/3.209.169.194\/blogs\/joe","https:\/\/twitter.com\/https:\/\/twitter.com\/josephsack"],"url":"https:\/\/www.sqlskills.com\/blogs\/joe\/author\/joe\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts\/1062","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/comments?post=1062"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts\/1062\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/media?parent=1062"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/categories?post=1062"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/tags?post=1062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}