on 2011 Jul 29 12:18 PM
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!
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check out Foxhound: "See blocked connections"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.