Hello!
There was
a problem the following lines: I'm going to bookmark Inventory - run a scan: Detected workstations and during the search on the database server starts a process to block another, then the next and previous blocks, ad infinitum until it falls SD.
Software Version: 8.0.0.8007

Here is an example of a process that is blocking:

----- DBCC INPUTBUFFER ----------------------

SELECT Task_Input.INSTANCE_ID,Task_Input.SCHEDULE_ID,Task_Input.WORKFLOW_TEMPLATE_ID,Task_Input.SCHEDULE_TIME,Task_Input.EXECUTION_START_TIME,Task_Input.EXECUTION_FINISH_TIME,Task_Input.WORKENGINE_ID,Task_Input.ADMIN_STATUS,Task_Input.OPERATIONAL_STATUS,Task_Input.SERVER_ID,Task_Input.CRID FROM Task_Input WHERE  (Task_Input.INSTANCE_ID = 18001)

----- END DBCC ------------------------------

Here's a sample of the process:

----- DBCC INPUTBUFFER ----------------------

SELECT Resources.RESOURCEID,Resources.RESOURCENAME,Resources.ACQUISITIONDATE,Resources.WARRANTYEXPIRY,Resources.EXPIRYDATE,Resources.COMPONENTID,Resources.ASSETTAG,Resources.SERIALNO,Resources.BARCODE,Resources.PURCHASELOTID,Resources.VENDORID,Resources.RESOURCESTATEID,ResourceLocation.RESOURCEID,ResourceLocation.REGIONID,ResourceLocation.SITEID,ResourceLocation.BUILDINGID,ResourceLocation.FLOORID,ResourceLocation.ROOMID,ResourceLocation.LOCATION FROM Resources INNER JOIN ComponentDefinition ON Resources.COMPONENTID=ComponentDefinition.COMPONENTID INNER JOIN ComponentType ON ComponentDefinition.COMPONENTTYPEID=ComponentType.COMPONENTTYPEID LEFT JOIN ResourceLocation ON Resources.RESOURCEID=ResourceLocation.RESOURCEID WHERE  ((ResourceLocation.SITEID IS NULL) AND (ComponentType.COMPONENTTYPENAME != N'Software' COLLATE Cyrillic_General_CS_AI))

Thanks in advance!