locked
Database size threshold exceeded RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    could you help me please resolved this issue see below detail 

    DPM database size has exceeded the threshold limit.
    DPM database size: 1.06 GB
    DPM database location: c:\Program Files\Microsoft System Center\DPM\DPM\DPMDB\ on VM (ID 3168)

    Should I increase my DPM database or clean up ?

    thank you

    Monday, July 13, 2020 1:34 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    The Data files looks good to me. I guess someone may have checked where it says "Alert me when DPM Database size reached" = 1gb  and hence it triggered the alert as your DPMDB size is now around 2gb

    Now as per the latest screenshot, I see that option is unchecked, so you are good for now. You can dismiss the old alert and it should not bother you again :). Let me know if it works for you. Thanks.

    • Marked as answer by Mooner09 Wednesday, July 15, 2020 4:19 PM
    Wednesday, July 15, 2020 4:17 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    It looks like you have manually set the Tape catalog retention from DPM console. DPM maintains Tape catalog for X period of time (User defined) and it also has an option to alert if DPMDB size exceeds a certain limit so that a user can keep an on the DPM catalog size.

    Go to the Protection Tab, from the top ribbon menu you must see Tape catalog retention. Tweak your setting as per your need. 1gb is looks okay to me. So you may need to change the threshold limit defined in that section.


    Monday, July 13, 2020 1:45 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    DPM generates this alert when the disk space used for the tape catalog database on the DPM database exceeds the user set threshold.

    Some resolution steps:

    • The error conditions and recommended actions associated with each “Database size threshold exceeded” alert are provided in the alert details.

    • Prune the tape catalog database to reduce the size below the threshold value or increase the threshold value.

    • You can increase the free space on the volume on which the DPM database (DPMDB) is located. The DPMDB location is configured during DPM Setup. To verify the instance of SQL Server that contains the DPMDB volume, in DPM Administrator Console, click the information icon on the navigation bar.

    • To prune the tape catalog or increase the database size threshold, in the Protection task area, in the Actions pane, click Specify tape catalog retention. For more information, in the DPM Operations Guide, see Managing Tape Libraries (http://go.microsoft.com/fwlink/?LinkId=91964).

    The alert is usually resolved when the library catalog is pruned, or the database threshold value is increased.

    Reference:
    https://systemscenter.ru/dpm_help.en/html/d99e448e-679b-45a5-981b-176ee4acbec2.htm

    Best regards,
    Leon

    Blog: https://thesystemcenterblog.com LinkedIn:

    Monday, July 13, 2020 4:43 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Aayoosh,

    see below my Tape Catalog Retention, what should I change ?, thank you

    

    Wednesday, July 15, 2020 2:40 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    You can change the catalog retention to something that suits your needs.

    Blog: https://thesystemcenterblog.com LinkedIn:

    Wednesday, July 15, 2020 2:51 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    So you already have the default setting and you havent configured to receive an alert if DPMDB size exceeds a certain limit. Can you please share the disk usage report so that we can see whats the current status.

    Follow below steps:

    Wednesday, July 15, 2020 2:55 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    unfortunately I'm not able to get report the button is grey see below

     
    Wednesday, July 15, 2020 3:54 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Okay - then lets do it via SQL query. Run below query against the DPMDB and share the result:

    Go
declare @TableSpace table (TableName sysname, RowsK varchar(32), ReservedMB varchar(32), DataMB varchar(32), IndexSizeMB varchar(32), UnusedMB varchar(32))
insert @TableSpace
exec sp_MSforeachtable @command1="exec sp_spaceused '?';"
update @TableSpace set RowsK = CONVERT(varchar, 1+convert(int, RowsK)/1024)
update @TableSpace set ReservedMB = CONVERT(varchar, 1+convert(int,LEFT(ReservedMB, charindex(' K', ReservedMB,-1)))/1024)
update @TableSpace set DataMB = CONVERT(varchar, 1+convert(int,LEFT(DataMB, charindex(' K', DataMB,-1)))/1024)
update @TableSpace set IndexSizeMB = CONVERT(varchar, convert(int,LEFT(IndexSizeMB, charindex(' K', IndexSizeMB,-1)))/1024)
update @TableSpace set UnusedMB = CONVERT(varchar, convert(int,LEFT(UnusedMB, charindex(' K', UnusedMB,-1)))/1024)
select * from @TableSpace order by convert(int,ReservedMB) desc
go

    Wednesday, July 15, 2020 4:00 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    sorry it's start working see below 

    Wednesday, July 15, 2020 4:08 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    The Data files looks good to me. I guess someone may have checked where it says "Alert me when DPM Database size reached" = 1gb  and hence it triggered the alert as your DPMDB size is now around 2gb

    Now as per the latest screenshot, I see that option is unchecked, so you are good for now. You can dismiss the old alert and it should not bother you again :). Let me know if it works for you. Thanks.

    • Marked as answer by Mooner09 Wednesday, July 15, 2020 4:19 PM
    Wednesday, July 15, 2020 4:17 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hey Aayoosh, thank you for your help I just dismiss alert 
    Wednesday, July 15, 2020 4:19 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    You are welcome :)
    Wednesday, July 15, 2020 4:20 PM