question

BoopathiSubramaniam-6294 avatar image
0 Votes"
BoopathiSubramaniam-6294 asked saldana-msft edited

SCCM SQL Database Index


Hello,

I am trying to do SCCM database index as per the below procedure
https://stevethompsonmvp.wordpress.com/2016/11/29/optimizing-sccm-databases-revisited/

I have below doubts and please assit

  1. There is a CAS and Primary. Where to start the Indexing? is from CAS Database at the first or In the Primary database

  2. If SCCM Cosole is opened during the database indexing then will it affect any opeartions in the Console


  3. Indexing the database will cause any loss of data in the database



mem-cm-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Garth avatar image
0 Votes"
Garth answered BoopathiSubramaniam-6294 commented
  1. You need to index all of them, order doesn't matter.

  2. No it will not affect the indexing

  3. No you will not lose data.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello Garth,


What are the pre-requesite before I start the Indexing

How do I duplicate the SCCM database to perform the test before doing the indexing in actual database

How to check the health of the SQL before start the indexing and after complete of the indexing

0 Votes 0 ·