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 ...
Get Troubleshooting System Center Configuration Manager now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
