SCCM 2007 SQL table has grown too big

Posted on 2013-09-23
Medium Priority
Last Modified: 2013-11-21
Our SCCM database seems to have become too big over the last 6 months.
On checking (disk usage by top tables),  the table   dbo.INSTALLED_EXECUTABLE_HIST   takes up half the database size - 69Gb. I can't find any reference to what populates this database. Probably software inventory, but I'd like to know for sure if anyone can help? Then I can better tailor the frequency of the maintenance task and possibly reconfigure some of the client settings to reduce what is collected.

Question by:AGoodwin42
  • 4
  • 2

Expert Comment

by:George Simos
ID: 39565443
What settings do you have now in the Maintenance Tasks of ConfigMgr?
I also hope that you are backing-up your Database regularly via the internal ConfigMgr tasks so you can roll-back when needed.

Accepted Solution

George Simos earned 1500 total points
ID: 39569862
Hi again,

It seems that your issue lies in the data gathered from the Asset Intelligence component and the data you are keeping for historic reasons.
I would assume that your maintenance tasks for asset intelligence have long retention periods or they are not enabled at all!
You can find easier the problem in tables by choosing to see their dependencies, after that you will also see in which views they are used, views are prefixed as: dbo.v_XX_XXXXXXXXX_XXXXX where XX denotes the type, for example dbo.v_GS is for Hardware Inventory.
Also every Hardware Invnetory view has a history view too and is prefixed as dbo.v_HS_XXXXXXXX_XXXXXXX (where the latter two parts are the name of the component).
You can find more here but remember to ommit the dbo. prefix because views are discussed as v_XX_XXXXXXXXX_XXXXXXXX in the official docs:


Configuration Manager Hardware Inventory Views




Configure Asset Intelligence maintenance tasks

Author Comment

ID: 39580525
Hi, yes it was in Asset Intelligence. We have deselected SMS_InstalledExecutable, and after a couple of days the amount of space used has decreased from 62Gb to 58Gb, I will monitor and check to see if this trend downwards continues. Thanks. Anne
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.


Expert Comment

by:George Simos
ID: 39580536
Thanks for accepting my answer Anne!
Keep in mind that you have to setup your maintenance tasks too in order to keep your DB in great shape.
I've provided some info above.

Author Comment

ID: 39582904
Thanks, The Maintenance tasks were already set up as per Microsoft recommendations with a max 90 days on retention of this sort of data.

Expert Comment

by:George Simos
ID: 39583645
Glad to hear that!

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

While Plesk offers many potential benefits to website administrators, including compatibility with Windows Server and other leading technologies, the company has also been working to differentiate it from other control panels for content management…
There’s hardly a doubt that Business Communication is indispensable for both enterprises and small businesses, and if there is an email system outage owing to Exchange server failure, it definitely results in loss of productivity.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question