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

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 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

Fix Error 30105 Citrix servers do not trust the server message in XenDesktop 5.5

When you login to your web interface and launch a new desktop, it might not launch and you might get this error in the application event log on the server: Source: Citrix Web Interface Event ID: 30105   The Citrix servers do not trust the server. This message was reported from the XML Service at address http://localhost/scripts/wpnbr.dll [com.citrix.xml.NFuseProtocol.RequestAddress].   [Unique Log ID: xxxxxxxx] In XenDesktop 5.0 and 5.5 can you fix the problem with the follow steps: Oper PowerShell with admin rights Import all citrix snap-ins with this command asnp citrix.* Add-PSSnapin citrix.* You can enable the XML Trust with this command Set-BrokerSite -TrustRequestsSentToTheXmlServicePort $true After this 3 steps the lauch it should come right up and there are no more errors in the log. How to Add XenDesktop Cmdlets into Powershell -> Video
Read more