{"id":4115,"date":"2018-03-02T14:02:44","date_gmt":"2018-03-02T20:02:44","guid":{"rendered":"https:\/\/kevinjustin.com\/blog\/?p=4115"},"modified":"2023-02-25T11:05:31","modified_gmt":"2023-02-25T15:05:31","slug":"sql-mp-bloat","status":"publish","type":"post","link":"https:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/","title":{"rendered":"SQL MP bloat"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4125\" src=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/wad-of-cash.png\" alt=\"\" width=\"324\" height=\"212\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>Updated 25 Feb 2023<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>Ever wish alerts were like a wad of cash?<\/p>\n<p>The more you solve, the more you make!<\/p>\n<p>&nbsp;<\/p>\n<p>How about performance counter data?<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>The SQL management packs are awesome for visualizations, and provide a bunch of data.<\/p>\n<p>&nbsp;<\/p>\n<p>Tim McFadden\u00a0pointed out\u00a0SQL Performance counters <a href=\"https:\/\/www.scom2k7.com\/crazy-db-performance-collection-rules-in-the-sql-mps\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.scom2k7.com\/crazy-db-performance-collection-rules-in-the-sql-mps\/<\/a><\/p>\n<p>His blog brings up SQL MP Disk Latency\u00a0performance counters.<\/p>\n<p>&nbsp;<\/p>\n<p>His\u00a0blog got me thinking about SQL DB and DB\u00a0file design, where multiple DB files are on the same Drive, causes duplicate performance counters (SCOM workflows) on the agent, and will typically be one of the culprits for HealthService restarts.<\/p>\n<p>&nbsp;<\/p>\n<p>SQL MP creates\u00a0performance counters (per DB file, group, instance, engine)<\/p>\n<p>&nbsp;<\/p>\n<h2><\/h2>\n<h2><strong>Let&#8217;s start with how I figured out why all my money goes into storage.<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<p>Start in the SCOM console<\/p>\n<p>Click on the Reporting Tab<\/p>\n<p>Click on the &#8216;System Center Core Monitoring Reports&#8217; folder<\/p>\n<p>Double click on the Data Volume by Management Pack<\/p>\n<figure id=\"attachment_7016\" aria-describedby=\"caption-attachment-7016\" style=\"width: 1113px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/SCOM-Reporting-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7016\" src=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/SCOM-Reporting-1.png\" alt=\"\" width=\"1113\" height=\"713\" srcset=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/SCOM-Reporting-1.png 1113w, https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/SCOM-Reporting-1-300x192.png 300w, https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/SCOM-Reporting-1-1024x656.png 1024w, https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/SCOM-Reporting-1-768x492.png 768w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/a><figcaption id=\"caption-attachment-7016\" class=\"wp-caption-text\">View of SCOM report from console reporting tab<\/figcaption><\/figure>\n<p>Select the timeframe (from, to)<\/p>\n<p>Click Run<\/p>\n<figure id=\"attachment_7014\" aria-describedby=\"caption-attachment-7014\" style=\"width: 1377px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/Data-Volume-MP-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7014\" src=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/Data-Volume-MP-2.png\" alt=\"\" width=\"1377\" height=\"302\" srcset=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/Data-Volume-MP-2.png 1377w, https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/Data-Volume-MP-2-300x66.png 300w, https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/Data-Volume-MP-2-1024x225.png 1024w, https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/Data-Volume-MP-2-768x168.png 768w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/a><figcaption id=\"caption-attachment-7014\" class=\"wp-caption-text\">Data Volume MP selected<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>Reporting Data<\/p>\n<p>I have 2 2016 DB&#8217;s and 1 2014 (SCVMM) database server monitored, and it&#8217;s 50% of my data volume!<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4165\" src=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/SQL-Data-Volume-Counts.png\" alt=\"\" width=\"927\" height=\"652\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Another example &#8211; had the DW shutdown for days<\/p>\n<figure id=\"attachment_7015\" aria-describedby=\"caption-attachment-7015\" style=\"width: 961px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/Data-Volume-by-MP-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7015\" src=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/Data-Volume-by-MP-1.png\" alt=\"\" width=\"961\" height=\"634\" srcset=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/Data-Volume-by-MP-1.png 961w, https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/Data-Volume-by-MP-1-300x198.png 300w, https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/Data-Volume-by-MP-1-768x507.png 768w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/a><figcaption id=\"caption-attachment-7015\" class=\"wp-caption-text\">Data volume of SQL after<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>Did you know there are 60+ perf counter rules\u00a0in 2012 alone, and nearly 200 in 2016?<\/p>\n<p>&nbsp;<\/p>\n<p>How about an OFF pack, a management pack that turns off all the performance counter rules?<\/p>\n<p>The monitors still exist for health, just no pretty performance graph, should you look.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Github repo <a href=\"https:\/\/github.com\/theKevinJustin\/Monitoring\/releases\/tag\/untagged-8897ffd281f49d42a4f4\" target=\"_blank\" rel=\"noopener\">link<\/a><\/p>\n<p>Check out the Gallery post for download<\/p>\n<h1><a href=\"https:\/\/gallery.technet.microsoft.com\/SCOM-SQL-Performance-Rule-0354ea38\" target=\"_blank\" rel=\"noopener noreferrer\">TechNet gallery download<\/a><\/h1>\n<p>&nbsp;<\/p>\n<p><strong>Zip file contains<\/strong><\/p>\n<ol>\n<li>\u00a0OFF MP&#8217;s for 2008,2012,2014,2016<\/li>\n<li>XLS sheets to allow you to go to the SQL team and ask them what performance counters they use<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Updated 25 Feb 2023 &nbsp; Ever wish alerts were like a wad of cash? The more you solve, the more you make! &nbsp; How about performance counter data? &nbsp; &nbsp; The SQL management packs are awesome for visualizations, and provide a bunch of data. &nbsp; Tim McFadden\u00a0pointed out\u00a0SQL Performance counters https:\/\/www.scom2k7.com\/crazy-db-performance-collection-rules-in-the-sql-mps\/ His blog brings up &hellip; <a href=\"https:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;SQL MP bloat&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,5,7,530,556,11],"tags":[342,349,358,360,363,364,415,417],"class_list":["post-4115","post","type-post","status-publish","format-standard","hentry","category-administration","category-best-practice","category-mp-management-pack","category-scom","category-sql","category-troubleshooting","tag-scom","tag-scom-2016","tag-scom-performance-counter-rule","tag-scom-rule","tag-scom2012r2","tag-scom2016","tag-sql-mp","tag-sql-performance-counters"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL MP bloat - Kevin Justin&#039;s Blog<\/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:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL MP bloat - Kevin Justin&#039;s Blog\" \/>\n<meta property=\"og:description\" content=\"Updated 25 Feb 2023 &nbsp; Ever wish alerts were like a wad of cash? The more you solve, the more you make! &nbsp; How about performance counter data? &nbsp; &nbsp; The SQL management packs are awesome for visualizations, and provide a bunch of data. &nbsp; Tim McFadden\u00a0pointed out\u00a0SQL Performance counters https:\/\/www.scom2k7.com\/crazy-db-performance-collection-rules-in-the-sql-mps\/ His blog brings up &hellip; Continue reading &quot;SQL MP bloat&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/\" \/>\n<meta property=\"og:site_name\" content=\"Kevin Justin&#039;s Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-02T20:02:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-25T15:05:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/wad-of-cash.png\" \/>\n<meta name=\"author\" content=\"Kevin Justin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kevin Justin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2018\\\/03\\\/02\\\/sql-mp-bloat\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2018\\\/03\\\/02\\\/sql-mp-bloat\\\/\"},\"author\":{\"name\":\"Kevin Justin\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/213cdc5c6c3f2a1d9e8417c07440972d\"},\"headline\":\"SQL MP bloat\",\"datePublished\":\"2018-03-02T20:02:44+00:00\",\"dateModified\":\"2023-02-25T15:05:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2018\\\/03\\\/02\\\/sql-mp-bloat\\\/\"},\"wordCount\":333,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2018\\\/03\\\/02\\\/sql-mp-bloat\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/wad-of-cash.png\",\"keywords\":[\"SCOM\",\"scom 2016\",\"scom performance counter rule\",\"scom rule\",\"scom2012r2\",\"scom2016\",\"sql mp\",\"sql performance counters\"],\"articleSection\":[\"Administration\",\"Best Practice\",\"MP Management Pack\",\"SCOM\",\"SQL\",\"Troubleshooting\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2018\\\/03\\\/02\\\/sql-mp-bloat\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2018\\\/03\\\/02\\\/sql-mp-bloat\\\/\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2018\\\/03\\\/02\\\/sql-mp-bloat\\\/\",\"name\":\"SQL MP bloat - Kevin Justin&#039;s Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2018\\\/03\\\/02\\\/sql-mp-bloat\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2018\\\/03\\\/02\\\/sql-mp-bloat\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/wad-of-cash.png\",\"datePublished\":\"2018-03-02T20:02:44+00:00\",\"dateModified\":\"2023-02-25T15:05:31+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/213cdc5c6c3f2a1d9e8417c07440972d\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2018\\\/03\\\/02\\\/sql-mp-bloat\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2018\\\/03\\\/02\\\/sql-mp-bloat\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2018\\\/03\\\/02\\\/sql-mp-bloat\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/wad-of-cash.png\",\"contentUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/wad-of-cash.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2018\\\/03\\\/02\\\/sql-mp-bloat\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL MP bloat\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/\",\"name\":\"Kevin Justin&#039;s Blog\",\"description\":\"Operational monitoring tools including System Center, Azure Monitor\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/213cdc5c6c3f2a1d9e8417c07440972d\",\"name\":\"Kevin Justin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g\",\"caption\":\"Kevin Justin\"},\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/author\\\/kejustin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL MP bloat - Kevin Justin&#039;s Blog","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:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/","og_locale":"en_US","og_type":"article","og_title":"SQL MP bloat - Kevin Justin&#039;s Blog","og_description":"Updated 25 Feb 2023 &nbsp; Ever wish alerts were like a wad of cash? The more you solve, the more you make! &nbsp; How about performance counter data? &nbsp; &nbsp; The SQL management packs are awesome for visualizations, and provide a bunch of data. &nbsp; Tim McFadden\u00a0pointed out\u00a0SQL Performance counters https:\/\/www.scom2k7.com\/crazy-db-performance-collection-rules-in-the-sql-mps\/ His blog brings up &hellip; Continue reading \"SQL MP bloat\"","og_url":"https:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/","og_site_name":"Kevin Justin&#039;s Blog","article_published_time":"2018-03-02T20:02:44+00:00","article_modified_time":"2023-02-25T15:05:31+00:00","og_image":[{"url":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/wad-of-cash.png","type":"","width":"","height":""}],"author":"Kevin Justin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kevin Justin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/#article","isPartOf":{"@id":"https:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/"},"author":{"name":"Kevin Justin","@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/213cdc5c6c3f2a1d9e8417c07440972d"},"headline":"SQL MP bloat","datePublished":"2018-03-02T20:02:44+00:00","dateModified":"2023-02-25T15:05:31+00:00","mainEntityOfPage":{"@id":"https:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/"},"wordCount":333,"commentCount":0,"image":{"@id":"https:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/#primaryimage"},"thumbnailUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/wad-of-cash.png","keywords":["SCOM","scom 2016","scom performance counter rule","scom rule","scom2012r2","scom2016","sql mp","sql performance counters"],"articleSection":["Administration","Best Practice","MP Management Pack","SCOM","SQL","Troubleshooting"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/","url":"https:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/","name":"SQL MP bloat - Kevin Justin&#039;s Blog","isPartOf":{"@id":"https:\/\/kevinjustin.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/#primaryimage"},"image":{"@id":"https:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/#primaryimage"},"thumbnailUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/wad-of-cash.png","datePublished":"2018-03-02T20:02:44+00:00","dateModified":"2023-02-25T15:05:31+00:00","author":{"@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/213cdc5c6c3f2a1d9e8417c07440972d"},"breadcrumb":{"@id":"https:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/#primaryimage","url":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/wad-of-cash.png","contentUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2018\/03\/wad-of-cash.png"},{"@type":"BreadcrumbList","@id":"https:\/\/kevinjustin.com\/blog\/2018\/03\/02\/sql-mp-bloat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kevinjustin.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL MP bloat"}]},{"@type":"WebSite","@id":"https:\/\/kevinjustin.com\/blog\/#website","url":"https:\/\/kevinjustin.com\/blog\/","name":"Kevin Justin&#039;s Blog","description":"Operational monitoring tools including System Center, Azure Monitor","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kevinjustin.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/213cdc5c6c3f2a1d9e8417c07440972d","name":"Kevin Justin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g","caption":"Kevin Justin"},"url":"https:\/\/kevinjustin.com\/blog\/author\/kejustin\/"}]}},"_links":{"self":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/4115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/comments?post=4115"}],"version-history":[{"count":2,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/4115\/revisions"}],"predecessor-version":[{"id":7017,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/4115\/revisions\/7017"}],"wp:attachment":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/media?parent=4115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/categories?post=4115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/tags?post=4115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}