hey,
the last few weeks we noticed that our SCCM Database (SCCM Version: 5.0.7958.1604; SQL Version: 11.0.5058) grow about from ca. 100 GB to up currently 230 GB + 30GB logfile.
We are supporting an environment of about 14000 Systems and 18000 users.
The hardware inventory size foreach client is about 5MB for full inventory
We are using one primary site and two secondary sites currently.
Having a look at our database in detail there is one table: "DBMON_RunningQueries" with a data (not index) size of 152652504 KB (about 145GB)
Is this 'normal'?
Any ideas why this table is as big as it is?
Thank you in advance
Kind Regards
mk-maddin
- Edited by MK-Maddin 21 hours 4 minutes ago