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

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

How to publish the remote desktop session servers to RDWeb under RDS 2012

You can find the setting for publishing the Remote Desktop Session Server Desktop under: Server Manager Remote Desktop Services Collections CollectionName Tasks Edit Properties General tab But you can not change this setting in this wizard! Under Windows Server 2012 RDS you can only publish Desktops or RemoteApps, but not both. :-( If you would like to bypass this limitation for session collections only, you may consider changing the following registry value on your Remote Desktop Connection Broker (RDCB): Open the Registry-Editor Go to the following path:  HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Terminal Server\CentralPublishedResources\PublishedFarms\<collection>\RemoteDesktops\<collection> Open the REG_DWORD " ShowInPortal " Change the value data from 0 to 1 After this change you can see the desktop in RDWeb. :-)
Read more