Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 161
  • Last Modified:

SCCM Database

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
asnagesh
Asked:
asnagesh
  • 3
  • 3
1 Solution
 
Mike TLeading EngineerCommented:
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
 
asnageshAuthor Commented:
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
 
Mike TLeading EngineerCommented:
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: 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.

 
asnageshAuthor Commented:
1. I have 1000 clients
2. I am talking about CM database not the transaction log
3. Recovery Model is simple
0
 
asnageshAuthor Commented:
sorry it is not 1000, it is 10000 clients
0
 
Mike TLeading EngineerCommented:
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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now