Hi everyone, Lee Stevens here, and I’d like to take a minute to show you a quick tip on how to eliminate slack space in the ConfigMgr 2007 database. Sometimes System Center Configuration Manager 2007 may leave a lot of slack space in the database when Software Updates has been processed. If your database has been growing by leaps and bounds and you notice that the majority of the space has been taken up in the ci_sdmpackages table, this script may be of use to you.
Keep in mind that you will need a good backup first. As always, this is not officially supported and I take no liability if anything good or bad happens to you. Although, I will take credit for the good if you let me. :) Keep all arms and legs in the vehicle as this script runs - it may take a while, so be patient. Once you're finished, you can then look at the database properties and see a lot of slack space. You can then shrink these files to reclaim the space.
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 on ci_sdmpackages reorganize with (lob_compaction=ON) GO
alter index CI_SDMPackages_PK on ci_sdmpackages reorganize with (lob_compaction=ON) GO
You will then need to shrink the database, and the space will be reclaimed.
Lee Stevens | ConfigMgr/OS Deployment | Microsoft Corporation
App-V Team blog: http://blogs.technet.com/appv/ AVIcode Team blog: http://blogs.technet.com/b/avicode ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/ DPM Team blog: http://blogs.technet.com/dpm/ MED-V Team blog: http://blogs.technet.com/medv/ OOB Support Team blog: http://blogs.technet.com/oob/ Opalis Team blog: http://blogs.technet.com/opalis Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/ OpsMgr Support Team blog: http://blogs.technet.com/operationsmgr/ SCMDM Support Team blog: http://blogs.technet.com/mdm/ SCVMM Team blog: http://blogs.technet.com/scvmm Server App-V Team blog: http://blogs.technet.com/b/serverappv Service Manager Team blog: http://blogs.technet.com/b/servicemanager System Center Essentials Team blog: http://blogs.technet.com/b/systemcenteressentials WSUS Support Team blog: http://blogs.technet.com/sus/
Hi, I have had the dbo.INSTALLED_EXECUTABLE_HIST table grow way too big too quickly recently, it takes up over half the database size. Do you happen to know what SCCM function populates this table? Software/hardware inventory is what I suspect, but I've reduced the retention of this history to 90 days from 360 without seeing any decrease in the table size.