Unable to retrieve query plan of running query because of blocking
Try flipping this predicate from

where object_name ( s2.objectid, s2.dbid) = 'sp_name'  


to something like

where object_id = object_id('sp_name')


You might get a simpler plan that aviods whatever resource is blocked in TempDb.