SCCM 2012 R2 Database growing

i have migrated my sccm server 2012 R2 from one to another with different site name of course however i noticed that my new SCCM database now after 3 months of the migration become 84 GB and i didn't find any error may cause that and i used an script to define the biggest table sizes in my SCCM and found a table called process_hist consuming about 60GB and i selected top 10000 rows trying to find out its content and it seems to be operating system task sequence
any advice here my SQL server is 2012 SP1 CU4
2014-10-30-13-00-16.png
SCCM.png
SCCM2.png
Centamin-SGMAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dan McFaddenSystems EngineerCommented:
There are plenty of articles talking about runaway table growth in SCCM.  Though the table names are different, the process to clean up the tables are the same.  Here are few links to solutions that others have used:

- http://blogs.technet.com/b/configurationmgr/archive/2011/08/30/eliminating-slack-space-in-the-configmgr-2007-database.aspx
- http://myitforum.com/myitforumwp/2012/03/20/configmgr-2007-database-growing-rapidly-due-to-size-of-ts_tasksequence-table/
- http://blogs.technet.com/b/configurationmgr/archive/2009/01/27/troubleshooting-database-growth-issues-in-configuration-manager-2007.aspx

You may want to read thru the SysAdmin Operations & Maintenance section of the product documentation:

http://technet.microsoft.com/en-us/library/gg682155.aspx

Hope this helps.

Dan
0
Centamin-SGMAuthor Commented:
hi dan
thanks for your help
i already tried to do dbcc cleantable on my very large table process_hist but that query didn't delete one single row so i had to use the below query to delete all rows in that big massive table
DELETE TOP (99) PERCENT
FROM PROCESS_HIST;
but that table grows every day with approximate amount 2GB do you have any idea how to solve that
0
Dan McFaddenSystems EngineerCommented:
Can you post the content of the following file:

<ConfigMgr installation directory> \ Inboxes \ clifiles.src \ hinv \ SMS_def.mof

It may be that you have asset intelligence turned on and it can hit the process_hist table pretty hard.

Dan
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

Dan McFaddenSystems EngineerCommented:
Forget the .mof file.

Open the SCCM Console and navigate to the following location:

1. Administration > Overview > Client Settings
2. Right click on the "Default Client Settings" and select Properties
3. Select "Hardware Inventory"
4. on the right, click the "Set Classes" button
5. Slide down to an item called "Process (Win32_Process)

Is it checked?  If so, this is what is hitting the process_hist table.  You can see that the objects under this item match the table structure in table in SQL.

If you are sure you do not need this info, uncheck the box and click OK out.

Dan
0
Centamin-SGMAuthor Commented:
thanks dan
yes Process (Win32_Process) was responsible of growing that table many thanks
i also have another big table in size called HinvChangeLog any idea what this is because it's about 6 GB
0
Dan McFaddenSystems EngineerCommented:
I believe hinv = Hardware Inventory.

Have you checked that your SCCM Site Maintenance is configured to be on?  It sounds like your tables are not being cleaned up.

In SCCM Console:
1. Adminstration > Site Configuration > Click on "Sites"
2. Right-Click your site name and select "Site Maintenance"
3. The "Site Maintenance" box opens.

Our SCCM maintenance has all tasks enabled... except for the "Clear Install Flag" task which is disabled.

You can the various "Delete Aged ..." objects to see how long they stay around.  I believe the default is 90 days.  I would try reducing the time on the object "Delete Aged Inventory History."

Dan
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2012

From novice to tech pro — start learning today.

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.