question

Anchalgupta-2608 avatar image
0 Votes"
Anchalgupta-2608 asked StoyanChalakov answered

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

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

msc-operations-manager
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AndrewBlumhardt-1137 avatar image
0 Votes"
AndrewBlumhardt-1137 answered

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/

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

StoyanChalakov avatar image
0 Votes"
StoyanChalakov answered

Hi @Anchalgupta-2608,

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://docs.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




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.