Jump to content


North

Rapid growth of the site database

Recommended Posts

Hello everyone! I apologize in advance for my English.


SCCM 2012 R2 CU3 primary site and 5 secondary.

SQL Server 2012 R2 SP1 CU9

Autogrowth By 512 MB to Unlimited

The total number of 13,000 Clients (Srv and Wks) and 17000 (Users and groups).


DB last 3 weeks increased from 90 GB to 190 GB, the rapid growth in the day to 5GB.

I reduced the storage of data in the "Site Maintenance" in order to stop the growth. Has not changed.

What could be the reason and how to find it?

Share this post


Link to post
Share on other sites

HI

If you discovering groups and groups include other groups and user.......its give some point to DB.

 

I set user discovery on a small subset OU and told it to look in groups. Unbeknownst to me, authenticated users, or a group like it, is a member of one of those groups and my “All Users” collection is discovering waaaaaaaaaaay more users than sccm needs to have in it..

kind regard

Safet Grahic

http://www.learnmesccm.com/

https://www.linkedin...ahic/a0/842/b21

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.