<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.technet.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Data Warehouse Data Retention Policy (dwdatarp.exe)</title><link>http://blogs.technet.com/momteam/archive/2008/05/14/data-warehouse-data-retention-policy-dwdatarp-exe.aspx</link><description>The tool linked in this article allows you to view and configure the data warehouse data retention policies configured within your Operations Manager DW. Follow the instructions below to use. Prerequisites Operations Manager 2007 SP1 Operations Manager</description><dc:language>en-US</dc:language><generator>CommunityServer 2.1 SP1 (Build: 61025.2)</generator><item><title>Tool for DW Groom Settings &amp;laquo; Ian Blyth - System Center Technologies</title><link>http://blogs.technet.com/momteam/archive/2008/05/14/data-warehouse-data-retention-policy-dwdatarp-exe.aspx#3056714</link><pubDate>Sat, 17 May 2008 13:40:19 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3056714</guid><dc:creator>Tool for DW Groom Settings &amp;laquo; Ian Blyth - System Center Technologies</dc:creator><description>&lt;p&gt;PingBack from &lt;a rel="nofollow" target="_new" href="http://ianblythmanagement.wordpress.com/2008/05/17/tool-for-dw-groom-settings/"&gt;http://ianblythmanagement.wordpress.com/2008/05/17/tool-for-dw-groom-settings/&lt;/a&gt;&lt;/p&gt;
</description></item><item><title>Data Warehouse Data Retention Policy (dwdatarp.exe)</title><link>http://blogs.technet.com/momteam/archive/2008/05/14/data-warehouse-data-retention-policy-dwdatarp-exe.aspx#3056951</link><pubDate>Sun, 18 May 2008 10:27:40 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3056951</guid><dc:creator>Operations Manager blog by scug.be</dc:creator><description>&lt;p&gt;A friend of me asked me a couple of days ago how he had to view and configure the datawarehouse data&lt;/p&gt;
</description></item><item><title>OpsMgr 2007 toolbox</title><link>http://blogs.technet.com/momteam/archive/2008/05/14/data-warehouse-data-retention-policy-dwdatarp-exe.aspx#3061115</link><pubDate>Mon, 26 May 2008 12:55:58 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3061115</guid><dc:creator>Stefan Stranger's Weblog</dc:creator><description>&lt;p&gt;There are so many tools currently developed that it is hard to know where to find them. Here is a list&lt;/p&gt;
</description></item><item><title>re: Data Warehouse Data Retention Policy (dwdatarp.exe)</title><link>http://blogs.technet.com/momteam/archive/2008/05/14/data-warehouse-data-retention-policy-dwdatarp-exe.aspx#3061189</link><pubDate>Mon, 26 May 2008 15:41:05 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3061189</guid><dc:creator>Pavel Dzemyantsau</dc:creator><description>&lt;p&gt;What entity is responsible for grooming data in DW database? Can't find SCDWGroomJob SQL job as it was in MOM 2005. I know that there is groome rule for regular DB, but how about DW DB? &amp;nbsp; &lt;/p&gt;
</description></item><item><title>re: Data Warehouse Data Retention Policy (dwdatarp.exe)</title><link>http://blogs.technet.com/momteam/archive/2008/05/14/data-warehouse-data-retention-policy-dwdatarp-exe.aspx#3061787</link><pubDate>Tue, 27 May 2008 21:52:35 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3061787</guid><dc:creator>Satya Vel</dc:creator><description>&lt;p&gt;You can run the below query to verify DW grooming is happening. &lt;/p&gt;
&lt;p&gt;Try it against the perf hourly dataset and use the query below to check&lt;/p&gt;
&lt;p&gt;select &lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp;min(datetime)as MinDate, &lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp;max(datetime)as MaxDate ,&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp;datediff(d,min(datetime),max(datetime)) AS NoOfDaysInDataSet &lt;/p&gt;
&lt;p&gt;from Perf.vPerfHourly&lt;/p&gt;
</description></item><item><title>Data Warehouse Data Retention Policy (dwdatarp.exe) in Opsmgr</title><link>http://blogs.technet.com/momteam/archive/2008/05/14/data-warehouse-data-retention-policy-dwdatarp-exe.aspx#3112984</link><pubDate>Wed, 27 Aug 2008 23:27:26 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3112984</guid><dc:creator>SCUG</dc:creator><description>&lt;p&gt;A friend of me asked me a couple of days ago how he had to view and configure the datawarehouse data&lt;/p&gt;
</description></item><item><title>Post-Installation Tasks</title><link>http://blogs.technet.com/momteam/archive/2008/05/14/data-warehouse-data-retention-policy-dwdatarp-exe.aspx#3130314</link><pubDate>Tue, 30 Sep 2008 20:24:00 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3130314</guid><dc:creator>Walter Chomak's System Center Operations Manager 2007 Landing Zone</dc:creator><description>&lt;p&gt;So you just finished installing OpsMgr successfully and now it is time to begin using it. This post has&lt;/p&gt;
</description></item><item><title>Data Warehouse Data Retention Policy (dwdatarp.exe)</title><link>http://blogs.technet.com/momteam/archive/2008/05/14/data-warehouse-data-retention-policy-dwdatarp-exe.aspx#3130744</link><pubDate>Wed, 01 Oct 2008 15:42:47 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3130744</guid><dc:creator>Rod Trent at myITforum.com</dc:creator><description>&lt;p&gt;The tool linked in this article allows you to view and configure the data warehouse data retention policies&lt;/p&gt;
</description></item><item><title>SCOM 2007 Useful Links</title><link>http://blogs.technet.com/momteam/archive/2008/05/14/data-warehouse-data-retention-policy-dwdatarp-exe.aspx#3131497</link><pubDate>Thu, 02 Oct 2008 20:56:19 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3131497</guid><dc:creator>Dario IT Solutions Blog</dc:creator><description>&lt;p&gt;Main Downloads page (catalog, documentation) &lt;a rel="nofollow" target="_new" href="http://technet.microsoft.com/en-us/opsmgr/bb498232.aspx"&gt;http://technet.microsoft.com/en-us/opsmgr/bb498232.aspx&lt;/a&gt;&lt;/p&gt;
</description></item><item><title>Working with Large Data Warehouses</title><link>http://blogs.technet.com/momteam/archive/2008/05/14/data-warehouse-data-retention-policy-dwdatarp-exe.aspx#3136003</link><pubDate>Mon, 13 Oct 2008 22:47:37 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3136003</guid><dc:creator>Walter Chomak's System Center Operations Manager 2007 Landing Zone</dc:creator><description>&lt;p&gt;So your are design an environment with enough agents and a retention policy necessitating a terabyte&lt;/p&gt;
</description></item><item><title>Microsoft System Center Operations Manager 2007 - Links, References, Tools and Blogs</title><link>http://blogs.technet.com/momteam/archive/2008/05/14/data-warehouse-data-retention-policy-dwdatarp-exe.aspx#3198449</link><pubDate>Sat, 07 Feb 2009 06:14:01 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3198449</guid><dc:creator>System Center Consulting</dc:creator><description>&lt;p&gt;Summary This document will provide guidance to online links, resources, tools and blogs to assist in&lt;/p&gt;
</description></item><item><title>Les meilleurs liens OPSMGR 2007</title><link>http://blogs.technet.com/momteam/archive/2008/05/14/data-warehouse-data-retention-policy-dwdatarp-exe.aspx#3207050</link><pubDate>Thu, 26 Feb 2009 19:21:43 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3207050</guid><dc:creator>Blog Opsmgr / SCOM 2007, and Windows 2008 , Seven ...in french</dc:creator><description>&lt;p&gt;&amp;amp;#160; Voici une liste de liens tr&amp;#233;s pratique sur tous les sujets SCOM , installation , configuration...&lt;/p&gt;
</description></item></channel></rss>