SOLVED Database Growth after CMG Creation

[Ickis99]

I have seen at several Configuration Manager Installations, that after the Configuration of a new Cloud Management Gateway, the CM Database starts continually growing. Looking at the Top Tables Report in SQL, the culprit is the dbo.SCCM_Audit Table with tenthousands of Similar entries referring to the new CMG.

None of the default Maintenance Tasks of SCCM seems to delete old Audit Entries. My question is, is it safe to implement a Script that deletes these entries directly in the SQL Table (at least entries older than 60 days or something like that) or is there a better solution for this problem?

Most Constellations where i have seen this are already on 2111 with Rollup and the CMG is already Virtual Scale Set but it seems like there is the same problem with classic CMGs.

Thank you.

 

[Prajwal Desai]

Yes, this is a known thing and I had seen this happening in my lab too. Now, I would suggest you log case with Microsoft support as you introducing changes to DB is not recommended.
You may run that script but again it is better if the confirmation comes from MS support.

 

[Ickis99]

Thank you. At least i am not the only one with this problem. I guess i will open a case to be safe.

Maybe the fix will even be included in the Summary of changes for 2203 if i´am really lucky.

 

[kentmj]

I am encountering this as well. Has there been a posted resolution to this?

 

[Ickis99]

Hello! In the end MS acknowledged, that this is indeed a SCCM Bug and will be fixed in a future release. I hope it will be included in the 2207 Summary of changes, which will be released soon, but who knows?

In the meantime i execute a weekly script at my affected customers SCCM Database, essentially deleting these entries, which are older than 60 days

delete from SCCM_audit where tablename=N'Azure_Service' and DATEDIFF(day,getdate(),ChangeTime) < 60

I hope this helps.

 

[kentmj]

Great, thank you!