Maintaining a healthy site

This section describes some general tasks that a Configuration Manager administrator should carry out in order to maintain a healthy site. Housekeeping is a very important aspect of the job.

Database indexing

Fragmented indexes cause performance issues with SQL databases, and it gets worse over time. It is crucial to perform regular reindexing of the Configuration Manager database. How will you know if you have excessive fragmentation? Execute the following T-SQL command on your database:

DBCC Showcontig

You can see the results of this command in a test lab shown in the following screenshot. In the lab, there is no issue with fragmentation. However, it's very different in the real world. If the site database is fragmented more than 10 percent, then you need to take action and rebuild the indexes:

You could configure the built-in database reindexing maintenance task. However, in our opinion, this is not the optimal solution. It is more efficient to use a script...