Shrinking OpsMgr DW DB configured with Always ON - SCOM 2012 R2

Anchal gupta 21 Reputation points
2022-03-16T10:28:45.677+00:00

Hi All, we have SCOM 2012 R2 infra with 5MS and 12GW servers where both OpsMgrDB and DW are configured with always ON.

Now the situation is that our DW dbs suddenly grew to an extent where disk drive had only 6% free space, where we identified that some event flood has filled our DB to this extent.

We initially reduced the retention of our event dataset from 90 to 2 days so that it can groom the data, and now once it is groomed, we have 50% free space available in the DB and not on the drive.

So in order to make free space available on our disk, we are thinking to shrink DW DB files, but since it is configured with always ON we are not sure how to proceed because we do not want our SCOM to be down during the shrinking activity.

Can anyone help us here?

Thanks

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,413 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andrew Blumhardt 9,491 Reputation points Microsoft Employee
    2022-03-16T11:53:23.137+00:00

    In my experience it is OK to shrink the DB if there is excess disk allocation. Make sure to leave some wiggle room.

    It will help to have a good understanding if the grooming process. This can be manipulated to speed cleanup of records after making retention changes. https://kevinholman.com/2008/02/12/grooming-process-in-the-scom-database/

    0 comments
  2. SChalakov 10,261 Reputation points MVP
    2022-03-16T12:07:44.12+00:00

    Hi @Anchal gupta ,

    Yes, you could do that...here alswo some references from tthe Microsoft Social Technet and the new MS Docs on this topic:

    Backup and Shrinking of Database
    https://social.technet.microsoft.com/Forums/en-US/ae881496-1d96-4e92-a563-05d8d2f05bbb/backup-and-shrinking-of-database?forum=operationsmanagergeneral

    and this refernce to a blog post:

    How to shrink OperationsManagerDW database file size
    https://learn.microsoft.com/en-us/archive/blogs/csstwplatform/how-to-shrink-operationsmanagerdw-database-file-size

    Please make sure to follow the procedure from the blof in order to do this properly.

    ----------

    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

    Regards
    Stoyan Chalakov

    0 comments