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 on ci_sdmpackages
reorganize with (lob_compaction=ON)
GO
alter index CI_SDMPackages_PK on ci_sdmpackages
reorganize with (lob_compaction=ON)
GO

 You can find more information about the second SQL command under the following hyperlink -> http://blogs.technet.com/b/configurationmgr/archive/2011/08/30/eliminating-slack-space-in-the-configmgr-2007-database.aspx
Location: Bern, Schweiz

Comments

Post a Comment

Popular posts from this blog

How to fix the check box on RDWeb 2012 for use private computer

Image
It is hard when you use the RDWeb interface internally only and you must activated the checkbox " I am using a private computer that complies with my organization's security policy. " each time. Do you want to activated the checkbox by default, you must make the following points. Go to C:\Windows\Web\RDWeb\Pages\en-US or other language Open the file "Default.aspx" with admin rights Go to line 32 with the content " public bool bShowPublicCheckBox = false, bPrivateMode = false, bRTL = false; " Change the value from bPrivateMode from false to true Save Example:  public bool bShowPublicCheckBox = false, bPrivateMode = true, bRTL = false;
Read more

How to set custom RDP Settings in Windows Server 2012

Image
I can't find any place to set the Custom RDP Settings on my Windows Server 2012 Connection Broker. I also looked in the wrong place, because the settings are "only" set via PowerShell and I look in the GUI. Open PowerShell with admin rights Import the remote desktop service module ->  Import-Module RemoteDesktopService Type the following command: Set-RDSessionCollectionConfiguration -CollectionName XXXX -CustomRdpProperty "authentication level:i:0 pre-authentication server address:s:https://XXXX.XXXX.XXX/rdweb require pre-authentication:i:1" The example is for the configuration of RDS in connection with TMG. Conclusion : Not in the GUI but in PowerShell! :-)
Read more

SCCM 2012 Software Center returned error code 0x0041013 (-2147217389)

After an update from SCCM 2007 client to SCCM 2012 client, there is sometimes show the error "Loading Software Center returned error code 0x80041013 (-2147217389)." in Software Center. This even though the client was successfully installed. I think this error is because not all parts of the old SCCM clients have been properly removed. You can fix this issue with the following steps: Open registry Go to  HKEY_CLASSES_ROOT\CLSID\{555B0C3E-41BB-4B8A-A8AE-8A9BEE761BDF}\InProcServer32 Check the value for Default is C:\WINDOWS\CCM\ccmcisdk.dll (if not, change the value) Go to  HKEY_CLASSES_ROOT\Wow6432Node\CLSID\{555B0C3E-41BB-4B8A-A8AE-8A9BEE761BDF}\InProcServer32 Delete the value in Default (value is C:\Windows\SysWOW64\CCM\dcmsdk.dll) You can launch the software center again and you can see the applications without the error message.
Read more