Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SCCM Database

Posted on 2016-08-06
6
Medium Priority
?
151 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 19

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 19

Accepted Solution

by:
Mike T earned 2000 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

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 19

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

An article on effective troubleshooting
Adding Computers to AD groups through an SCCM Task Sequence
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

971 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