question

Richkm-1820 avatar image
0 Votes"
Richkm-1820 asked Crystal-MSFT commented

Cleanup the SCOM Server disk as it full .

Hello, I have SCOM 2019 small environment where a single server have all the feature installed and there is only one drive c: where all data and installation reside ,now disk is full. can I use shrink the Operation Manager DW File to release the unused space to free up the space. is there effect of it on working functionality of SCOM Server doing this steps.
94486-shrinkdb.png

please advice!





msc-operations-manager
shrinkdb.png (21.2 KiB)
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.

LeonLaude avatar image
0 Votes"
LeonLaude answered

Hi @Richkm-1820,

The best practice states that you should always install an application on a separate disk/partition and leave the C-drive for the operating system, and especially if you're using a SQL database, you should preferably have that also on a separate disk/partition.

Before consider any shrinking, I suggest you have a look at Kevin's SCOM database maintenance article over here:
https://kevinholman.com/2017/08/03/what-sql-maintenance-should-i-perform-on-my-scom-2016-databases

(Most should also apply for SCOM 2019)

Here's also an old TechNet forum thread discussing about this:
Backup and Shrinking of Database


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


Best regards,
Leon

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.

Crystal-MSFT avatar image
0 Votes"
Crystal-MSFT answered Crystal-MSFT commented

@Richkm-1820, For our environment, I notice there's only one c drive in our environment. And now the disk is full. And we want to shrink the Operations Manager DW.

Based as I know, if only the Operations Manager DW is not working, most of the SCOM function can still work.

To shrink OperationsmanagerDW database file size, we can follow the steps in the link below:
https://docs.microsoft.com/en-us/archive/blogs/csstwplatform/how-to-shrink-operationsmanagerdw-database-file-size
Note: Please ensure backup is done.

For our situation, we recommend to add another disk and move the SCOM databases to the new disk. This can avoid OS down when the disk out of space because of the SCOM database growing fast. To change the SCOM database to a new drive, here is a link for the reference:
https://docs.microsoft.com/en-us/system-center/scom/manage-move-opsdb?view=sc-om-2019

If the disk is not under our consideration recently, we can try the actions in the following link to reduce the size of our SCOM Data Warehouse size:
https://www.cookdown.com/blog/why-is-it-important-to-reduce-the-size-of-my-scom-data-warehouse
Note: Non-Microsoft link, just for the reference.

Hope it can help.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 3
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.

@Richkm-1820, How's everything going. I am writing to see if there's anything else we can help. If yes, feel free to let us know.

Thanks and have a nice day!

0 Votes 0 ·

thank you! appreciate detail ..still working on it.let you know once done

0 Votes 0 ·

@Richkm-1820, Thanks for letting us know the latest status. I understand we are still working on it. We will wait for your update. If there's anything else we can help during this time, feel free to let us know.

Thanks for your time and have a nice day!

0 Votes 0 ·
RogerXue-3369 avatar image
0 Votes"
RogerXue-3369 answered

I think that the Shrink unused space on operations manager DW does not affect SCOM but it is not the recommend solution in solving your issue.

1) If possible, relocate your operations manager database or data warehouse into another server or addition hard disk drive

2) use Operations Manager 2012 Sizing Helper Tool (https://techcommunity.microsoft.com/t5/system-center-blog/operations-manager-2012-sizing-helper-tool/ba-p/345075) to plan your hard disk space for operations manager database and data warehouse.

Roger

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.