Urgent :--datapage lock vs datarow lock - 04-18-2005 , 12:59 PM
I want to convert the database from all page lock to datapage orp datarow
what are the things i should be looking out for, or what are the other
paramerts needed to set this up.
all the tables in all the databases are set to allpage locks. I do not know
if this is advisable . my production system is getting extremely slow.
thanks in advance
Re: Urgent :--datapage lock vs datarow lock - 06-22-2005 , 08:53 AM
The syntax is pretty simple (alter table tablename lock datarows), but this
is something I do when I identify a need (it's not the fastest access
method), not because the system is getting slow. Slow systems can have a
myriad of causes.
Now, if blocking has been identified as the reason the system is slow,
that's another story.
"Nik" <sqlserverkb (AT) yahoo (DOT) com> wrote