Hi Gail,

ops I didn't see your answer it was in the next page 😉

Yes it's in the same session, I also see it if I run in Management Studio,...

Just one more little question ..

I was able to map the trace output with the sp_lock output and it matches except for a thing.

The query is a simple merge statement...

Ok it's in sys.partitions!

The key was using the correct db 🙂

Thanks a lot!

You can find attached what's in objectId and objectId2.

Since the first is 0, let's take the second which is 72057594042384384

Now, if I run:

use master

select * from sys.objects where object_id=72057594042384384

select *...

Thanks Gail,

I tried with lock acquired event and enabled all columns but I'm not able to see the indexes where the locks are acquired, do you know where I can...

Thanks!

Could you please suggest the profiler trace settings to get to this information?