Solved

SCCM Database

Posted on 2016-08-06
6
77 Views
Last Modified: 2016-08-12
My SCCM database is around 190 GB and still growing? Can some one suggest best way maintain SCCM DB? I am using SQL 2014 SP2 with SCCM 1602 now
0
Comment
Question by:asnagesh
  • 3
  • 3
6 Comments
 
LVL 17

Expert Comment

by:Mike T
ID: 41746413
Hi,

That sounds massive. Have you got software inventory turned on and are you collecting files or something? I've worked on several 5000 seat sites and the DB is less than 10GB.

As for maintaining the DB, you need to look at several SQL scripts by Ola Hallengren. His scripts are now the de facto way to look after SQL:

https://ola.hallengren.com/

The other thing to look at is whether your DB is set to Full or SImple mode. You don't want full. It is only meant for databases where you would want/need to replay actions, like finance. CM does not need that and yes, it bloats the logs a lot. I had to cleanup the mess from a predecessor for SCOM and the logs went from 20GB to 2GB.

Mike
0
 

Author Comment

by:asnagesh
ID: 41746694
only default settings are enabled and software inventory will capture the exe file information from computers but it does not capture the entire files.  When I click on shrink I am getting 43% free space. can I shrink sccm database?
0
 
LVL 17

Accepted Solution

by:
Mike T earned 500 total points
ID: 41747113
OK, I forgot to ask - how many computers does CM manage? Also are you just talking about the Transaction Log? If so, as I said CM doesn't want it, doesn't need it. At all.

Many DBA's mistakingly think that an SMS/SCCM database needs to be handled like a transactional database, which it is not. Database recovery mode should be set to simple... in other words, we do not want the transaction log file for anything!

Ref: from MS tech answers

So the answer is yes you can BUT do a full SQL backup first.
then do a full CM backup.

Then check/validate both backups are GOOD backups by restoring to another box.

Note: I've used shrink personally on the SCOM transaction log and it worked perfectly but never on SCCM. I believe neither make full use of it, so it's just there to satisfy SQL.

I would get a second opinion if I were you, rather relying on my word alone :).

Mike
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:asnagesh
ID: 41747120
1. I have 1000 clients
2. I am talking about CM database not the transaction log
3. Recovery Model is simple
0
 

Author Comment

by:asnagesh
ID: 41747121
sorry it is not 1000, it is 10000 clients
0
 
LVL 17

Expert Comment

by:Mike T
ID: 41747384
OK - 190GB still sounds big to me for 10K machines.

If you're talking about the CM I would definitely get a second opinion.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now