Our zcm environment has been running since 2009 and seen many upgrades. Currently we are on zcm11.2.4, mssql 2008 r2, zpm is enabled. Noticing zcc is running slower on all the primaries. Doing any kind of action is taking more time. This could be assigning or deleting bundles, creating bundles running reports, etc. We don't have a large number of unnecessary bundles or polices lingering. Thinking the source of issue is the DB but have not noticed the DB server usage getting out of hand yet.

Going through some of the tids its mentioned the nc_compchanges table grows and becomes an issue. Our table is at 1.3million, would that be considered a problem? The zdeleted device table is up over 4000 and we only have about 2600 devices managed by zenworks.