When I am in a transaction and an an error forces me to issue a rollback, my
database effectively locks up.
I have the feeling that isolation level fine tuning will assist me with this
situation.

Which Isolation level would be beneficial to me during a rollback event?