question

kumar-9444 avatar image
0 Votes"
kumar-9444 asked Crystal-MSFT commented

How to purge old data in OperationsManagerDW 2016 database??

OperationsManagerDW (SCOM 2016) database size is around 850GB. The data which is older than 1year needs to be purged. How to purge the the old data? This instance have other databases as well. Is there any risks involved ?

SQL server version 2016 Enterprise edition

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.

1 Answer

LeonLaude avatar image
1 Vote"
LeonLaude answered Crystal-MSFT commented

Hi @kumar-9444,

Here are two excellent articles from Kevin that should help you out:

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


Best regards,
Leon

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

@kumar-9444, Agree with Leon, we can follow Kevin's blog to clean the database. Meanwhile, we also suggest to check if there's any not used MP installed in our environment. If yes, try to remove them as well.

Hope it can help.

0 Votes 0 ·

MP means??? will follow Kevins blog

0 Votes 0 ·

MP = Management Pack.

0 Votes 0 ·

@kumar-9444,, How's everything going? If there's any update, feel free to let us know.

0 Votes 0 ·