Hi Anu,
what you can do in order to get more information about the workflows in your environment is:
- Exports MPs and use a tool (MP Viewer) to check those settings
- You can also generate an Effective Monitoring Configuration Report, which will show you wich rules//monitors/disocveries are running on a particular computer or even a group of computers, alonmg with all default settings and Overrides
SCOM Effective Monitoring Configuration Report
https://monitoringguys.com/2020/07/28/scom-effective-monitoring-configuration-report/
- Other performance optimiuzations
It is important to mention that most of the performance issues that arise with SCOM and its infrastructure are not related to MP, but to how the management group has been sized, build and configured. In regards to this I wrote an article, which summarizes all the configurations, whiuch can help you optimize the performance of your management group. So, if you want to start optimizing the performance of your SCOM management group, I would recommend you starting not with MPs, but with this article:
System Center Operations Manager (SCOM) Management Group Performance Optimizations
https://social.technet.microsoft.com/wiki/contents/articles/53582.system-center-operations-manager-scom-management-group-performance-optimizations.aspx
You will find out that the article covers not only DB related optimizations, but also application and OS related configurations. Afterwards, if you still have issues with performance you can move to analysing MPs.
(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)
Regards
Stoyan Chalakov