locked
Clean database Forefront RRS feed

  • Question

  • I see a 10 GB reporting database with a 5GB log... Where can I configure what to keep and so keep the size of the reporting database smaller?
    Monday, August 2, 2010 8:33 AM

Answers

  • How to do it is in the article i mentioned

    there is no UI, you have to run SQL commands

    The syntax of this stored procedure is as follows:

    exec p_updategroomdays '<var>TableName</var>', <var>DaysToRetainData</var>

    In this example, <var>TableName</var> is one of the six main tables, and <var>DaysToRetainData</var> is the number of days to retain data in that table. The following six main tables in the SystemCenterReporting database represent a different type of data that is collected by MOM 2005:

    • SC_AlertFact_Table
    • SC_SampledNumericDataFact_Table
    • SC_EventParameterFact_Table
    • SC_AlertToEventFact_Table
    • SC_EventFact_Table
    • SC_AlertHistoryFact_Table

    MCSE, forefront spec | www.msforefront.com
    • Marked as answer by LA1976 Tuesday, August 3, 2010 10:36 AM
    Monday, August 2, 2010 9:30 PM

All replies

  • Hi!

    You can set the amount of days to keep historical data by setting "grooming value" by default FCS keeps historical data in 395 days.

    Here is the how to:

    http://support.microsoft.com/kb/887016/

    it's important that the db:s are set to correct size so you don't run out of space since autogrow is not enabled (or supported).

    db guide here:

    http://blogs.technet.com/b/fcsnerds/archive/2008/09/25/fcs-with-mom-2005-database-guidance.aspx

    /Johan


    MCSE, forefront spec | www.msforefront.com
    Monday, August 2, 2010 10:00 AM
  • Have not found the answer where you can set the days that data should be keeped but a great post how to clean out the database.

    http://blogs.technet.com/b/fcsnerds/archive/2008/09/25/fcs-with-mom-2005-database-guidance.aspx

     

    • Proposed as answer by Snilerdahl Tuesday, September 21, 2010 9:11 AM
    Monday, August 2, 2010 10:09 AM
  • How to do it is in the article i mentioned

    there is no UI, you have to run SQL commands

    The syntax of this stored procedure is as follows:

    exec p_updategroomdays '<var>TableName</var>', <var>DaysToRetainData</var>

    In this example, <var>TableName</var> is one of the six main tables, and <var>DaysToRetainData</var> is the number of days to retain data in that table. The following six main tables in the SystemCenterReporting database represent a different type of data that is collected by MOM 2005:

    • SC_AlertFact_Table
    • SC_SampledNumericDataFact_Table
    • SC_EventParameterFact_Table
    • SC_AlertToEventFact_Table
    • SC_EventFact_Table
    • SC_AlertHistoryFact_Table

    MCSE, forefront spec | www.msforefront.com
    • Marked as answer by LA1976 Tuesday, August 3, 2010 10:36 AM
    Monday, August 2, 2010 9:30 PM