{"id":2856,"date":"2014-09-16T11:51:39","date_gmt":"2014-09-16T10:51:39","guid":{"rendered":"http:\/\/andreas-wolter.com\/verwaltungs-data-warehouse-datensammler-alwayson-hochverfuegbarkeitsgruppen\/"},"modified":"2017-10-18T17:30:48","modified_gmt":"2017-10-18T16:30:48","slug":"performance-management-data-warehouse-data-collector-alwayson-availability-groups","status":"publish","type":"post","link":"https:\/\/andreas-wolter.com\/en\/performance-management-data-warehouse-data-collector-alwayson-availability-groups\/","title":{"rendered":"Performance\/ Management Data Warehouse Data Collector &#038; AlwaysOn Availability Groups"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_heading-6f3ca3f17713f761f6597ec6428d749b\">\n#top .av-special-heading.av-av_heading-6f3ca3f17713f761f6597ec6428d749b{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-av_heading-6f3ca3f17713f761f6597ec6428d749b .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-av_heading-6f3ca3f17713f761f6597ec6428d749b .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-av_heading-6f3ca3f17713f761f6597ec6428d749b av-special-heading-h3 blockquote modern-quote  avia-builder-el-0  el_before_av_textblock  avia-builder-el-first '><h3 class='av-special-heading-tag'  itemprop=\"headline\"  >Performance\/ Management Data Warehouse Data Collector <span class='special_amp'>&amp;<\/span> AlwaysOn Availability Groups<\/h3><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>This time, we are dealing with the \u201eMDW\u201c, short for <strong><em>Management Data Warehouse<\/em><\/strong>,( <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/bb677306.aspx\" target=\"_blank\" rel=\"noopener\">http:\/\/msdn.microsoft.com\/en-us\/library\/bb677306.aspx<\/a>), which I like to recommend as a minimal performance logging-approach.<\/p>\n<p>From time to time, and most recently in the context of my PASS Essential \u201eSQL Server Analysis tools &#038; Techniques for Performance und general Monitoring\u201c, the question arises as to whether the MDW operates together with the High Availability technologies <em>Database Mirroring<\/em> and <em>AlwaysOn Availability Groups<\/em>, and if so, how so.<!--more-->The short answer is: Yes, it does. The MDW operates both with <em>Database Mirroring<\/em> as well as with <em>AlwaysOn Availability Groups.<\/em><\/p>\n<p>The following graph illustrates a possible setup using the latter:<\/p>\n<\/div><\/section>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-4e6265eccf1c903304530ca0671ef1de\">\n.avia-image-container.av-av_image-4e6265eccf1c903304530ca0671ef1de img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-4e6265eccf1c903304530ca0671ef1de .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-4e6265eccf1c903304530ca0671ef1de av-styling- avia-align-center  avia-builder-el-2  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-2847 avia-img-lazy-loading-not-2847 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Data_Collector_AlwaysOn.png\" alt='' title='1409_MDW_Data_Collector_AlwaysOn'  height=\"530\" width=\"526\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Data_Collector_AlwaysOn.png 526w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Data_Collector_AlwaysOn-100x100.png 100w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Data_Collector_AlwaysOn-80x80.png 80w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Data_Collector_AlwaysOn-298x300.png 298w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Data_Collector_AlwaysOn-36x36.png 36w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Data_Collector_AlwaysOn-180x180.png 180w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Data_Collector_AlwaysOn-120x120.png 120w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Data_Collector_AlwaysOn-450x453.png 450w\" sizes=\"(max-width: 526px) 100vw, 526px\" \/><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>The server (0) holding the MDW database is located outside of the high availability nodes. The databases to be monitored are located in the <em>AlwaysOn Availability Groups<\/em> in the servers 1-3. Keeping the MDW highly available is not the objective. It is simply about being able to see the performance data of all databases, no matter in which server they are active at the moment.<\/p>\n<p><strong>Part 1: Databases in secondary role<\/strong><\/p>\n<p>If you set up the MDW as standard you will realize that after a failover, the data of the respective databases disappear from the \u201cDisc Usage\u201d reports of the server, while these were previously still present in the primary role.<\/p>\n<p>The background to this is that after a failover, the respective databases now are present in a different server in the primary role, and now are no longer readable in the secondary, in the standard setting.<\/p>\n<p>In this moment, the System Data Collection Set \u201cDisc Usage\u201d, or the underlying job \u201ccollection_set_1_noncached_collect_and_upload\u201d cannot collect data for this database. In contrast on the new primary node these database will now reappear as long as they are active in the primary role there. In principle, this behavior is comprehensible: The Data Collector can no longer find any information on this database and assumes that the latter is no longer relevant \u2013 as if it was deleted. One may certainly wish for a possibility of intervention here; however, the MDW is currently not flexible in this regard.<\/p>\n<p>The new report \u201cTransaction Performance Analysis Overview\u201d which is enriched through the newly existent \u201cTransaction Performance Collection Set\u201d in SQL Server 2014 also displays data for no longer active databases.<\/p>\n<p>Having clarified this background, the possible solution is self-evident: The databases must remain readable.<\/p>\n<p>With<em> AlwaysOn High Availability Groups<\/em>, this is in principal easily done:<\/p>\n<\/div><\/section>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-0f9474c1a3ec5f50abb50e0dddec4401\">\n.avia-image-container.av-av_image-0f9474c1a3ec5f50abb50e0dddec4401 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-0f9474c1a3ec5f50abb50e0dddec4401 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-0f9474c1a3ec5f50abb50e0dddec4401 av-styling- avia-align-center  avia-builder-el-4  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-2837 avia-img-lazy-loading-not-2837 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_AlwaysOn_AvailabiltyGroup_Config_ReadableSecondary.png\" alt='' title='1409_AlwaysOn_AvailabiltyGroup_Config_ReadableSecondary'  height=\"139\" width=\"556\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_AlwaysOn_AvailabiltyGroup_Config_ReadableSecondary.png 556w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_AlwaysOn_AvailabiltyGroup_Config_ReadableSecondary-300x75.png 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_AlwaysOn_AvailabiltyGroup_Config_ReadableSecondary-450x113.png 450w\" sizes=\"(max-width: 556px) 100vw, 556px\" \/><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>However, one needs to be aware of the fact that these databases are now released for all reading access \u2013 which should be taken into consideration in respect to application architecture, performance as well as in terms of license. Hence, for the purpose of data collection for performance evaluation alone I CANNOT recommend it.<\/p>\n<p>If however the business applications are supposed to maintain reading access to the secondary point anyway, the data collector is covered with this as well.<\/p>\n<p>One more advice: The setting \u201cRead-Intent only\u201d unfortunately does not work with the MDW since one cannot manually adapt the Connection String accordingly. Database Mirroring does not support this option at all.<\/p>\n<p><strong>Part 2: Configuration of the MDW-Clients<\/strong><\/p>\n<p>Since the databases run on a different node after a failover, the MDW reports must be set up in all servers in which the Availability Group is running. Here, one needs to ensure that access to the central MDW-Server is possible from all servers.<\/p>\n<p>To do this (before SQL Server 2014) the SQL Server Agent Account of the client-instance must be included in the <em>mdw_writer<\/em> role <u>on the MDW-Server<\/u> (<em>mdw_admin<\/em> is not necessary) <u>when configuring the MDW through the \u201cConfigure Management Data Warehouse Wizard<\/u>:<\/p>\n<\/div><\/section>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-0a4f9c440e21505a481a9448f758afd9\">\n.avia-image-container.av-av_image-0a4f9c440e21505a481a9448f758afd9 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-0a4f9c440e21505a481a9448f758afd9 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-0a4f9c440e21505a481a9448f758afd9 av-styling- avia-align-center  avia-builder-el-6  el_after_av_textblock  el_before_av_image '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-2843 avia-img-lazy-loading-not-2843 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Server.png\" alt='' title='1409_MDW_Config_Server'  height=\"286\" width=\"715\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Server.png 715w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Server-600x240.png 600w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Server-300x120.png 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Server-705x282.png 705w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Server-450x180.png 450w\" sizes=\"(max-width: 715px) 100vw, 715px\" \/><\/div><\/div><\/div>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-b71a7aba6b0ae67a50008ad0f25f16ab\">\n.avia-image-container.av-av_image-b71a7aba6b0ae67a50008ad0f25f16ab img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-b71a7aba6b0ae67a50008ad0f25f16ab .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-b71a7aba6b0ae67a50008ad0f25f16ab av-styling- avia-align-center  avia-builder-el-7  el_after_av_image  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-2839 avia-img-lazy-loading-not-2839 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Logins_Users_Roles.png\" alt='' title='1409_MDW_Config_Logins_Users_Roles'  height=\"513\" width=\"709\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Logins_Users_Roles.png 709w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Logins_Users_Roles-600x434.png 600w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Logins_Users_Roles-300x217.png 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Logins_Users_Roles-705x510.png 705w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Logins_Users_Roles-450x326.png 450w\" sizes=\"(max-width: 709px) 100vw, 709px\" \/><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><strong>From SQL Server 2014<\/strong>, <u>at the configuration of the data collection in the client<\/u>, it is possible to provide a SQL Server Agent Proxy of the type \u201cOperating System (CmdExec)\u201d as account for the access to the central MDW-Server:<\/p>\n<\/div><\/section>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-0978b005e34f6d303c50edce6f33c74c\">\n.avia-image-container.av-av_image-0978b005e34f6d303c50edce6f33c74c img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-0978b005e34f6d303c50edce6f33c74c .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-0978b005e34f6d303c50edce6f33c74c av-styling- avia-align-center  avia-builder-el-9  el_after_av_textblock  el_before_av_image '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-2845 avia-img-lazy-loading-not-2845 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Server_Proxy.png\" alt='' title='1409_MDW_Config_Server_Proxy'  height=\"515\" width=\"715\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Server_Proxy.png 715w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Server_Proxy-600x432.png 600w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Server_Proxy-300x216.png 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Server_Proxy-705x508.png 705w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Server_Proxy-450x324.png 450w\" sizes=\"(max-width: 715px) 100vw, 715px\" \/><\/div><\/div><\/div>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-707dbcc344aea59ce24ec547d7a5f1f8\">\n.avia-image-container.av-av_image-707dbcc344aea59ce24ec547d7a5f1f8 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-707dbcc344aea59ce24ec547d7a5f1f8 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-707dbcc344aea59ce24ec547d7a5f1f8 av-styling- avia-align-center  avia-builder-el-10  el_after_av_image  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-2841 avia-img-lazy-loading-not-2841 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Proxy.png\" alt='' title='1409_MDW_Config_Proxy'  height=\"290\" width=\"715\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Proxy.png 715w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Proxy-600x243.png 600w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Proxy-300x122.png 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Proxy-705x286.png 705w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Config_Proxy-450x183.png 450w\" sizes=\"(max-width: 715px) 100vw, 715px\" \/><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>In this case, it is of course required to authorize the underlying Windows account in the server, instead of the agent itself, as \u201emdw-writer\u201c.<\/p>\n<p>As soon as all clients are authorized accordingly, one can read the data of all SQL Server AG nodes in the central management server. Depending on which server a database is currently present in in the primary role, it will then appear in the according subreport.<\/p>\n<p>&#8211; This proceeding also works with mirrored databases in Database Mirroring scenarios \u2013 there one can only have one \u201cpartner instance\u201d though.<\/p>\n<\/div><\/section>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-dee6a3381b3e7aede6061abda93a76a0\">\n.avia-image-container.av-av_image-dee6a3381b3e7aede6061abda93a76a0 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-dee6a3381b3e7aede6061abda93a76a0 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-dee6a3381b3e7aede6061abda93a76a0 av-styling- avia-align-center  avia-builder-el-12  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-2849 avia-img-lazy-loading-not-2849 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Report_Server_Selection.png\" alt='' title='1409_MDW_Report_Server_Selection'  height=\"308\" width=\"802\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Report_Server_Selection.png 802w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Report_Server_Selection-600x230.png 600w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Report_Server_Selection-300x115.png 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Report_Server_Selection-768x295.png 768w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Report_Server_Selection-705x271.png 705w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/09\/1409_MDW_Report_Server_Selection-450x173.png 450w\" sizes=\"(max-width: 802px) 100vw, 802px\" \/><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><br class=\"\u201cclear\u201c\" \/>Happy collecting<\/p>\n<p>Andreas<\/p>\n<\/div><\/section>\r\n\r\n<div  class='hr av-av_hr-0ff602b3e980a3377077ff3c1c834df6 hr-default  avia-builder-el-14  el_after_av_textblock  el_before_av_one_full '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_one_full-97c650ae075063b375f558a776c570f8\">\n#top .flex_column.av-av_one_full-97c650ae075063b375f558a776c570f8{\nmargin-top:40px;\nmargin-bottom:40px;\n}\n.flex_column.av-av_one_full-97c650ae075063b375f558a776c570f8{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n.responsive #top #wrap_all .flex_column.av-av_one_full-97c650ae075063b375f558a776c570f8{\nmargin-top:40px;\nmargin-bottom:40px;\n}\n<\/style>\n<div  class='flex_column av-av_one_full-97c650ae075063b375f558a776c570f8 av_one_full  avia-builder-el-15  el_after_av_hr  el_before_av_social_share  first flex_column_div av-zero-column-padding  '     ><section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><div><\/div>\n<div><\/div>\n<\/div><\/section><\/div>\r\n\r\n<div  class='av-social-sharing-box av-av_social_share-8644d330ffb238fff0cfa858c5295467 av-social-sharing-box-default  avia-builder-el-17  el_after_av_one_full  el_before_av_hr  av-social-sharing-box-fullwidth'><div class=\"av-share-box\"><h5 class='av-share-link-description av-no-toc '>Share<\/h5><ul class=\"av-share-box-list noLightbox\"><li class='av-share-link av-social-link-facebook' ><a target=\"_blank\" aria-label=\"Share on Facebook\" href=\"https:\/\/www.facebook.com\/sharer.php?u=https:\/\/andreas-wolter.com\/en\/performance-management-data-warehouse-data-collector-alwayson-availability-groups\/&#038;t=Performance%2F%20Management%20Data%20Warehouse%20Data%20Collector%20%26%20AlwaysOn%20Availability%20Groups\" aria-hidden=\"false\" data-av_icon=\"\ue8f3\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on Facebook\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on Facebook<\/span><\/a><\/li><li class='av-share-link av-social-link-twitter' ><a target=\"_blank\" aria-label=\"Share on Twitter\" href=\"https:\/\/twitter.com\/share?text=Performance%2F%20Management%20Data%20Warehouse%20Data%20Collector%20%26%20AlwaysOn%20Availability%20Groups&#038;url=https:\/\/andreas-wolter.com\/en\/?p=2856\" aria-hidden=\"false\" data-av_icon=\"\ue8f1\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on Twitter\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on Twitter<\/span><\/a><\/li><li class='av-share-link av-social-link-linkedin' ><a target=\"_blank\" aria-label=\"Share on LinkedIn\" href=\"https:\/\/linkedin.com\/shareArticle?mini=true&#038;title=Performance%2F%20Management%20Data%20Warehouse%20Data%20Collector%20%26%20AlwaysOn%20Availability%20Groups&#038;url=https:\/\/andreas-wolter.com\/en\/performance-management-data-warehouse-data-collector-alwayson-availability-groups\/\" aria-hidden=\"false\" data-av_icon=\"\ue8fc\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on LinkedIn\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on LinkedIn<\/span><\/a><\/li><\/ul><\/div><\/div>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-4474f20d2389e2e5ecf918a02da5132e\">\n#top .hr.hr-invisible.av-av_hr-4474f20d2389e2e5ecf918a02da5132e{\nheight:50px;\n}\n<\/style>\n<div  class='hr av-av_hr-4474f20d2389e2e5ecf918a02da5132e hr-invisible  avia-builder-el-18  el_after_av_social_share  el_before_av_comments_list '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\r\n\r\n<div  class='av-buildercomment av-av_comments_list-88ce68e426f11248fa394058a3de040f  av-blog-meta-author-disabled av-blog-meta-html-info-disabled'><\/div>","protected":false},"excerpt":{"rendered":"This time, we are dealing with the \u201eMDW\u201c, short for Management Data Warehouse,( http:\/\/msdn.microsoft.com\/en-us\/library\/bb677306.aspx), which I like to recommend as a minimal performance logging-approach. From time to time, and most recently in the context of my PASS Essential \u201eSQL Server Analysis tools &#038; Techniques for Performance und general Monitoring\u201c, the question arises as to whether [&hellip;]","protected":false},"author":4,"featured_media":2928,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[130,56],"tags":[170,168,169,171,12,26,9,27],"class_list":["post-2856","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mdw","category-tracing-monitoring-en","tag-alwayson-en","tag-alwayson","tag-mdw","tag-mdw-en","tag-performance","tag-performance-en","tag-security","tag-security-en"],"_links":{"self":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/2856","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/comments?post=2856"}],"version-history":[{"count":6,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/2856\/revisions"}],"predecessor-version":[{"id":2857,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/2856\/revisions\/2857"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media\/2928"}],"wp:attachment":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media?parent=2856"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/categories?post=2856"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/tags?post=2856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}