A customer is complaining about big problems with locked tables.
"Table X is locked by another user".
Lock timeout is 10s.
Running SQL Profiler logging event lock:timeout, I do catch several timeouts and information about who was locked. But there is no information about which session that is locking the table.
By executing T-SQL command sp_who2 there is a column "blocked_by". In Navision session overview there is a column "Blocking connection ID" this information would be very useful.
Can SQL Profiler show info about "blocked_by" or is there any other logging tool that can do this?
SQL 2000, Navision 4.00 SP3, 70Gb DB, 70 active users.