ConfigMgr 2007 - Policy and ci_sdmpackages table large and growing fast
How to eliminate slack space in the Microsoft ConfigMgr 2007 database? I have a customer with a big Microsoft Configuration Manager 2007 database (more than 25 GB). The table Policy and the ci_sdmpackages table were unusually large. I found that the disk space consumption comes from a FEP 2010 bug... I can fix this issue with the following SQL-Commands. Please make a backup of your database before you start with the execution of the commands and look for enough disk space (minimum double of database size)! Good luck! First SQL command: DELETE FROM Policy WHERE PolicyID NOT IN (SELECT PolicyID FROM PolicyAssignment WHERE PADBID IN (SELECT PADBID FROM ResPolicyMap)) AND PolicyID NOT IN (SELECT ModelName FROM CI_ConfigurationItems) AND PolicyID LIKE '%SUM_%' Second SQL command: dbcc cleantable ('(Your DB Name)','ci_sdmpackages') GO alter index CI_SDMPackages_AK on ci_sdmpackages reorganize with (lob_compaction=ON) GO alter index CI_SDMPackages_AK2