Share via

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

Anonymous
2017-05-16T21:47:24+00:00

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.
Microsoft 365 and Office | Install, redeem, activate | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2017-05-17T08:52:50+00:00

    Hi,

    Private Message sent.

    Regards.

    Was this answer helpful?

    0 comments No comments