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