jotate

Forum Replies Created

Viewing 12 posts - 1 through 12 (of 12 total)

RE: Row locks not escalating to table locks after 5000

GilaMonster (7/18/2015)
I think this needs writing up in more detail. JT, do you have a blog? Do you want to write this up or may I?
I've been meaning to start...

July 18, 2015 at 11:03 am

#1813509
RE: Row locks not escalating to table locks after 5000

Jacob Wilkins (7/18/2015)
It could also be that both explanations are wrong. If you have tests or documentation showing those explanations are wrong, I welcome that! It's how all this testing...

July 18, 2015 at 9:03 am

#1813492
RE: Row locks not escalating to table locks after 5000

Jacob Wilkins (7/17/2015)
Thanks for pointing out that article Gail!
From Microsoft's response in the Connect item Adam mentioned:
Adam: This is a regression in lock escalation algorithm in SQL2008. We...

July 17, 2015 at 3:57 pm

#1813454
RE: Row locks not escalating to table locks after 5000

GilaMonster (7/17/2015)
jotate (7/17/2015)
It looks like this may just be the way that it worked in 2008 R2, and the "grab a table lock after 5000 page locks" was implemented in...

July 17, 2015 at 2:29 pm

#1813434
RE: Row locks not escalating to table locks after 5000

jotate (7/17/2015)
I'm going to find a test box with 2008 R2 SP4 and see what happens.
It looks like the latest SP for 2008 R2 is SP3 (unless I'm missing something:...

July 17, 2015 at 1:30 pm

#1813416
RE: Row locks not escalating to table locks after 5000

jotate (7/17/2015)
Just for curiosity's sake, I'm going to try to recreate that "huge number of row locks upon insert" scenario with as few variables as possible to verify that's just...

July 17, 2015 at 9:48 am

#1813357
RE: Row locks not escalating to table locks after 5000

GilaMonster (7/17/2015)
Just make sure you change them back immediately after the insert, or you may have some nasty blocking problems.
As for service pack, that server really needs to be upgraded....

July 17, 2015 at 7:47 am

#1813289
RE: Row locks not escalating to table locks after 5000

jotate (7/16/2015)
GilaMonster (7/16/2015)
Ack, I just read your first post again. Change the locks value back to 0. That's not the number of locks on an object which triggers an escalation...

July 16, 2015 at 12:35 pm

#1813108
RE: Row locks not escalating to table locks after 5000

GilaMonster (7/16/2015)
Ack, I just read your first post again. Change the locks value back to 0. That's not the number of locks on an object which triggers an escalation (which...

July 16, 2015 at 12:06 pm

#1813096
RE: Row locks not escalating to table locks after 5000

GilaMonster (7/16/2015)
Possibly because there are other locks on the table. Escalation isn't guaranteed, if there are any incompatible locks on the table, the escalation will fail and the original locks...

July 16, 2015 at 10:39 am

#1813069
RE: Row locks not escalating to table locks after 5000

Sean Lange (7/16/2015)
10 million rows across a link server is going to be slow no matter how you do it. I would suggest that doing your inserts in batches would...

July 16, 2015 at 9:57 am

#1813043
RE: Who Watches the Watchers?

Working in healthcare tech, this cuts to the core of my struggles with HIPAA compliance. The legislation requires you to log every access of "sensitive patient information" which includes...

October 16, 2014 at 7:10 am

#1752849

Viewing 12 posts - 1 through 12 (of 12 total)