Data Warehouse Data Retention Policy (dwdatarp.exe)

Data Warehouse Data Retention Policy (dwdatarp.exe)

  • Comments 13
  • Likes

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 2007 Reporting SP1

Installation

Download the attached zip file and copy the required version of the file either x86 or x64 to a local directory such as “c:\dwdatarp\”

Usage

·         To view dwdatarp.exe usage instructions run:
c:\dwdatarp\dwdatarp.exe

 

·         To view current Data Retention settings run:

c:\dwdatarp\dwdatarp.exe –s “dw servername” –d “dw databasename”


example:  C:\dwdatarp>dwdatarp -s opsmgrsp1 -d OperationsManagerDW

 

·         To set Data Retention for a particular dataset run:

c:\dwdatarp\dwdatarp.exe –s “dw servername” –d “dw databasename” – ds “dataset name” –a “aggregation name” –m “days”

 

example: C:\dwdatarp>dwdatarp -s opsmgrsp1 -d OperationsManagerDW – ds “Performance data set” –a “Hourly aggregations” –m 399

Notes:

1.        The server with dwdatarp.exe installed must have access to the OperationsManagerDW along with the user running the tool.

2.       Updates are applied with immediate effect and data will be groomed during next grooming workflow.

 

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included utilities are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Daniel Savage

Program Manager | System Center Operations Manager

Attachment: dwdatarp.zip
Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
  • PingBack from http://ianblythmanagement.wordpress.com/2008/05/17/tool-for-dw-groom-settings/

  • A friend of me asked me a couple of days ago how he had to view and configure the datawarehouse data

  • There are so many tools currently developed that it is hard to know where to find them. Here is a list

  • 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?  

  • You can run the below query to verify DW grooming is happening.

    Try it against the perf hourly dataset and use the query below to check

    select

         min(datetime)as MinDate,

         max(datetime)as MaxDate ,

         datediff(d,min(datetime),max(datetime)) AS NoOfDaysInDataSet

    from Perf.vPerfHourly

  • A friend of me asked me a couple of days ago how he had to view and configure the datawarehouse data

  • So you just finished installing OpsMgr successfully and now it is time to begin using it. This post has

  • The tool linked in this article allows you to view and configure the data warehouse data retention policies

  • Main Downloads page (catalog, documentation) http://technet.microsoft.com/en-us/opsmgr/bb498232.aspx

  • So your are design an environment with enough agents and a retention policy necessitating a terabyte

  • Summary This document will provide guidance to online links, resources, tools and blogs to assist in

  •   Voici une liste de liens trés pratique sur tous les sujets SCOM , installation , configuration...