I’m having difficulty finding the source of a sql lock. I have two situations. The first is Epicor will lock up when we do a get details on a quote. The second is Epicor will also hang when trying to delete a part. During either of these instances the same record locks appear from running sp_lock3 . I can’t identify one of the sources. If I’m interpreting this correctly (emphasis on ‘if’) I see that one source is the service we use to run sql. The other is just sa with no machine name. The only thing I could think of is that a sql job is running under sa, but I couldn’t find one.
Does anyone have any suggestions?