Viewing 5 posts - 1 through 6 (of 6 total)
Hi all, just a little update.
by using SQL profiler I managed to see exactly what the 2 transactions involved in the deadlock were doing. One is a user sign...
April 7, 2016 at 11:38 am
Hi all, already thanks a lot for your insights and feedback! 🙂
I managed to reproduce the deadlock in our test-environment (containing 100+ VMs running the server application(s) and 10000s of...
April 6, 2016 at 11:53 am
Jacob, thanks for taking the time to both clearly explain and give an example. I must say everything you say makes sense and would explain where the RangeI-N comes from....
April 6, 2016 at 10:18 am
TheSQLGuru (4/6/2016)
This really does appears to be the "simple", classic deadlock scenario. Opposing granted and requested incompatible locks.
Ok, I'm glad at least so far we're on the same page! How...
April 6, 2016 at 9:12 am
Not a problem TSG! I appreciate your feedback and have added the clustered and 2 other index create statements!
You'll get to it when you get to it, if ever...
April 6, 2016 at 7:54 am
Viewing 5 posts - 1 through 6 (of 6 total)