none
DPM2010 Large DPMDB almost 40GB RRS feed

  • Question

  • DPM2010 configuration:

    2 x WIN 2008 R2 - DPM2010 Server 

    Primary DPM - DPMDB 40GB

    Secondary DPM - DPMDB <1GB

    I would like to know if this stored procedures should be called every day?

    • prc_AHP_GarbageCollect
    • prc_AM_GarbageCollect
    • prc_CM_GarbageCollect
    • prc_DLS_GarbageCollect1
    • prc_DLS_GarbageCollect2
    • prc_JM_GarbageCollect
    • prc_SM_GarbageCollect

    On secondary DPM this procedures run often on primary never. Why is that so?

    Would it be possible to get Name of jobs (SQL Server Agent) running these procedures?

    Monday, July 23, 2012 8:49 AM

Answers

  • Calling these procedures solved the problem, DB now only 10 GB (which is normal for our environment):

    • prc_AHP_GarbageCollect
    • prc_AM_GarbageCollect
    • prc_CM_GarbageCollect
    • prc_DLS_GarbageCollect1
    • prc_DLS_GarbageCollect2
    • prc_JM_GarbageCollect
    • prc_SM_GarbageCollect

    For some reason these procedures weren't executing every day at 21:00 i think. But after i run them manually now they are executing daily normally. It will take some time for procedures to complete.


    Tornado

    • Marked as answer by BOETORNADO Sunday, November 11, 2012 12:40 PM
    Sunday, November 11, 2012 12:40 PM

All replies

  • Hi Boetornado

    Did you come right? Have you tried shrinking the DB at all?

    Kind Regards

    Sunday, November 11, 2012 11:42 AM
  • Calling these procedures solved the problem, DB now only 10 GB (which is normal for our environment):

    • prc_AHP_GarbageCollect
    • prc_AM_GarbageCollect
    • prc_CM_GarbageCollect
    • prc_DLS_GarbageCollect1
    • prc_DLS_GarbageCollect2
    • prc_JM_GarbageCollect
    • prc_SM_GarbageCollect

    For some reason these procedures weren't executing every day at 21:00 i think. But after i run them manually now they are executing daily normally. It will take some time for procedures to complete.


    Tornado

    • Marked as answer by BOETORNADO Sunday, November 11, 2012 12:40 PM
    Sunday, November 11, 2012 12:40 PM