{"id":16443,"date":"2021-06-11T07:42:03","date_gmt":"2021-06-11T05:42:03","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/"},"modified":"2021-06-11T07:42:03","modified_gmt":"2021-06-11T05:42:03","slug":"sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/","title":{"rendered":"SQL Server SCOM: Many perf.perfHourly and State.StateHourly tables in OperationManagerDW"},"content":{"rendered":"<p>By a customer, the SCOM&#8217;s Database OperationManagerDW growth fast and becomes very big.<\/p>\n<p>To see what&#8217;s happens, in SSMS (SQL Server Management Studio), I right-click on the database open Reports&gt;Standard Report&gt; Disk Usage by Top Tables:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/OperationManagerDW00.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-50391 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/OperationManagerDW00.png\" alt=\"\" width=\"300\" height=\"170\" \/><\/a>You have many interesting reports with SSMS and I advise you to use it.<br \/>\nIn my case the &#8220;Disk Usage by Top Tables&#8221; report displays me many perf.perfHourly and State.StateHourly tables with a _guid():<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/OperationManagerDW01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-50392 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/OperationManagerDW01.png\" alt=\"\" width=\"257\" height=\"300\" \/><\/a><br \/>\nAfter reading some blog&#8217;s, the most interesting blog was the blog from <a href=\"https:\/\/kevinholman.com\/\" target=\"_blank\" rel=\"noopener\">Kevin Holman<\/a> about &#8220;<a href=\"https:\/\/kevinholman.com\/2010\/01\/05\/understanding-and-modifying-data-warehouse-retention-and-grooming\/\" target=\"_blank\" rel=\"noopener\">Understanding and modifying Data Warehouse retention and grooming<\/a>&#8221;<br \/>\nMy goal is just to share, how I use this good blog to help my customer.<br \/>\nUsing the query to retrieve the information like this one below, I discuss with the SCOM responsible:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT DataSetDefaultName, AggregationTypeId, MaxDataAgeDays FROM StandardDatasetAggregation sda INNER JOIN dataset ds ON ds.datasetid = sda.datasetid ORDER BY DataSetDefaultName<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/OperationManagerDW02.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-50390 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/OperationManagerDW02.png\" alt=\"\" width=\"211\" height=\"300\" \/><\/a><br \/>\nAccording to the Scom Application owner, we apply some recommendations.<br \/>\nThe first settings was apply by the SCOM responsible on the SCOM server side:<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">dwdatarp.exe -s &lt;sqlservername&gt; -d OperationsManagerDW -ds \"Performance data set\" -a \"Hourly aggregations\" -m 60\n\ndwdatarp.exe -s &lt;sqlservername&gt;\u00a0 -d OperationsManagerDW -ds \"Performance data set\" -a \"Daily aggregations\" -m 180\n\ndwdatarp.exe -s &lt;sqlservername&gt;\u00a0 -d OperationsManagerDW -ds \"Alert data set\" -a \"Raw data\" -m 100\n\ndwdatarp.exe -s &lt;sqlservername&gt; -d OperationsManagerDW -ds \"Event data set\" -a \"Raw Data\" -m 10\n\ndwdatarp.exe -s &lt;sqlservername&gt;\u00a0 -d OperationsManagerDW -ds \"State data set\" -a \"Raw data\" -m 60\n\ndwdatarp.exe -s &lt;sqlservername&gt;\u00a0 -d OperationsManagerDW -ds \"State data set\" -a \"Hourly aggregations\" -m 60\n\ndwdatarp.exe -s &lt;sqlservername&gt; -d OperationsManagerDW -ds \"State data set\" -a \"Daily aggregations\" -m 90<\/pre>\n<p>In a second time,\u00a0 I run these queries to change some retentions:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">--Alert Data\n\nUPDATE StandardDatasetAggregation\n\nSET MaxDataAgeDays = 100 --default is 400\n\nWHERE GroomStoredProcedureName = 'AlertGroom'\n\n--Event Data\n\nUPDATE StandardDatasetAggregation\n\nSET MaxDataAgeDays = 10 --default is 100\n\nWHERE GroomStoredProcedureName = 'EventGroom'\n\n--Performance HOURLY\n\nUPDATE StandardDatasetAggregation\n\nSET MaxDataAgeDays = 60 --default is 400\n\nWHERE GroomStoredProcedureName = 'PerformanceGroom' AND AggregationTypeId = '20'\n\n--Performance DAILY\n\nUPDATE StandardDatasetAggregation\n\nSET MaxDataAgeDays = 180 --default is 400\n\nWHERE GroomStoredProcedureName = 'PerformanceGroom' AND AggregationTypeId = '30'\n\n--State RAW\n\nUPDATE StandardDatasetAggregation\n\nSET MaxDataAgeDays = 60 --default is 180\n\nWHERE GroomStoredProcedureName = 'StateGroom' AND AggregationTypeId = '0'\n\n--State HOURLY\n\nUPDATE StandardDatasetAggregation\n\nSET MaxDataAgeDays = 60 --default is 400\n\nWHERE GroomStoredProcedureName = 'StateGroom' AND AggregationTypeId = '20'\n\n--State DAILY\n\nUPDATE StandardDatasetAggregation\n\nSET MaxDataAgeDays = 90 --default is 400\n\nWHERE GroomStoredProcedureName = 'StateGroom' AND AggregationTypeId = '30'\n\n<\/pre>\n<p>After these changes, the database wasn&#8217;t growing fast and no more so many perf.perfHourly and State.StateHourly tables with a _guid().<\/p>\n<p>I do this blog to share my experience with the SCOM database OperationManagerDW and give you some tips to have an optimized database for SCOM.<\/p>\n<p>Thanks\u00a0 to <a href=\"https:\/\/kevinholman.com\/\" target=\"_blank\" rel=\"noopener\">Kevin Holman<\/a> for your help!<\/p>\n<p>I hope this blog can help other DBA to do the same to not have a big database for nothing&#8230; \ud83d\ude09<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By a customer, the SCOM&#8217;s Database OperationManagerDW growth fast and becomes very big. To see what&#8217;s happens, in SSMS (SQL Server Management Studio), I right-click on the database open Reports&gt;Standard Report&gt; Disk Usage by Top Tables: You have many interesting reports with SSMS and I advise you to use it. In my case the &#8220;Disk [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":16446,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,368,99],"tags":[49,211,51],"type_dbi":[],"class_list":["post-16443","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-database-management","category-development-performance","category-sql-server","tag-microsoft","tag-scom","tag-sql-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server SCOM: Many perf.perfHourly and State.StateHourly tables in OperationManagerDW - dbi 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:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server SCOM: Many perf.perfHourly and State.StateHourly tables in OperationManagerDW\" \/>\n<meta property=\"og:description\" content=\"By a customer, the SCOM&#8217;s Database OperationManagerDW growth fast and becomes very big. To see what&#8217;s happens, in SSMS (SQL Server Management Studio), I right-click on the database open Reports&gt;Standard Report&gt; Disk Usage by Top Tables: You have many interesting reports with SSMS and I advise you to use it. In my case the &#8220;Disk [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-06-11T05:42:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/OperationManagerDW02.png\" \/>\n\t<meta property=\"og:image:width\" content=\"628\" \/>\n\t<meta property=\"og:image:height\" content=\"895\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server SCOM: Many perf.perfHourly and State.StateHourly tables in OperationManagerDW\",\"datePublished\":\"2021-06-11T05:42:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/\"},\"wordCount\":259,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/OperationManagerDW02.png\",\"keywords\":[\"Microsoft\",\"SCOM\",\"SQL Server\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\",\"Development &amp; Performance\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/\",\"name\":\"SQL Server SCOM: Many perf.perfHourly and State.StateHourly tables in OperationManagerDW - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/OperationManagerDW02.png\",\"datePublished\":\"2021-06-11T05:42:03+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/OperationManagerDW02.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/OperationManagerDW02.png\",\"width\":628,\"height\":895},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server SCOM: Many perf.perfHourly and State.StateHourly tables in OperationManagerDW\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server SCOM: Many perf.perfHourly and State.StateHourly tables in OperationManagerDW - dbi 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:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server SCOM: Many perf.perfHourly and State.StateHourly tables in OperationManagerDW","og_description":"By a customer, the SCOM&#8217;s Database OperationManagerDW growth fast and becomes very big. To see what&#8217;s happens, in SSMS (SQL Server Management Studio), I right-click on the database open Reports&gt;Standard Report&gt; Disk Usage by Top Tables: You have many interesting reports with SSMS and I advise you to use it. In my case the &#8220;Disk [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/","og_site_name":"dbi Blog","article_published_time":"2021-06-11T05:42:03+00:00","og_image":[{"width":628,"height":895,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/OperationManagerDW02.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server SCOM: Many perf.perfHourly and State.StateHourly tables in OperationManagerDW","datePublished":"2021-06-11T05:42:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/"},"wordCount":259,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/OperationManagerDW02.png","keywords":["Microsoft","SCOM","SQL Server"],"articleSection":["Database Administration &amp; Monitoring","Database management","Development &amp; Performance","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/","name":"SQL Server SCOM: Many perf.perfHourly and State.StateHourly tables in OperationManagerDW - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/OperationManagerDW02.png","datePublished":"2021-06-11T05:42:03+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/OperationManagerDW02.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/OperationManagerDW02.png","width":628,"height":895},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-scom-configuration-many-perf-perfhourly-and-state-statehourly-tables-in-the-database-operationmanagerdw\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server SCOM: Many perf.perfHourly and State.StateHourly tables in OperationManagerDW"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16443","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=16443"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16443\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/16446"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16443"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16443"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16443"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16443"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}