Simulating DEADLOCKS for Performance Tuning/Troubleshooting

Simulating DEADLOCKS for Performance Tuning/Troubleshooting

 

  

Hi all,

I know, I've asked this before but unfortunately, my mail box got
cleanup/archive by accident. Am trying to check on performance
tuning/troubleshooting, can anyone tell me how to simulate a deadlock
which I will of course kill the other session that is causing it.

Cheers,


EDWIN ONG UY
\\|//
(o o)
^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^

"Choose a job you love, and you will never have to work a day in your
life." --Confucius
"How do I work? I grope." -- Albert Einstein
"Experience is the best teacher, enrolling in the class is the biggest
problem." -- Anonymous


MS Sql Server LazyDBA home page