Hello,
i am new here in this forum. I work with Dell Client Manager 2.x/3.x and manage about 1000 PCs.
The NS7 runs in a VM on a ESX-Cluster and the Database is located on a phys. machine.
I noticed that the network-traffic between NS7-VM and the db-server increases steadily over weeks. This is the same with the cpu-usage: it grows steadily over weeks.
Aftter some investigation with sql enterprise manager i found that the NS7 periodically sends the query "select Id, CollectionGuid, ResourceGuid, Removed from [dbo].CollectionMembershipChanges where Id > @LastChangeID order by [Id] asc" and this query creates alot if traffic.
The relevant table CollectionMembershipChanges on my system contains about 2 600 000 lines after about 1month NS7 being productive. I pruned the table and now the perfomance of the system and the network traffic went back to "normal".
My question is: Is it ok to clear the table? Is it intentional, that the table mentioned above is filling up? I did not find any settings to prune the table or limit the count of lines.
Greetings, Th0u