SCCM- QL Server instance Database - Session 114 has been blocking other sessions

Question

Hi Community, I have a weird problem on SCCM, my DB team always getting alert that SCCM SMS_OBJECT_REPLICATION_MANAGERblocking the database following is the error I did the investigation but couldn't find anything any suggestion? 5/7/2017 1:28:30 AM, Blocking Session Wait Time (Seconds) on Database is Critical.

SQL Server instance Database - Session 114 has been blocking other sessions for 322 seconds, since 5/7/2017 5:22:14 AM (UTC).

The session is being run on database [CM_XXXX] with application name 'SMS_OBJECT_REPLICATION_MANAGER' by user 'XXX\XXXXX$' on host 'Servername'. 

<br/> <br/> Last command issued at 5/7/2017 5:22:14 AM (UTC): 

select IsDeployable FROM vSMS_SoftwareUpdate AS vSMS_SoftwareUpdate where CI_ID = 16826432 

Blocking Session Wait Time (Seconds): Time in seconds that a SQL Server session has been blocking other sessions. Select the "Non-Query activities>Capture Blocking (SQL 2005+)" check box to retrieve the blocking sessions report for SQLdm.

5/7/2017 1:25:23 AM, Blocking Session Wait Time (Seconds) on SIMON is Warning.

SQL Server instance SIMON - Session 114 has been blocking other sessions for 172 seconds, since 5/7/2017 5:22:15 AM (UTC).

The session is being run on database [CM_XXXXX] with application name 'SMS_OBJECT_REPLICATION_MANAGER' by user 'XXX\XXXXX$' on host 'XXXXX'. 

<br/> <br/> Last command issued at 5/7/2017 5:22:15 AM (UTC): 

SELECT ISNULL(DATALENGTH(XText),0), XText from (select CONVERT(varbinary(max),Body) as XText FROM vSMS_CIDocuments WHERE CI_ID=16824470 and DocumentType=0) as XTable

Blocking Session Wait Time (Seconds): Time in seconds that a SQL Server session has been blocking other sessions. Select the "Non-Query activities>Capture Blocking (SQL 2005+)" check box to retrieve the blocking sessions report for SQLdm.

Answer 1

Hi,

Private Message sent.

Regards.