I use SDP v 7601 on mssql
I cant do my backup because my backup DB process (ID 54) (DETAIL: ()SELECT count(*) FROM AuditFailureInfo) blockin by other SDP DB process (ID 52) with that detail: "SELECT SystemInfo.WORKSTATIONID,SystemInfo.WORKSTATIONNAME,SystemInfo.MANUFACTURER,SystemInfo.MODEL,SystemInfo.SERVICETAG,SystemInfo.BIOSNAME,SystemInfo.BIOSVERSION,SystemInfo.BIOSDATE,SystemInfo.LOGGEDUSER,SystemInfo.RAMSLOTSCOUNT,SystemInfo.ISSERVER FROM SystemInfo WHERE (SystemInfo.WORKSTATIONNAME = N'{SOME WORKSTATION}' COLLATE Ukrainian_CI_AS) ". backup stop on some (40) percent and nothing for 2 day - no error.
I have big domain and administrate only 1 OU in it . You now that Asset scaner want to scan all domain comp, so I block forein ( not mine subnet) traffic on my firewall.
When I shutdown SDP - backup do OK.
I think some process will block backup process.
On screen: SDP DB process with ID 52 block SDP backup process with ID 54. All information from Activity Monitor in MSSSQL Managment Studio.
It don't dependence from version of SDP. 3 days ago I migrate from Mysql. But after migrate all was fine and backup do perfect.
Added:
I also have big problem with adding request.