We are looking to adjust the start time of our SCCM integration to an much earlier time. The SCCM team does not really want to do this as they are cautious about the SCCM PROD environment. We need to provide actual data to make this decision. The MS-SQL support team stated they can monitor the queries but need to know what the queries are in order to understand the load (helps them identify the exact resource consumption).
What queries are ran as part of this integration? What is the expected resource consumption on the database server? Are there particular logs on the MS-SQL database that would help identify the connection and resource consumption?
May 20, 2022 09:39 AM
@king_nolan - From your post, it seems like you are ALREADY connecting to SCCM, you are just moving it to an earlier time.
Therefore, your SCCM/SQL Server resources should already be able to monitor the impact during the current scheduled extracts - correct?
May 20, 2022 09:41 AM
Correct. SQL team has asked what the queries are so they can monitor and check logs. They sent the below pic as what they could see at the start time of our integration.
May 20, 2022 09:57 AM
The queries executed against the SCCM database are contained with XML configuration files in the following directory on the server that is used to connect to SCCM: C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Reader\SMS
In particular, the readers in these files that have a type of as "ExecuteOnSource" or "SourceToTarget" are executed against the SCCM database.
May 23, 2022 12:13 AM