We are performing a migration of 3rd party data and it is hanging.
When we investigate we see SPID 38 (a system/background SPID) is the blocking user SPIDs trying to do the migration. Unfortunately, the SQL_Text from sp_whoisactive (or even activity monitor) is NULL for SPID 38. The wait_info is
Is there anyway to tell what 38 is trying to do?
It's using a Windows-based tool the 3rd party has given us. I took a backup of the data, restored it on this new server (so the database and its contents are accessible and working). Then we run this tool to do the upgrade to their new version of the software and that is where we are getting the blocks.
sp_WhoIsActive @get_locks = 1 returns a really long XML (4k characters too long to post).