cancel
Showing results for 
Search instead for 
Did you mean: 

Performance and record locking contention

Former Member
1,359

A database I am looking after is experiencing performance problems. I think it could be contention for locks or/and hot rows.

How best would I evaluate this theory?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

I recommend looking at Dan's whitepaper on performance analysis, and the whitepaper Ivan and I wrote on capacity planning (particularly the section on convoys and lock contention).

Answers (1)

Answers (1)

Breck_Carter
Participant

Check out Foxhound: "See blocked connections"