Thursday, 30 June 2016

Troubleshooting a Configuration Manager Site Database Server

This is the database server that hosts the Microsoft SQL Server 2008 Service Pack 1 database. There is one database that holds all information about inventory, packages, status, and all the other pertinent data of System Center Configuration Manager 2012 R2. The following logs provide insight into the health of the database server: 

smsdbmon.log : This log shows all activities such as inserts, updates, drops, and deletes from the Configuration Manager 2012 R2 database.
smsprov.log : This log shows the SQL transaction calls made from the Configuration Manager console or automation scripts via the SDK.

No comments:

Post a Comment