session_id blocking_session_id status command wait_type wait_time wait_resource DatabaseName host_name program_name login_name transaction_begin_time SqlText
62 0 suspended SELECT CXPACKET 1029 legal_cloud SERVERAPP Core .Net SqlClient Data Provider NULL (@__user_UserId_0 int)SELECT COUNT(*) FROM [JurisdictionRequest] AS [x] WHERE ([x].[Partner_ID] = @__user_UserId_0) AND ([x].[Portfolio_Id] > 0)
79 0 suspended SELECT CXPACKET 1718 legal_cloud SERVERAPP Core .Net SqlClient Data Provider NULL (@__user_UserId_0 int)SELECT COUNT(*) FROM [JurisdictionRequest] AS [x] WHERE ([x].[Partner_ID] = @__user_UserId_0) AND ([x].[Portfolio_Id] > 0)