I was helping troubleshoot SCOM performance issues with a customer yesterday and came across something which could be contributing to the performance problems they’re experiencing.
They’re monitoring a large SQL estate, including a lot of SQL clusters (around 800). It seems that the SQL MP (2014 , but possibly also others) is creating a (sub)-group for each of those clustered pairs (ie. around 800 Groups, just for the SQL clusters) .
Is anyone familiar with this and, if so, have they seen it cause any performance problems in their or other environments? Thanks 🙂
It does indeed create a lot of groups, but i cannot see we have sub groups for each and every SQL Cluster. We do have always on availability group objects within the SQL Server Always On Availability Group, but no sub groups.
Altough, Windows Clusters does have individual group objects, could that be it? Also, dynamic group calculation can be performance impacting when you have a large number of groups/complex querys. Originally calculation run often (every 60sec or so) we have set this to 15 minutes.